最近在学Spring-boot在整合mybatis和pagehelper时,pagehelper不起做用。html
项目配置以下java
<dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>1.3.2</version> </dependency> <dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper</artifactId> <version>5.1.4</version> </dependency>
pom.xml配置mysql
@Configuration public class MyBatisConfiguration { @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"); p.setProperty("dialect","mysql"); pageHelper.setProperties(p); return pageHelper; } }
配置pageHelpergit
@RestController public class DemoController { @Autowired private DemoService demoService; @RequestMapping("/getName") public String GetName(){ return demoService.getName(104L); } @RequestMapping("/getNameList") public List<String> GetNameList(){ PageHelper.startPage(1,5); return demoService.getNameList(); } }
controller层调用github
发现找出来的数据都是所有,并无分页。spring
后来修改了pom.xml配置就能够了。以下:sql
<dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>1.1.1</version> </dependency> <dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper</artifactId> <version>4.1.0</version> </dependency>一开始我用的最新的mybatis包和最新的pagehelper包,发现并不能分页。就返回了比较先前的版本试一下。结果还真是包的缘由。具体缘由我也不懂。
但愿能帮到你们。你们若是有兴趣能够来个人网站看看:http://www.jiegelo.commybatis