JDBC分页套路总结

JDBC分页逻辑

JDBC分页实现

PageBean对象

public class PageBean<T> {
    @Override
    public String toString() {
        return "PageBean{" +
                "totalcount=" + totalcount +
                ", currentpage=" + currentpage +
                ", pagelist=" + pagelist +
                ", pagecount=" + pagecount +
                ", rows=" + rows +
                '}';
    }
    private int currentpage;
    private List<User> pagelist;
    private int pagecount;
    private int rows;
    private int totalcount;

    public int getTotalcount() {
        return totalcount;
    }

    public void setTotalcount(int totalcount) {
        this.totalcount = totalcount;
    }

    public int getCurrentpage() {
        return currentpage;
    }

    public void setCurrentpage(int currentpage) {
        this.currentpage = currentpage;
    }

    public List<User> getPagelist() {
        return pagelist;
    }

    public void setPagelist(List<User> pagelist) {
        this.pagelist = pagelist;
    }

    public int getPagecount() {
        return pagecount;
    }

    public void setPagecount(int pagecount) {
        this.pagecount = pagecount;
    }

    public int getRows() {
        return rows;
    }

    public void setRows(int rows) {
        this.rows = rows;
    }

   

}

注意mysql 和sql server 数据库分页

mysql用limit关键字

sqlserver用offset偏移量 sql server2012版新加入