为啥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");
    }
}

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. 查看数据