MyBatis-Plus分页插件不生效的解决方法

Z时代
2024-01-10
分类：综合

描述

项目中用到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.查看数据

mybatis plus分页不出来pages和total的解决记录

按着官方的分页例子写完以后，发现pages和total都为0，仔细观察了好多遍还是没解决。

最好找到一段配置添加后，正常了。


package kulink.cvscloud.core.config;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import com.baomidou.mybatisplus.plugins.PaginationInterceptor;
@Configuration
public class MybatisPlusConfig {
	 /**
   *  mybatis-plus分页插件
   */
  @Bean
  public PaginationInterceptor paginationInterceptor() {
    PaginationInterceptor page = new PaginationInterceptor();
    page.setDialectType("mysql");
    return page;
  }
}