MyBatis Plus 分页查询，total字段为0，分页未生效

深藏阁楼爱情的钟 2024-03-30 12:42 83阅读 0赞

1. 未配置 MybatisPlusInterceptor

@Bean
        public MybatisPlusInterceptor mybatisPlusInterceptor() {
            MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
            interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
            return interceptor;
        }

2. MybatisPlusInterceptor 与 MybatisSqlSessionFactoryBean 冲突

如果配置了MybatisSqlSessionFactoryBean后，再单独配置MybatisPlusInterceptor，将无效，如下：

@Bean
        public SqlSessionFactory sqlSessionFactory() throws Exception {
            MybatisSqlSessionFactoryBean factory = new MybatisSqlSessionFactoryBean();
            factory.setDataSource(mysqlDatasource());
            factory.setVfs(SpringBootVFS.class);
            return factory.getObject();
        }
    
    
        @Bean
        public MybatisPlusInterceptor mybatisPlusInterceptor() {
            MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
            interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
            return interceptor;
        }

我将手动创建MybatisSqlSessionFactoryBean的操作去除了，如果一定需要可以手动将分页插件放进去：

@Bean
        public SqlSessionFactory sqlSessionFactory() throws Exception {
            MybatisSqlSessionFactoryBean factory = new MybatisSqlSessionFactoryBean();
            factory.setDataSource(mysqlDatasource());
            factory.setPlugins(mybatisPlusInterceptor());
            factory.setVfs(SpringBootVFS.class);
            return factory.getObject();
        }

通过查看源码发现失败的原因，在spring boo starter中自动帮助我们注入定义好的plugin bean，因此如果我们自行创建SqlSessionFactory，则需要我们自己配置相应的plugin：

![bb253aa856374e97a776d36b46288ad5.png][]

![4cbe0a96eb8f4e93ad07b3e6b0b19b58.png][]

[bb253aa856374e97a776d36b46288ad5.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/30/f9bf2dc05d244d81b0805be6b9fa8c24.png
[4cbe0a96eb8f4e93ad07b3e6b0b19b58.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/30/c646cdd049f444858f17099d544545f5.png