com.github.pagehelper分页插件

1.pom.xml文件导com.github.pagehelper两个包

<dependency><!--分页插件1-->
  <groupId>com.github.pagehelper</groupId>
  <artifactId>pagehelper</artifactId>
  <version>5.1.4</version>
</dependency>
<dependency><!--分页插件2-->
  <groupId>com.github.pagehelper</groupId>
  <artifactId>pagehelper-spring-boot-starter</artifactId>
  <version>1.2.5</version>
</dependency>

2.controller层

3. serviceImpl层

如果查询结果将作为"下拉列表"展示数据,

一般第5行改为：

params.setPageSize(1000);   //如果不分页查,默认查1000个

 4.返回给前端json格式（这是拿的别处的分页代码的返回结果）样例

{
  "msg": "success",
  "code": 0,
  "data": {
    "total": 6,
    "list": [
      {
        "ruleTypeId": 1,
        "brandId": "KFC",
        "name": "使用次数描述错误",
        "orderIndex": 1,
        "createTime": "2021-05-19 14:59:25",
        "createUser": "admin",
        "lastUpdateTime": "2021-07-05 16:08:49",
        "lastUpdateUser": "admin",
        "isDel": 0
      },
      {
        "ruleTypeId": 2,
        "brandId": "KFC",
        "name": "互斥描述错误",
        "orderIndex": 2,
        "createTime": "2021-05-19 14:59:25",
        "createUser": "admin",
        "lastUpdateTime": "2021-07-05 16:09:19",
        "lastUpdateUser": "admin",
        "isDel": 0
      },
      {
        "ruleTypeId": 197,
        "brandId": "KFC",
        "name": "单人限领配置错误",
        "orderIndex": 3,
        "createTime": "2021-07-05 16:09:30",
        "createUser": "admin",
        "lastUpdateTime": null,
        "lastUpdateUser": null,
        "isDel": 0
      },
      {
        "ruleTypeId": 199,
        "brandId": "KFC",
        "name": "发放对应效期配置错误",
        "orderIndex": 4,
        "createTime": "2021-07-05 16:09:44",
        "createUser": "admin",
        "lastUpdateTime": null,
        "lastUpdateUser": null,
        "isDel": 0
      },
      {
        "ruleTypeId": 200,
        "brandId": "KFC",
        "name": "任消描述错误",
        "orderIndex": 6,
        "createTime": "2021-07-05 16:09:55",
        "createUser": "admin",
        "lastUpdateTime": null,
        "lastUpdateUser": null,
        "isDel": 0
      },
      {
        "ruleTypeId": 201,
        "brandId": "KFC",
        "name": "秒杀场景检查",
        "orderIndex": 7,
        "createTime": "2021-07-05 16:15:25",
        "createUser": "admin",
        "lastUpdateTime": null,
        "lastUpdateUser": null,
        "isDel": 0
      }
    ],
    "pageNum": 1,
    "pageSize": 10,
    "size": 6,
    "startRow": 1,
    "endRow": 6,
    "pages": 1,
    "prePage": 0,
    "nextPage": 0,
    "isFirstPage": true,
    "isLastPage": true,
    "hasPreviousPage": false,
    "hasNextPage": false,
    "navigatePages": 8,
    "navigatepageNums": [
      1
    ],
    "navigateFirstPage": 1,
    "navigateLastPage": 1,
    "firstPage": 1,
    "lastPage": 1
  }
}

5.注意： 使用此分页插件mybatis.xml中的sql不能多层嵌套如select * from (select * from ),否则会把外层的select *变为select count(0)。