Spring Boot 整合Pagehelper（为什么PageHelper分页不生效）

2024-11-08 技术教程

引入包
https://mvnrepository.com/artifact/com.github.pagehelper/pagehelper-spring-boot-starter/1.2.10

  <dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper-spring-boot-starter</artifactId> <version>1.2.10</version> </dependency>配置文件

import com.github.pagehelper.PageHelper;import org.apache.ibatis.session.Configuration;import org.mybatis.spring.boot.autoconfigure.ConfigurationCustomizer;import org.springframework.context.annotation.Bean;import java.util.Properties;/** *配置文件 * @author liwen406 * @date 2019-04-20 12:14 2019-04-20 13:20 */@org.springframework.context.annotation.Configurationpublic class MyBatisConfig { /** * 目的防止驼峰命名规则 * @return */ @Bean public ConfigurationCustomizer configurationCustomizer(){ return new ConfigurationCustomizer(){ @Override public void customize(Configuration configuration) { configuration.setMapUnderscoreToCamelCase(true); } }; } /** * 分页插件 * @return */ @Bean public PageHelper pageHelper() { System.out.println("MyBatisConfiguration.pageHelper()"); PageHelper pageHelper = new PageHelper(); Properties p = new Properties(); p.setProperty("offsetAsPageNum", "true"); p.setProperty("rowBoundsWithCount", "true"); p.setProperty("reasonable", "true"); pageHelper.setProperties(p); return pageHelper; }}dao mapper

@Select("SELECT * from tbl_emp") List<Employee> selectByExample(Employee example);Service

@Override public List<Employee> selectByExample() { return projectInfodao.selectByExample(null); }Controller

@GetMapping("/page/{start}/{end}") @ResponseBody public List<Employee> likeName(@PathVariable int start, @PathVariable int end) throws Exception { /* * 第一个参数：第几页; * 第二个参数：每页获取的条数. */ PageHelper.startPage(start, end); return projectInfService.selectByExample(); }