dwz 分页

页面主要参数：

<form id="pagerForm" method="post" action="log.do?log=userlog">
    <input type="hidden" name="pageNum" value="1" />
    <input type="hidden" name="numPerPage" value="${pages.numPerPage}" />
    <input type="hidden" name="orderField" value="${param.orderField}" />
    <input type="hidden" name="orderDirection" value="${param.orderDirection}" />
</form>

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是要排序的“字段”，与数据库字段对应。

<div class="pagination" targetType="navTab" totalCount="${pages.totalCount }" numPerPage="${pages.numPerPage }" pageNumShown="10" currentPage="${pages.pageNum }"></div>

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每页显示条数