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分頁文檔，可以參照研究一下。