大森林的专栏(Jack Wu)

换个心情,呼吸一下新鲜的空气!

IBatisNet系列-执行存储过程

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

        }
 
阅读更多
个人分类: IBatis框架学习
想对作者说点什么? 我来说一句

IBatisNet系列-执行存储过程

zgqtxwd zgqtxwd

2008-04-24 06:59:00

阅读数:86

没有更多推荐了,返回首页

加入CSDN,享受更精准的内容推荐,与500万程序员共同成长!
关闭
关闭