mybatis-pageHelper
1,添加依赖:
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.2</version>
</dependency>
<!--pagehelper -->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.5</version>
</dependency>
2,分页配置 application.properties:
#pagehelper分页插件配置
pagehelper.helperDialect=mysql
3,Mapper接口添加分页查询方法:
@Select("SELECT * FROM USER")
Page<User> getUserList();
4,controller层使用:
@RequestMapping("/getUserList")
public Page<User> getUserList(Integer pageNum, Integer pageSize){
PageHelper.startPage(pageNum, pageSize);
Page<User> userList= userMapper.getUserList();
return userList;
}