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执行存储过程实例的情况就介绍到这里，希望对你有所帮助。
【编辑推荐】
