SpringBoot整合Mybatis-Plus分页失效

创业
2025-08-21 06:27:02

场景：项目整合mybatis-Plus分页失效，current一直是1，size一直是10，total属性一直是0，数据分页不准

先看官网给的示例：

解决方案是新建mybatis-Plus的配置文件：

package com.amc.config; import com.baomidou.mybatisplus.annotation.DbType; import com.baomidou.mybatisplus.autoconfigure.ConfigurationCustomizer; import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor; import com.baomidou.mybatisplus.extension.plugins.inner.OptimisticLockerInnerInterceptor; import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor; import org.mybatis.spring.annotation.MapperScan; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.Configuration; import org.springframework.transaction.annotation.EnableTransactionManagement; /** * @Author: pangyq * @CreateTime: 2022-12-11 17:36 * @Description: mybatisPlus配置 * 针对于分页查询失效问题 * @Version: 1.0 */ @EnableTransactionManagement @MapperScan("com.amc.**.mapper") @Configuration public class MyBatisPlusConfig { @Bean public MybatisPlusInterceptor mybatisPlusInterceptor() { MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor(); PaginationInnerInterceptor innerInterceptor = new PaginationInnerInterceptor(); innerInterceptor.setDbType(DbType.MYSQL); innerInterceptor.setOverflow(true); interceptor.addInnerInterceptor(new OptimisticLockerInnerInterceptor()); interceptor.addInnerInterceptor(innerInterceptor); return interceptor; } @Bean public ConfigurationCustomizer configurationCustomizer() { return mybatisConfiguration -> mybatisConfiguration.setUseGeneratedShortKey(false); } }

响应：

{

"code": "00",

"msg": "成功",

"data": {

"records": [

{

"userId": "1599928568143081472",

"userName": "admin",

"nickName": "张三",

"userType": "00",

"email": "23*****405@qq ",