使用pagehelper<>分页工具
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.12</version>
</dependency>
在yml文件中添加以下,开启分页
mybatis:
mapper-locations: classpath*:mapper/**/*.xml
config-location: classpath:mybatis-config.xml
pagehelper:
params: pageNum=pageNumKey;pageSize=pageSizeKey;count=countSql
helperDialect: mysql
reasonable: false
supportMethodsArguments: true
page-size-zero: true
例子:
//Mapper里面的
List<XXX实体类> getList(@Param("pageNumKey") Integer pageNum, @Param("pageSizeKey") Integer pageSize);
//service里面的
PageInfo<XXX实体类> getList(Integer pageNum, Integer pageSize);
//impl里面的
@Override
public PageInfo<XXX实体类> getList(Integer pageNum, Integer pageSize) {
List<XXX实体类> list = mapper.getList(pageNum,pageSize);
return new PageInfo<>(list);
}
//controller里面的
@ApiOperation("swagger页面显示")
@PostMapping("/getList")
@ApiImplicitParams({
@ApiImplicitParam(paramType = "query", name = "pageNum", value = "页数", dataType = "Integer"),
@ApiImplicitParam(paramType = "query", name = "pageSize", value = "条数", dataType = "Integer")
})
public Resp<PageInfo<XXX实体类>> selectDevice(Integer pageNum, Integer pageSize) {
PageInfo<XXX实体类> list = service.getList(pageNum, pageSize);
return Resp.success(list);
}