WEB开发网
开发学院WEB开发ASP.NET IBatisNet系列-执行存储过程 阅读

IBatisNet系列-执行存储过程

 2006-03-26 17:05:42 来源:WEB开发网   
核心提示:映射xml文件书写如下<?xml version="1.0" encoding="utf-8" ?><sqlMap namespace="Member" xmlns:xsi="http://www.w3.org/2001/XMLSc

映射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

Tags:IBatisNet 系列 执行

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接