SpringBoot ——PageHelper分页插件使用

1、引入依赖

       <!-- 分页插件依赖 -->
      <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.2.13</version>
        </dependency>

2、增加配置文件

         pagehelper:
                      helperDialect: mysql
                      reasonable: false
                      params: count=countSql
                      supportMethodsArguments: true

3、使用

controller 层：

  @GetMapping("/findAllByPage")
    @ResponseBody
    public PageInfo<User> findAllByPage(@RequestParam(value = "page",defaultValue ="1") int page,
                                        @RequestParam(value = "size",defaultValue = "5") int size){
        return userServiceImpl.findAllByPage(page,size);
    }

service 层：

 public PageInfo<User> findAllByPage(int page, int size) {
        PageHelper.startPage(page,size);
        List<User> user=userMapper.selectAll();
        PageInfo<User> pageInfo = new PageInfo<>(user);
        return pageInfo;
    }

返回值：

{
  "total": 6,
  "list": [
    {
      "id": 1,
      "name": "nji",
      "age": 3,
      "email": "888@123"
    },
    {
      "id": 2,
      "name": "cc",
      "age": 8,
      "email": "123456@123"
    },
    {
      "id": 3,
      "name": "pure",
      "age": 28,
      "email": "smile3@ityouknow.com"
    }
  ],
  "pageNum": 0,
  "pageSize": 3,
  "size": 3,
  "startRow": 1,
  "endRow": 3,
  "pages": 2,
  "prePage": 0,
  "nextPage": 1,
  "isFirstPage": false,
  "isLastPage": false,
  "hasPreviousPage": false,
  "hasNextPage": true,
  "navigatePages": 8,
  "navigatepageNums": [
    1,
    2
  ],
  "navigateFirstPage": 1,
  "navigateLastPage": 2
}