java pageHelp分页使用

  <!--PageHelp分页-->
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.2.3</version>
        </dependency>

引入依赖后就可以使用了

String page = request.getParameter("page");
        String limit = request.getParameter("limit");
        PageHelper.startPage(Integer.valueOf(page), Integer.valueOf(limit));
        List<Map<String, Object>> mapList = mapper.querySQDSLXXList();
        PageInfo<Map<String, Object>> pageInfo = new PageInfo(mapList);
        JQueryPage jQueryPage = new JQueryPage(((PageInfo) pageInfo).getList(), Long.valueOf(((PageInfo) pageInfo).getTotal()));

        HashMap<Object, Object> map = new HashMap<>();

        map.put("code", 0);
        map.put("msg", "查询成功");
        map.put("count", jQueryPage.getcount());
        map.put("data", jQueryPage.getdata());
        return map;

package com.qytb.utils;


import java.io.Serializable;
import java.util.List;
import org.springframework.stereotype.Repository;

@Repository
public class JQueryPage
  implements Serializable
{
  private static final long serialVersionUID = 1L;
  private Long count;
  private List data;
  
  public JQueryPage() {}
  
  public JQueryPage(List data, Long count)
  {
    this.data = data;
    this.count = count;
  }
  
  public Long getcount()
  {
    return this.count;
  }
  
  public void setcount(Long count)
  {
    this.count = count;
  }
  
  public List getdata()
  {
    return this.data;
  }
  
  public void setdata(List data)
  {
    this.data = data;
  }
}