引入maven依賴
按照慣例逛裤，需要引入SpringBoot的pagehelper依賴。
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.3</version>
</dependency>
請注意版本號革为，與Mybatis不兼容的版本號可能會導致異常
配置pagehelper參數(shù)
#mybatis配置
mybatis:
mapper-locations: classpath:mapper/*.xml
type-aliases-package: online.suiyu.mybatisdemo.entity
server:
port: 8083
#配置pagehelper
pagehelper:
helper-dialect: mysql
reasonable: true
support-methods-arguments: true
params: count=countSql
詳細配置參數(shù)參考官方文檔
依次修改Controller国瓮、Service扶歪，添加分頁的參數(shù)
- Controller層
@ApiOperation(value = "getAllUser", notes = "獲取所有的內(nèi)容", tags = "user")
@RequestMapping(value = "/getalluser", method = RequestMethod.GET)
public List<User> getAllUser(@RequestParam(value = "pageNum", required = false, defaultValue = "1") int pageNum,
@RequestParam(value = "pageSize", required = false, defaultValue = "4") int pageSize) {
return userService.getAllUser(pageNum, pageSize);
}
- Service層
@Service
public class UserService {
@Autowired
private UserMapper userMapper;
public List<User> getAllUser(int pageNum, int pageSize) {
//這是整個過程中最核心的一條語句
PageHelper.startPage(pageNum, pageSize);
return userMapper.getAllUser();
}
}
到此完成，順便一提糙置，當pageNum<=0時云茸，加載第一頁，當pageNum>最后一頁則加載最后一頁谤饭。這是有配置文件中的reasonable: true決定的标捺！
到此，整合完成揉抵！
