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;}
参照:SpringBoot使用Mybatis-PageHelper - 简书