1:配置类。
@Configuration
public class PageConf {
@Bean
public MybatisPlusInterceptor mybatisPlusInterceptor() {
MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
return interceptor;
}
}
2:举例。
Page<User> page = new Page<>(1,5); //传入得参数是一页五条数据。
userService.page(page, new QueryWrapper<User>)将page传入,然后第二个参数指定查询条件。
/**
* 搜索
* */
@GetMapping("/search")
public Result search(Integer currentPage,String search){
if(currentPage == null || currentPage < 1) {
currentPage = 1;
}
Page<User> page = new Page<>(currentPage,5);
IPage<User> page1 = userService.page(page, new QueryWrapper<User>().like("username","%"+search+"%"));
return Result.succ(page1);
}