iBATIS.NET执行存储过程是怎么进行的呢？那么我们就开始我们的讲解：

首先我们看看XML的配置，映射XML文件书写如下

﹤?xml version="1.0" encoding="utf-8" ?﹥  
 
﹤sqlMap namespace="Member" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="SqlMap.xsd"﹥  
    ﹤resultMaps﹥  
        ﹤resultMap id="SelectResult" class="PlatAdmin.Model.Member"﹥  
            ﹤result property="Id" column="id" /﹥  
            ﹤result property="Identityno" column="identityno" /﹥  
            ﹤result property="Telephone" column="telephone" /﹥  
            ﹤result property="Email" column="email" /﹥  
            ﹤result property="Linktel" column="linktel" /﹥  
            ﹤result property="Address" column="address" /﹥  
            ﹤result property="Content" column="content" /﹥  
            ﹤result property="Username" column="username" /﹥  
            ﹤result property="Password" column="password" /﹥  
            ﹤result property="Truename" column="truename" /﹥  
            ﹤result property="Enable" column="enable" /﹥  
            ﹤result property="Regdate" column="regdate" /﹥  
        ﹤/resultMap﹥  
    ﹤/resultMaps﹥  
          
    ﹤parameterMaps﹥  
        ﹤parameterMap id="swapParas" class="PlatAdmin.Model.Member"﹥  
            ﹤parameter property="querystr" column="" /﹥  
            ﹤parameter property="keyfield" column="" /﹥  
            ﹤parameter property="pagesize" column="" /﹥  
            ﹤parameter property="pagenumber" column="" /﹥  
        ﹤/parameterMap﹥  
    ﹤/parameterMaps﹥  
      
    ﹤statements﹥  
        ﹤procedure id="GetMemberList" parameterMap="swapParas" resultMap="SelectResult"﹥  
            usp_GetRecordset  
        ﹤/procedure﹥  
 
          
    ﹤/statements﹥  
﹤/sqlMap﹥ 

iBATIS.NET执行存储过程实例程序代码如下:

public IList GetMemberList(string querystr,int pageNo)  
        {  
            Hashtable ht = new Hashtable();  
            ht.Add("querystr",querystr);  
            ht.Add("keyfield","id");  
            ht.Add("pagesize",2);  
            ht.Add("pagenumber",pageNo);  
 
            SqlMapper sqlMap = IBatisNet.DataMapper.Mapper.Instance();  
 
            try 
            {  
                return sqlMap.QueryForList("GetMemberList",ht);  
            }  
            catch(Exception e)  
            {  
                throw new IBatisNetException(e.Message,e);  
            }  
        } 

iBATIS.NET执行存储过程实例的情况就介绍到这里，希望对你有所帮助。

【编辑推荐】

1. iBATIS教程之like语句的写法浅析
2. iBATIS.NET多数据库支持浅析
3. iBATIS教程之如何获得output参数值
4. iBATIS.NET处理多参数的SQL语句的配置
5. iBATIS.NET与VS 2005进行单元测试浅析