MySQL分页查询（idea）

1、先写一个Pager类

public class Pager {
    private int page = 1;
    private int pageSize = 10;
    private int rows;
    private int index;
    private int pages;
    private int prev;
    private int next;
    private boolean first = false;
    private boolean last = false;
    private List<Object> data;
    }

2、由于声明的对象是私有的，所以使用方法进行调用。

 public Pager() {
    }

    public Pager(int page, int pageSize) {
        setPage(page);
        setPageSize(pageSize);
    }

    public int getPage() { return page;
    }

    public void setPage(int page) {
        if(page < 1){
            page = 1;
        }
        this.page = 1;
    }

    public int getPageSize() { return pageSize;
    }

    public void setPageSize(int pageSize) {
        if(pageSize < 1){
            pageSize = 10;
        }
        this.pageSize = pageSize;
    }

    public int getRows() { r