@Bean public MybatisPlusInterceptor mybatisPlusInterceptor() { MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor(); //防止全表更新删除 interceptor.addInnerInterceptor(new BlockAttackInnerInterceptor()); //分页插件 interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL)); //乐观锁 interceptor.addInnerInterceptor(new OptimisticLockerInnerInterceptor()); return interceptor; }

以上是配置mysql 以下是代码部分 @SaCheckPermission(value = "sys_dict_list", orRole = "admin") @ApiOperation("分页查询所有数据") @PostMapping("/list") public Result selectAll(@RequestBody SysDict sysDict) { QueryWrapper queryWrapper = new QueryWrapper<>(); queryWrapper.orderByDesc("time"); if (StringUtils.isNotBlank(sysDict.getCode())) { queryWrapper.like("code", sysDict.getCode()); } if (StringUtils.isNotBlank(sysDict.getDescript())) { queryWrapper.like("descript", sysDict.getDescript()); } Page page = new Page<>(sysDict.getPageNo(), sysDict.getPageSize()); IPage pageList = sysDictService.page(page, queryWrapper); return Result.success("查询成功", pageList); }

以下是请求返回部分

{"code":200,"msg":"查询成功","data":{"records":[{"role":"tenant","pageNo":null,"statusText":"正常","description":"租户","pageSize":null,"id":37,"time":"2023-04-14 10:10:07","status":1},{"role":"admin","pageNo":null,"statusText":"正常","description":"管理员","pageSize":null,"id":1,"time":"2022-10-23 19:20:52","status":1}],"total":0,"size":20,"current":1,"orders":[],"optimizeCountSql":true,"searchCount":true,"maxLimit":null,"countId":null,"pages":0}}