Maven依赖
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.1.0</version>
</dependency>
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.5</version>
</dependency>
yml指定方言
pagehelper:
helperDialect: mysql
reasonable: true
supportMethodsArguments: true
pageSizeZero: true
params: count=countSql
控制层
@GetMapping("/getregister")
@ResponseBody
public ReturnMsg getList(@RequestParam Integer pn,
@RequestParam(required = false,value = "option")String option,
@RequestParam(required = false,value = "condition")String condition){
int pageNum = pn;
int pageSize = 5;
PageHelper.startPage(pageNum,pageSize);
List<RealEstate> list = null;
if(! ("").equals(condition)){
if("name".equals(option)){
list = realEstateService.selectAllByName(condition);
}else if("cardid".equals(option)) {
list = realEstateService.selectByCardid(condition);
}