映射xml文件书写如下

%26lt;?xml version=1.0 encoding=utf-8 ?%26gt;

%26lt;sqlMap namespace=Member xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance xsi:noNamespaceSchemaLocation=SqlMap.xsd%26gt;
%26lt;resultMaps%26gt;
%26lt;resultMap id=SelectResult class=PlatAdmin.Model.Member%26gt;
%26lt;result property=Id column=id /%26gt;
%26lt;result property=Identityno column=identityno /%26gt;
%26lt;result property=Telephone column=telephone /%26gt;
%26lt;result property=Email column=email /%26gt;
%26lt;result property=Linktel column=linktel /%26gt;
%26lt;result property=Address column=address /%26gt;
%26lt;result property=Content column=content /%26gt;
%26lt;result property=Username column=username /%26gt;
%26lt;result property=Password column=password /%26gt;
%26lt;result property=Truename column=truename /%26gt;
%26lt;result property=Enable column=enable /%26gt;
%26lt;result property=Regdate column=regdate /%26gt;
%26lt;/resultMap%26gt;
%26lt;/resultMaps%26gt;

%26lt;parameterMaps%26gt;
%26lt;parameterMap id=swapParas class=PlatAdmin.Model.Member%26gt;
%26lt;parameter property=querystr column= /%26gt;
%26lt;parameter property=keyfield column= /%26gt;
%26lt;parameter property=pagesize column= /%26gt;
%26lt;parameter property=pagenumber column= /%26gt;
%26lt;/parameterMap%26gt;
%26lt;/parameterMaps%26gt;

%26lt;statements%26gt;
%26lt;procedure id=GetMemberList parameterMap=swapParas resultMap=SelectResult%26gt;
usp_GetRecordset
%26lt;/procedure%26gt;

%26lt;/statements%26gt;
%26lt;/sqlMap%26gt;
程序代码如下:

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