★有ibatisnet开发经验的请进★

[hs1983]

以前开发一直用ADO.NET模型,现在有个WEB项目要使用ibatisnet开发.自己在网上找了相关的资料看了下,感觉对ibatisnet还是不太了解.ADO.NET架构中经常使用的DataSet,DataTable,DataRow在ibatisnet是如何实现的?要实现用户登录和GridView分页该如何解决???请高手谈谈!!谢谢!!

[kbryant]

友情up

[hs1983]

请教高手

[sfssmiss]

1.
/// <summary>
/// 根据条件执行数据邦定
/// </summary>
private void DataBind_PurchaseByState(int state, int recondcount)
{
if (recondcount == 0)
{
this.AspNetPager_Purchase.CurrentPageIndex = 1;
}
int count = recondcount;
int pageIndex = this.AspNetPager_Purchase.CurrentPageIndex;
int pageSize = this.AspNetPager_Purchase.PageSize;

this.GridView_Purchase.DataSource = ServiceLocator.PurchaseService.GetPurchaseCollectionByState(state, pageIndex, pageSize, ref count);
this.GridView_Purchase.DataBind();
this.AspNetPager_Purchase.RecordCount = count;

}
2.service层
IList<Purchase> GetPurchaseCollectionByState(int State,int pageIndex, int pageSize, ref int count);
3.model层
放实体
4.dataaccess
IList<Purchase> SearchPurchases(string state, string name, int pageIndex, int pageSize, ref int count);
5.common层
放数据连接的东西
6.在Maps里 放语句
<select id="SelectPurchaseByState" parameterClass="int" resultMap="PurchaseResult">
SELECT * FROM 表名
<dynamic prepend="WHERE">
<isParameterPresent>
State = #State#
</isParameterPresent>
</dynamic>
</select>

[hs1983]

还有相关介绍吗?

[chinaicm]

下面是一个实体的Mapping例子.
基本上Select返回的就是IList类型的集合,DataSet具体在Ibatis里还没用到过.

<?xml version="1.0" encoding="utf-8" ?>
<sqlMap namespace="Service.BO" xmlns="http://ibatis.apache.org/mapping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <alias>
    <typeAlias alias="CardInfo" type="Service.BO.CardInfo, Service" />//找到实体
  </alias>
  <resultMaps>
    <resultMap id="CardInfoResult" class="CardInfo"> //数据库和实体映射
      <result property="CardId" column="CardId" />
      <result property="CardPassword" column="CardPassword"/>
      <result property="CardType" column="CardType" />
      <result property="CardPrice" column="CardPrice" />
    </resultMap>
  </resultMaps>
  <statements> //SQL语句
    <select id="SelectCard" parameterClass="string" resultMap="CardInfoResult">
      select CardId, CardPassword, CardType,CardPrice
      from CardInfo
      <dynamic prepend="WHERE">
        <isParameterPresent>
          CardId = #value#
        </isParameterPresent>
      </dynamic>
    </select>
    <select id="SelectAllCard" resultMap="CardInfoResult">
      select CardId, CardPassword, CardType,CardPrice
      from CardInfo
    </select>
    <select id="SelectCardCount" parameterClass="Hashtable" resultMap="CardInfoResult">
      select CardId, CardPassword, CardType,CardPrice
      from CardInfo
      where CardId = #CardId# and CardPassword = #CardPassword#
    </select>
    <insert id="InsertCard" parameterClass="CardInfo" resultMap="CardInfoResult">
      insert into CardInfo(CardId, CardPassword, CardType,CardPrice)
      values (#CardId#, #CardPassword#, #CardType#,#CardPrice#)
    </insert>

    <update id="UpdateCard" parameterClass="CardInfo" resultMap="CardInfoResult">
      update CardInfo set
      CardType = #CardType#
      where CardId = #CardId# and CardPassword = #CardPassword#
    </update>
  </statements>
</sqlMap>

[sfssmiss]

http://www.cnblogs.com/anderslly/archive/2007/08/19/ibatisinactionch021.html


网上有的是

[mail_ricklee]

参考
http://www.cnblogs.com/mail-ricklee/archive/2008/03/06/1093260.html
里面的经过修改的IBatisNet

可以直接采用
QueryForDataSet/DataTable
QueryForOracleDataSet/DataTable

的方式,至于传入什么参数,这些都不用修改,用IBatisNet原始的就可以了.