为啥MyBatis-Plus 分页插件不生效?

超、凢脫俗 2024-04-17 05:54 51阅读 0赞

# 描述 #

项目中用到boot 整合 mybatis-plus , 个人在使用分页条件查询的时候一直查不出 total, pages, 终于找到原因了.

# 环境 #

<springboot.version>2.1.5.RELEASE</springboot.version>
    	    <mybatisplus.version>3.1.1</mybatisplus.version>

# 配置 #

1.  自定义`MybatisPlusConfig` 配置分页插件

package com.eyelake.smart.park.portal.config;
    
    import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
    import com.baomidou.mybatisplus.extension.plugins.pagination.optimize.JsqlParserCountOptimize;
    import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.Configuration;
    
    /**
     * @Author: LiangJingXing
     * @Date: 2019/8/21 19:38
     * @Decription: MybatisPlus 配置分页 性能分析
     */
    @Configuration
    @MapperScan("com.eyelake.smart.park.portal.mapper.park")
    public class MybatisPlusConfig {
    
        /**
         * 分页插件
         */
        @Bean
        public PaginationInterceptor paginationInterceptor() {
            return new PaginationInterceptor().setDialectType("mysql");
        }
    }

1.  自定义的DataSourceConfig

public class DataSourceConfig {
    	@Autowired
    	private PaginationInterceptor paginationInterceptor;
    ...
    @Primary
    	@Bean(name = "helmetSqlSessionFactory")
    	public SqlSessionFactory helmetSqlSessionFactory(@Qualifier("helmetDataSource") DataSource helmetDataSource)
    			throws Exception {
    		MybatisSqlSessionFactoryBean sqlSessionFactory = new MybatisSqlSessionFactoryBean();
    		sqlSessionFactory.setDataSource(helmetDataSource);
    		...
    //		关键代码 设置 MyBatis-Plus 分页插件
    		Interceptor[] plugins = {paginationInterceptor};
    		sqlSessionFactory.setPlugins(plugins);
    		...
    		return sqlSessionFactory.getObject();
    	}
    }

1.  执行分页查询

Page<UserInfoDto> page = new Page<>(currentPage, pageSize);
            QueryWrapper<UserInfoDto> userInfoDtoQueryWrapper = new QueryWrapper<>();
            userInfoDtoQueryWrapper.groupBy("tui.id ");
            IPage<UserInfoDto> userInfoDtoIPage = baseMapper.selectAllUserInfoDtoByPage(page, userInfoDtoQueryWrapper);

1.  查看数据  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2MjQxMDAz_size_16_color_FFFFFF_t_70]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2MjQxMDAz_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/d521ae2eebd348d8aeebdf73b35244a4.png