mysql自动分页插件使用pagehelper

1、引入jar包

        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.2.10</version>
        </dependency>

2、yml配置

## mybatis 配置
mybatis:
  type-aliases-package: com.njwd.photostock
  mapper-locations: classpath:mapper/*.xml

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

3、使用方法

    @ApiOperation(value = "测试分页插件",notes = "测试分页插件")
    @GetMapping("/getStockList")
    public Object getStockList(int pageNum, int pageSize){
        //1、设置分页信息，包括当前页数和每页显示的总计数
        PageHelper.startPage(pageNum - 1, pageSize);
        List<Map<String,Object>> list = stockService.getStockList();

        //3、获取分页查询后的数据
        PageInfo<Map<String,Object>> pageInfo = new PageInfo<>(list);
        return pageInfo;
    }