ibatisNet带输出参数的存储过程的调用

Procedure:

create proc sp_output  (      @testParam    int    output  )  as  begin      set @testParam = 10 end  go

 

 XML:

﹤parameterMaps﹥
    ﹤parameterMap id="select-params2" class="Hashtable"﹥
      ﹤parameter property="testParam" column="testParam" direction="Output" /﹥
    ﹤/parameterMap﹥
  ﹤/parameterMaps﹥
   ﹤statements﹥
     ﹤procedure id="GetAccountViaSP2" parameterMap="select-params2"﹥
      sp_output
    ﹤/procedure﹥
  ﹤/statements﹥

 

 Code:

int testid = 0;

Hashtable map = new Hashtable(); 

map.Add("testParam", testid);  

mapper.Insert("GetAccountViaSP2", map);  

Console.WriteLine(map["testParam"].ToString());

本文来自: IT知道网(http://www.itwis.com) 详细出处参考：http://www.itwis.com/html/net/netother/20100715/8792.html