dwz 分页

最新推荐文章于 2018-08-20 16:20:51 发布

ljf19890926

最新推荐文章于 2018-08-20 16:20:51 发布

阅读量164

点赞数

分类专栏： jsp 文章标签： dwz、分页、oracle分页查询

本文链接：https://blog.csdn.net/ljf19890926/article/details/84462752

版权

jsp 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

页面主要参数：

pages为action层设置的attribute。在action层面中要有与orderField、orderDirection对应的属性。作为“字段”排序、排序方式的标识。

<th width="120" orderField="userId" <c:if test="${param.orderField=='userId' }" >class="${param.orderDirection }"</c:if>>用户名</th>

orderFiel=“userId”，userId是要排序的“字段”，与数据库字段对应。

totalCount为记录总条数。numPerPage为每页显示条数，currentPage为当前页。

建立Page辅助类：

public class Page {
    //当前页
    private int pageNum = 1;
    //每页显示条数
    private int numPerPage = 20;
    //总页数
    private int totalPage;
    //总数量
    private int totalCount;
    private List<DbMap> pages;
    public List<DbMap> getPages() {
        return pages;
    }

    public void setPages(List<DbMap> pages) {
        this.pages = pages;
    }

    public Page(int pageNum,int numPerPage){
        this.pageNum = pageNum;
        this.numPerPage = numPerPage;
    }

    public int getPageNum() {
        return pageNum;
    }
    public void setPageNum(int pageNum) {
        this.pageNum = pageNum;
    }
    public int getNumPerPage() {
        return numPerPage;
    }
    public void setNumPerPage(int numPerPage) {
        this.numPerPage = numPerPage;
    }
    public int getTotalPage() {
        return totalPage;
    }
    public void setTotalPage(int totalPage) {
        this.totalPage = totalPage;
    }
    public int getTotalCount() {
        return totalCount;
    }
    //设置总数量同时，设置总页数
    public void setTotalCount(int totalCount) {
        this.totalCount = totalCount;
        int temp = 0;
        if(totalCount%this.numPerPage!=0){
            temp++;
        }
        this.totalPage = totalCount/this.numPerPage+temp;
    }
}

数据库查询语句：

sql="SELECT tttt.userid,to_char(tttt.logtime,'yyyy-mm-dd HH24:mi:ss') logtime,tttt.logip,tttt.loginfo,tttt.actioninfo,tttt.filename,tttt.shareto,tttt.terminal FROM (SELECT rid FROM (SELECT tt.rid,rownum rnum FROM (SELECT rowid rid FROM log_info t "+param+" ORDER BY "+orderField+" "+orderDirection+") tt WHERE rownum<="+(page*pagelength)+") WHERE rnum>"+((page-1)*pagelength)+")ttt,log_info tttt WHERE ttt.rid=tttt.rowid";

param为一些查询参数，orderField，orderDirection为排序字段与排序类型，page为当前页，pagelength每页显示条数