IBatisNet系列-执行存储过程

最新推荐文章于 2019-06-22 00:07:33 发布

zgqtxwd

最新推荐文章于 2019-06-22 00:07:33 发布

阅读量281

点赞数

分类专栏：网络技术文章标签：存储 exception encoding email class string

网络技术专栏收录该内容

3537 篇文章 0 订阅

订阅专栏

映射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>
程序代码如下:

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);
}
}

出处：福娃莹莹 BLOG