激情亚洲一区国产精品,亚洲男人天堂av,精品亚洲一区二区

ibatis擴(kuò)展example類對(duì)數(shù)據(jù)庫分頁的實(shí)現(xiàn)（轉(zhuǎn)載）

文章來源：http://blog.csdn.net/lu_yongchao/article/details/6209166

mysql：

sql代碼：

select * from user where ... order by ... limit 10,25
根據(jù)以上的語句我們可以對(duì)ibator生成后的代碼進(jìn)行修改。
第一修改User_sqlMap.xml
修改前：

< select id = "ibatorgenerated_selectByExample" resultMap = "ibatorgenerated_BaseResultMap"
parameterClass = "com.demo.ibatis.beans.UserExample" >
select ID, LOGIN_NAME, PASSWORD
from user
< isParameterPresent >
< include refid = "user.ibatorgenerated_Example_Where_Clause" />
< isNotNull property = "orderByClause" >
order by $orderByClause$
</ isNotNull >
</ isParameterPresent >
</ select >

修改后：

< select id = "ibatorgenerated_selectByExample" resultMap = "ibatorgenerated_BaseResultMap"
parameterClass = "com.demo.ibatis.beans.UserExample" >
select ID, LOGIN_NAME, PASSWORD
from user
< isParameterPresent >
< include refid = "user.ibatorgenerated_Example_Where_Clause" />
< isNotNull property = "orderByClause" >
order by $orderByClause$
</ isNotNull >
[b] < isNotNull property = "limitClauseStart" >
limit
$limitClauseStart$,$limitClauseCount$
</ isNotNull > [/b]
</ isParameterPresent >
</ select >

重要的是黑色的字體是添加到原來的xml中的。接下來修改UserExample.java
在該類中添加兩個(gè)字段和相應(yīng)的getter/setter方法

Java代碼

protected String limitClauseStart; //起始參數(shù)
protected String limitClauseCount; //數(shù)量參數(shù)

接下來就可以通過Dao調(diào)用selectByExample()方法測(cè)試,好的以上就是MySql的分頁。
SqlServer:

SqlServer的分頁比較難了，因?yàn)?SqlServer中沒有l(wèi)imit的關(guān)鍵字。
看看SqlServer的分頁語句，那當(dāng)然 SqlServer人分布方法有很多種。這里我采用其中的一種。
語句如下：

SELECT TOP 頁大小 *
FROM TestTable
WHERE (ID NOT IN
( SELECT TOP 頁大小*頁數(shù) id
FROM 表
ORDER BY id))
ORDER BY ID

接下來和上面的MySql一樣也進(jìn)行修改
修改xml

< select id = "ibatorgenerated_selectByExample" resultMap = "ibatorgenerated_BaseResultMap"
parameterClass = "com.demo.ibatis.beans.UserExample" >
[b] < isNotNull property = "limitClauseStart" >
SELETE TOP $limitClauseCount$ * FROM user where (ID NOT IN
(SELECT TOP $limitClauseStart$ ID
</ isNotNull > [/b]
< isNull property = "limitClauseStart" >
SELETE *
</ isNull >
FROM user
from user
< isParameterPresent >
< include refid = "user.ibatorgenerated_Example_Where_Clause" />
< isNotNull property = "orderByClause" >
order by $orderByClause$
[b] < isNotNull property = "limitClauseStart" >
))order by $orderByClause$
</ isNotNull > [/b]
</ isNotNull >
</ isParameterPresent >
</ select >

接下來是ORacle的，和上面都是差不多的這里不多說。
語法：
select* from(select rownum tid,user.* FROM (select * from user where id>1 order by ID desc)user where where rownum<35) where tid>10;
修改Xml,

< select id = "ibatorgenerated_selectByExample" resultMap = "ibatorgenerated_BaseResultMap"
parameterClass = "com.demo.ibatis.beans.UserExample" >
[b] < isNotNull property = "limitClauseStart" >
select* from(select rownum tid,user.* FROM (
</ isNotNull > [/b]
select * from user
< isParameterPresent >
< include refid = "user.ibatorgenerated_Example_Where_Clause" />
< isNotNull property = "orderByClause" >
order by $orderByClause$
</ isNotNull >
[b] < isNotNull property = "limitClauseStart" >
<![[CDATA )user where where rownum<$limitClauseCount$+$limitClauseStart$+1) where tid>$limitClauseStart$;]]>
</ isNotNull > [/b]
</ isParameterPresent >
</ select >

Gavin

posted on 2012-02-03 10:05 GavinMiao 閱讀(3200) 評(píng)論(0) 編輯收藏所屬分類: ibatis

新用戶注冊(cè) 刷新評(píng)論列表


只有注冊(cè)用戶登錄后才能發(fā)表評(píng)論。




網(wǎng)站導(dǎo)航: 博客園 IT新聞 Chat2DB C++博客博問管理

自由飛翔

導(dǎo)航

公告

隨筆分類

隨筆檔案

文章檔案

統(tǒng)計(jì)

留言簿(2)

我關(guān)注的blog

閱讀排行榜

評(píng)論排行榜

ibatis擴(kuò)展example類對(duì)數(shù)據(jù)庫分頁的實(shí)現(xiàn)（轉(zhuǎn)載）