java分页查询代码

‘贰’ java分页查询

intPageCount = (intRowCount+intPageSize-1) / intPageSize;等价于
intPageCount=(intRowCount-1/intPageSiez)+1;
如果introwCount(总记录)=8,intPageSize(每页记录)=8则共为1页,如果rowCount=14,inPageSize=8则为2页,就是说总页数至少是要比8的倍数多1才会多翻一页.你想想如果一页显示八个记录,而总数刚好最后页有8个记录,你会翻页吗,不会的吧!!就这个道理
其实可以用为intPageCount=intRowCount%intPageSize==0?(intRowCount)/intPageSize:(intRowCount/intPageSize+1);
假设rowCount(总记录数)=8 intPageSize(每页记录数)=8,那么总页数就是因为8%8==0则8/8=1
就是一页
假设rowCount=14 intPageSize=8则总页数就是因为14%8!=0则14/8+1=2
就是两页这样分析楼主不知道能否明白

‘叁’ java中数据库中实现分页的sql语句要求每页十条要查询的是第二页

1、首先preparedstatement是statement的子接口，属于预处理操作，与直接使用statement不同的是，preparedstatement在操作的时候，先在数据表中准备好了一条sql语句，但是sql语句的值暂时不设置，而是之后设置。

‘肆’ 如何用java实现分页效果（eclipse工具）

package dl.wsxx.base;
public class Pager {
    private int totalRows; // 总行数
    private int pageSize; // 每页显示的行数
    private int currentPage; // 当前页号
    private int totalPages; // 总页数
    private int startRow; // 当前页在数据库中的起始行
    private int pageStartRow; // 当前页开始行
    private int pageEndRow; // 当前页结束行
    private int hasNextPage; // 下一页存在标识[0:不存在，1:存在]
    private int hasPreviousPage; // 前一页存在标识[0:不存在，1:存在]
    public Pager() {
    }
                                                                                                                
    public Pager(int _totalRows,int _pageSize) {
        pageSize = _pageSize;
        totalRows = _totalRows;
        totalPages = totalRows / pageSize;
        int mod = totalRows % pageSize;
        if (mod > 0) {
            totalPages++;
        }
        currentPage = 1;
        startRow = 0;
    }
    public int getStartRow() {
        return startRow;
    }
    public int getpageStartRow() {
        return pageStartRow;
    }
    public int getpageEndRow() {
        return pageEndRow;
    }
    public int getTotalPages() {
        return totalPages;
    }
    public int getCurrentPage() {
        return currentPage;
    }
    public int getPageSize() {
        return pageSize;
    }
    public int getHasNextPage() {
        return hasNextPage;
    }
    public int getHasPreviousPage() {
        return hasPreviousPage;
    }
    public void setTotalRows(int totalRows) {
        this.totalRows = totalRows;
    }
    public void setStartRow(int startRow) {
        this.startRow = startRow;
    }
    public void setPageStartRow(int pageStartRow) {
        this.pageStartRow = pageStartRow;
    }
    public void setPageEndRow(int pageEndRow) {
        this.pageEndRow = pageEndRow;
    }
    public void setTotalPages(int totalPages) {
        this.totalPages = totalPages;
    }
    public void setCurrentPage(int currentPage) {
        this.currentPage = currentPage;
    }
    public void setPageSize(int pageSize) {
        this.pageSize = pageSize;
    }
    public void setHasNextPage(int hasNextPage) {
        this.hasNextPage = hasNextPage;
    }
    public void setHasPreviousPage(int hasPreviousPage) {
        this.hasPreviousPage = hasPreviousPage;
    }
    public int getTotalRows() {
        return totalRows;
    }
    public void first() {
        currentPage = 1;
        startRow = 0;
        pageStartRow = startRow + 1;
        this.hasFlagSet(currentPage, totalPages);
        if (this.hasNextPage == 0) {
            pageEndRow = totalRows;
        } else {
            pageEndRow = startRow + pageSize;
        }
    }
    public void previous() {
        if (currentPage == 1) {
            return;
        }
        currentPage--;
        startRow = (currentPage - 1) * pageSize;
        pageStartRow = startRow + 1;
        this.hasFlagSet(currentPage, totalPages);
        if (this.hasNextPage == 0) {
            pageEndRow = totalRows;
        } else {
            pageEndRow = startRow + pageSize;
        }
    }
    public void next() {
        if (currentPage < totalPages) {
            currentPage++;
        }
        startRow = (currentPage - 1) * pageSize;
        pageStartRow = startRow + 1;
        this.hasFlagSet(currentPage, totalPages);
        if (this.hasNextPage == 0) {
            pageEndRow = totalRows;
        } else {
            pageEndRow = startRow + pageSize;
        }
    }
    public void last() {
        currentPage = totalPages;
        startRow = (currentPage - 1) * pageSize;
        pageStartRow = startRow + 1;
        this.hasFlagSet(currentPage, totalPages);
        if (this.hasNextPage == 0) {
            pageEndRow = totalRows;
        } else {
            pageEndRow = startRow + pageSize;
        }
    }
    public void refresh(int _currentPage) {
        currentPage = _currentPage;
        if (currentPage > totalPages) {
            last();
        }
        this.hasFlagSet(currentPage, totalPages);
    }
    private void hasFlagSet(int currentPage, int totalPages) {
        if (currentPage == totalPages) {
            if (currentPage == 1) {
                this.hasPreviousPage = 0;
                this.hasNextPage = 0;
            } else {
                this.hasPreviousPage = 1;
                this.hasNextPage = 0;
            }
        } else {
            if (currentPage == 1) {
                this.hasPreviousPage = 0;
                this.hasNextPage = 1;
            } else {
                this.hasPreviousPage = 1;
                this.hasNextPage = 1;
            }
        }
    }
}

这是我的工程里的分页核心代码，希望对你有用，还有ssh分页文档，可以参照研究一下。