SpringBoot分页插件PageHelper

我会带着你远行 2022-05-25 00:46 489阅读 0赞

目的：利用PageHelper实现 springboot分页

70

1.pom文件

  1. <!--pagehelper 分页-->
  2.         <dependency>
  3.             <groupId>com.github.pagehelper</groupId>
  4.             <artifactId>pagehelper-spring-boot-starter</artifactId>
  5.             <version>1.2.3</version>
  6.         </dependency>

2.controller代码

  1. @GetMapping("getnumberlist")
  2.     public PageUtil<Map<String, String>> geNumberList(@RequestParam("pagenum") int pagenum, @RequestParam("pagesize")int pagesize){
  4.         PageUtil<Map<String, String>> pageUtil = bpCountLimitService.getCommitMentNumberList(pagenum1, pagesize);
  5.         return pageUtil;
  6.     }

3.service代码

  1. @Service
  2. public class BPCountLimitServiceImpl implements BPCountLimitService{
  4.     @Autowired
  5.     private BPCountLimitMapper bpCountLimitMapper;
  7.     @Override
  8.     public PageUtil<Map<String,String>> getCommitMentNumberList(int pagenum, int pagesize) {
  9.         List<Map<String,String>> list = null ;
  10.         Page<Map<String,String>> page = null;
  11.         PageUtil<Map<String,String>> pageUtil=null;
  12.             page = PageHelper.startPage(pagenum, pagesize);
  13.             list = bpCountLimitMapper.getCommitMentNumberList();
  14.             pageUtil = new PageUtil<>(page,list);
  15.         System.out.println(".....");
  16.         return pageUtil;
  17.     }

4.PageUtil

  1. @Data
  2. public class PageUtil<T> implements Serializable {
  5.     private static final long serialVersionUID = 1049685030686235447L;
  6.     /**
  7.      * number 每页显示数量
  8.      * size 每页显示数量
  9.      * numberOfElements 当前页记录数
  10.      * totalElements 总记录数
  11.      * totalPages 总页数
  12.      * content 返回结果集
  13.      */
  15.     private int number=1;
  17.     private int size = 5;
  18.     private int numberOfElements;
  19.     private long totalElements;
  20.     private int totalPages;
  21.     private List<T> content;
  23.     public PageUtil(){
  25.     }
  27.     public PageUtil(List<T> list){
  28.         setNumber(0);
  29.         int count=list.size();
  30.         setSize(count);
  31.         setNumberOfElements(count);
  32.         setTotalElements(count);
  33.         setContent(list);
  34.         setTotalPages(1);
  35.     }
  36.     public PageUtil(Page<T> page, List<T> list){
  37.         setNumber(page.getPageNum());
  38.         int count=list.size();
  39.         setSize(page.getPageSize());
  40.         setNumberOfElements(count);
  41.         setTotalElements(page.getTotal());
  42.         setContent(list);
  43.         setTotalPages(page.getPages());
  44.     }
  45. }

5.application.yml 

  1. # 分页配置
  2. pagehelper:
  3.   helper-dialect: mysql
  4.   reasonable: true
  5.   support-methods-arguments: true
  6.   params: count=countSql

注意：要是页数小于1显示第一页，大于最后一页显示最后一页。

发表评论

表情：
评论列表 （有 0 条评论，489人围观）

还没有评论，来说两句吧...

相关阅读