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

描述

项目中用到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”);
       }
       }

2. 自定义的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();
   }
   }

3. 执行分页查询

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

4. 查看数据