iBATIS.NET執(zhí)行存儲過程是怎么進行的呢？那么我們就開始我們的講解：

首先我們看看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執(zhí)行存儲過程實例程序代碼如下:

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執(zhí)行存儲過程實例的情況就介紹到這里，希望對你有所幫助。

【編輯推薦】

1. iBATIS教程之like語句的寫法淺析
2. iBATIS.NET多數據庫支持淺析
3. iBATIS教程之如何獲得output參數值
4. iBATIS.NET處理多參數的SQL語句的配置
5. iBATIS.NET與VS 2005進行單元測試淺析