Spring boot 集成 PageHelper 时 page.gitTocal()一直为0的问题
ServiceImpl部分
public ResultJson selectProject(PageWeb<Project> project) {
Page<Object> page = PageHelper.startPage(project.getPageNum(), project.getPageSize());//必须紧跟查询语句
List<Project> projects = projectMapper.selectProject(project);
System.out.println(page.getTotal()); //此处一直输出0
return ResultJson.ok(projects,page.getTotal());
}
经检查发现少导了spring boot 整合pagehelper依赖
依赖
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.1.10</version>
</dependency>
<!-- spring boot 整合pagehelper依赖 版本有兼容性问题 第一种方式依赖的包-->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.3</version>
</dependency>
yml文件配置
#分页pageHelper
pagehelper:
helperDialect: mysql
reasonable: true
supportMethodsArguments: true
params: count=countSql