基于SpringBoot的后台管理系统(9)整合MyBatis pagehelper分页插件
1 工程配置
1.1 pom.xml
<!--分页插件-->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.13</version>
</dependency>
1.2 application.yml
pagehelper:
helperDialect: mysql
reasonable: true
supportMethodsArguments: true
params: count=countSql
1.3 控制层controller
@GetMapping(value = "allUser")
public PageInfo allUser(@RequestParam("pageNum") int pageNum, @RequestParam("pageSize") int pageSize){
PageHelper.startPage(pageNum,pageSize);
List<User> userList = userServiceImp.getAllRecord();
PageInfo pageInfo = new PageInfo(userList);
return pageInfo;
}
2 测试