分页（不用插件）

• select * from userInfo limit 4; //查询前4行数据，显示1-4条数据
• select * from userInfo limit 1,4; //检索从第2行开始，累加4条id记录，共显示id为2…5
• 关于分页，使用的sql语句
• select * from s_clazz limit offset，pagesize
• select * from s_clazz limit pagesize
• offset代表从那个的下一条开始查，pagesize代表查询数目,如果只有一个代表查询数目

domain

public class PageBean<T> {
    private Integer pageno;  //第几页
    private Integer pagesize; //每页条数
    private List<T> datas; //当前页内容
    private Integer totalno; //总共几页
    private Integer totalsize; //总的条数

    public PageBean(Integer pageno, Integer pagesize) {
        if(pageno<=0){
            this.pageno = 1;
        }else{
            this.pageno = pageno;
        }
        if(pagesize<=0){
            this.pagesize = 10;
        }else{
            this.pagesize = pagesize;
        }
        this.pageno = pageno;
        this.pagesize = pagesize;
    }

    public Integer getPageno() {
        return pageno;
    }

    public void setPageno(Integer pageno) {
        this.pageno = pageno;
    }

    public Integer getPagesize() {
        return pagesize;
    }

    public void setPagesize(Integer pagesize) {
        this.pagesize = pagesize;
    }

    public List getDatas() {
        return datas;
    }

    public void setDatas(List datas) {
        this.datas = datas;
    }

    public Integer getTotalno() {
        return totalno;
    }

    public void setTotalno(Integer totalno) {
        this.totalno = totalno;
    }

    public Integer getTotalsize() {
        return totalsize;
    }

    public void setTotalsize(Integer totalsize) {
        this.totalno = (totalsize%pagesize==0)?(totalsize/pagesize):(totalsize/pagesize+1);
        this.totalsize = totalsize;
    }

    /**
     * 开始索引
     */
    public Integer getStartIndex(){
        return (this.pageno-1)*this.pagesize;
    }


    @Override
    public String toString() {...}
}

controller层

 /**
  * 异步加载班级列表
  */
 @PostMapping("/getClazzList")
 @ResponseBody
 public Object getClazzList(@RequestParam(value = "page",defaultValue = "1")Integer page,
                            @RequestParam(value = "rows",defaultValue = "100")Integer rows,
                            String clazzName){
     Map<String,Object> paramMap = new HashMap<>();
     paramMap.put("pageno",page);
     paramMap.put("pagesize",rows);
     if(!StringUtils.isEmpty(clazzName))
         paramMap.put("name",clazzName);
     //PageBean是自定义javaBean
     PageBean<Clazz> pageBean = clazzService.queryPage(paramMap);
    
     Map<String,Object> result = new HashMap();
     result.put("total",pageBean.getTotalsize());
     result.put("rows",pageBean.getDatas());
     return result;
 }

service层

public PageBean<Clazz> queryPage(Map<String, Object> paramMap) {
   PageBean<Clazz> pageBean = new PageBean<>((Integer)paramMap.get("pageno"),
           (Integer)paramMap.get("pagesize"));

   Integer startIndex = pageBean.getStartIndex();
   paramMap.put("startIndex",startIndex);
   List<Clazz> datas = clazzMapper.queryList(paramMap);
   pageBean.setDatas(datas);

   Integer totalsize = clazzMapper.queryCount(paramMap);
   pageBean.setTotalsize(totalsize);
   return pageBean;
}

dao层

public interface ClazzMapper {
    //查询当前页列表信息
    List<Clazz> queryList(Map<String,Object> paramMap);
	//查询到的数据总条数
    Integer queryCount(Map<String,Object> paramMap);
    ...
}

<select id="queryList" resultMap="ClazzInfo" >
   <!-- 根据条件查询 图书的所有信息 -->
   SELECT * from s_clazz
   <where>
       <if test="name!=null"> and name LIKE concat("%",#{name},"%") </if>
   </where>
   limit #{startIndex},#{pagesize}
</select>

<select id="queryCount" resultType="int" >
   select count(*) from s_clazz
   <where>
       <if test="name!=null"> and name LIKE concat("%",#{name},"%") </if>
   </where>
</select>