java oracle 分页通用_java oracle的2种分页方法

java oracle的2种分页方法

一物理分页：

SELECT * FROM(

SELECT ROWNUM WN,RN.* FROM (

SELECT

id,

title,

create_time as createTime,

musictor,

musictitle

FROM

krry_blog

ORDER BY create_time desc

)RN

)WN

WHERE WN <= #{pageSize} AND WN > #{pageNo}

二逻辑分页，利用pagehelper插件

com.github.pagehelper

pagehelper

4.0.0

https://blog.csdn.net//u013142781/article/details/50410243

三逻辑分页，利用mybatis-paginator

com.github.miemiedev

mybatis-paginator

1.2.10

xml

select

reply_id,

reply_classify,

reply_type,

reply_keyword,

reply_text,

reply_image,

is_enable,

is_delete,

match_mode,

create_time,

update_time

from ta_wx_reply_c

WHERE 1=1

AND is_enable = #{isEnable}

AND is_delete = #{isDelete}

AND reply_classify = #{replyClassify}

AND reply_type = #{replyType}

AND reply_keyword LIKE concat(#{replyKeyword},'%')

AND match_mode = #{matchMode}

order by ${sidx} ${order}

order by reply_id desc

IWxReplyService

List queryListBlur(Map map, PageBounds pageBounds);

IWxReplyServiceImpl

@Override

public List queryListBlur(Map map, PageBounds pageBounds) {

return taWxReplyCDao.queryListBlur(map, pageBounds);

}

controller

wxReplyService.queryListBlur(attentionPO,

new PageBounds(

Integer.valueOf(request.getPageNo()), //页码

Integer.valueOf(request.getPageSize()), //条数

Order.formString("attention_dept_date.desc")) //排序

);

https://blog.csdn.net/szwangdf/article/details/27859847/