需要关闭 MyBatis Plus的分页合理化
RuoYi-Vue-Plus
框架默认的Mybatis Plus
分页拦截器配置是打开了分页合理化,这样会导致溢出的分页数据本来应该返回空数据,打开之后而会永远返回默认的前10条数据。
/*** mybatis-plus配置类(下方注释有插件介绍)** @author Lion Li*/
@EnableTransactionManagement(proxyTargetClass = true)
@Configuration
@MapperScan("${mybatis-plus.mapperPackage}")
public class MybatisPlusConfig {/*** PageHelper的分页插件*/@Beanpublic PageInterceptor pageInterceptor() {return new PageInterceptor();}@Beanpublic MybatisPlusInterceptor mybatisPlusInterceptor() {MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();// 数据权限处理interceptor.addInnerInterceptor(dataPermissionInterceptor());// 分页插件interceptor.addInnerInterceptor(paginationInnerInterceptor());// 乐观锁插件interceptor.addInnerInterceptor(optimisticLockerInnerInterceptor());return interceptor;}/*** 数据权限拦截器*/public PlusDataPermissionInterceptor dataPermissionInterceptor() {return new PlusDataPermissionInterceptor();}/*** 分页插件,自动识别数据库类型*/public PaginationInnerInterceptor paginationInnerInterceptor() {PaginationInnerInterceptor paginationInnerInterceptor = new PaginationInnerInterceptor();// 设置最大单页限制数量,默认 500 条,-1 不受限制paginationInnerInterceptor.setMaxLimit(-1L);// 分页合理化paginationInnerInterceptor.setOverflow(false);return paginationInnerInterceptor;}/*** 乐观锁插件*/public OptimisticLockerInnerInterceptor optimisticLockerInnerInterceptor() {return new OptimisticLockerInnerInterceptor();}/*** 元对象字段填充控制器*/@Beanpublic MetaObjectHandler metaObjectHandler() {return new CreateAndUpdateMetaObjectHandler();}/*** 使用网卡信息绑定雪花生成器* 防止集群雪花ID重复*/@Beanpublic IdentifierGenerator idGenerator() {return new DefaultIdentifierGenerator(NetUtil.getLocalhost());}/*** PaginationInnerInterceptor 分页插件,自动识别数据库类型* https://baomidou.com/pages/97710a/* OptimisticLockerInnerInterceptor 乐观锁插件* https://baomidou.com/pages/0d93c0/* MetaObjectHandler 元对象字段填充控制器* https://baomidou.com/pages/4c6bcf/* ISqlInjector sql注入器* https://baomidou.com/pages/42ea4a/* BlockAttackInnerInterceptor 如果是对全表的删除或更新操作,就会终止该操作* https://baomidou.com/pages/f9a237/* IllegalSQLInnerInterceptor sql性能规范插件(垃圾SQL拦截)* IdentifierGenerator 自定义主键策略* https://baomidou.com/pages/568eb2/* TenantLineInnerInterceptor 多租户插件* https://baomidou.com/pages/aef2f2/* DynamicTableNameInnerInterceptor 动态表名插件* https://baomidou.com/pages/2a45ff/*/}