Java实现MySql分页查询

service层：

//总记录数
int total = this.queryCount();
//每页条数
int pageSize = 100;
//总页数
int totalPage = (int) Math.ceil((double) total / pageSize);
for (int intPage = 1; intPage < totalPage+1; intPage++) {
     //当前页行
    int curPage = (intPage - 1) * pageSize;
    List users = this.queryUsers(curPage, pageSize);
}

Mybaties：

      select 
      from t_user t
      
      limit #{curPage}, #{pageSize}