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
Logo

瓜分20万奖金 获得内推名额 丰厚实物奖励 易参与易上手

更多推荐