1. 添加分页插件配置:
MapperScan 修改成对应的 mapper 包
@Configuration
@MapperScan("scan.your.mapper.package")
public class MybatisPlusConfig {
/**
* 新的分页插件,一缓和二缓遵循mybatis的规则,需要设置 MybatisConfiguration#useDeprecatedExecutor = false 避免缓存出现问题(该属性会在旧插件移除后一同移除)
*/
@Bean
public MybatisPlusInterceptor mybatisPlusInterceptor() {
MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
return interceptor;
}
}
在接口中实现分页查询:
@GetMapping("/test")
public Page<User> test(long pageSize, long pageNum) {
QueryWrapper<User> queryWrapper = new QueryWrapper<>();
return userService.page(new Page<>(pageNum, pageSize), queryWrapper);
}