解决Mybatis-plus高版本不向后兼容的问题

mybatis-plus插件后面的版本没有兼容低版本。即：不存在低版本中EntityWrapper这个类了。而该类采用数据库表真实字段名作查询条件，这样硬编码形式确实不友好，比如如果后面数据库表中字段更名那么所有涉及到的业务都需要去修改，且硬编码形式没有遵循orm映射框架的设计理念。所以mybatis-plus后面的版本已经不支持该类操作了。

但是这样造成一个问题。我们的一个项目开发设计时架构设计者采用了低版本的插件，但是项目进行一半时想要引入新版插件不兼容。要去一个个修改实在太麻烦，网上又没有这方面的文章。所以只能自己摸索出一个解决方案。

解决的第一步大家可以参考这篇文章：https://www.cnblogs.com/java-jun-world2099/articles/11114501.html

本以为就可以大功告成了，但是低高版本的插件内部设计重合度比较高（我并么有一步步去看原理），新的问题一个接一个。最后只能自己重写了BaseMapper和EntityWrapper这两个类。直接看代码好了：

application.yml

server:
  port: 8088

spring:
  datasource:
    url: jdbc:mysql://xx.xx.xx.xxx:3306/ces?useUnicode=true&characterEncoding=utf-8
    username: root
    password: root
    driver-class-name: com.mysql.cj.jdbc.Driver
    type: com.alibaba.druid.pool.DruidDataSource

mybatis-plus:
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
  mapper-locations: classpath*:/mapper/*.xml

pom文件

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0modelVersion>
    <parent>
        <groupId>org.springframework.bootgroupId>
        <artifactId>spring-boot-starter-parentartifactId>
        <version>2.1.6.RELEASEversion>
        <relativePath/>
    parent>
    <groupId>com.bootjargroupId>
    <artifactId>shadebootartifactId>
    <version>0.0.1-SNAPSHOTversion>
    <name>shadebootname>
    <description>Demo project for Spring Bootdescription>
<span>&lt;</span><span>properties</span><span>&gt;</span>
    <span>&lt;</span><span>java.version</span><span>&gt;</span>1.8<span><span>java.version</span><span>&gt;</span>
<span><span>properties</span><span>&gt;</span>

<span>&lt;</span><span>dependencies</span><span>&gt;</span>

    <span>&lt;</span><span>dependency</span><span>&gt;</span>
        <span>&lt;</span><span>groupId</span><span>&gt;</span>shadejar<span><span>groupId</span><span>&gt;</span>
        <span>&lt;</span><span>artifactId</span><span>&gt;</span>plusjar<span><span>artifactId</span><span>&gt;</span>
        <span>&lt;</span><span>version</span><span>&gt;</span>1.0<span><span>version</span><span>&gt;</span>
    <span><span>dependency</span><span>&gt;</span>
    <span>&lt;</span><span>dependency</span><span>&gt;</span>
        <span>&lt;</span><span>groupId</span><span>&gt;</span>com.baomidou<span><span>groupId</span><span>&gt;</span>
        <span>&lt;</span><span>artifactId</span><span>&gt;</span>mybatis-plus-core<span><span>artifactId</span><span>&gt;</span>
        <span>&lt;</span><span>version</span><span>&gt;</span>3.1.1<span><span>version</span><span>&gt;</span>
    <span><span>dependency</span><span>&gt;</span>

    <span>&lt;</span><span>dependency</span><span>&gt;</span>
        <span>&lt;</span><span>groupId</span><span>&gt;</span>com.baomidou<span><span>groupId</span><span>&gt;</span>
        <span>&lt;</span><span>artifactId</span><span>&gt;</span>mybatisplus-spring-boot-starter<span><span>artifactId</span><span>&gt;</span>
        <span>&lt;</span><span>version</span><span>&gt;</span>1.0.5<span><span>version</span><span>&gt;</span>
    <span><span>dependency</span><span>&gt;</span>
    <span>&lt;</span><span>dependency</span><span>&gt;</span>
        <span>&lt;</span><span>groupId</span><span>&gt;</span>com.baomidou<span><span>groupId</span><span>&gt;</span>
        <span>&lt;</span><span>artifactId</span><span>&gt;</span>mybatis-plus<span><span>artifactId</span><span>&gt;</span>
        <span>&lt;</span><span>version</span><span>&gt;</span>2.2.0<span><span>version</span><span>&gt;</span>
    <span><span>dependency</span><span>&gt;</span>

    <span>&lt;</span><span>dependency</span><span>&gt;</span>
        <span>&lt;</span><span>groupId</span><span>&gt;</span>org.springframework.boot<span><span>groupId</span><span>&gt;</span>
        <span>&lt;</span><span>artifactId</span><span>&gt;</span>spring-boot-starter<span><span>artifactId</span><span>&gt;</span>
    <span><span>dependency</span><span>&gt;</span>

    <span>&lt;</span><span>dependency</span><span>&gt;</span>
        <span>&lt;</span><span>groupId</span><span>&gt;</span>org.springframework.boot<span><span>groupId</span><span>&gt;</span>
        <span>&lt;</span><span>artifactId</span><span>&gt;</span>spring-boot-starter-test<span><span>artifactId</span><span>&gt;</span>
        <span>&lt;</span><span>scope</span><span>&gt;</span>test<span><span>scope</span><span>&gt;</span>
    <span><span>dependency</span><span>&gt;</span>
    <span>&lt;</span><span>dependency</span><span>&gt;</span>
        <span>&lt;</span><span>groupId</span><span>&gt;</span>org.springframework.boot<span><span>groupId</span><span>&gt;</span>
        <span>&lt;</span><span>artifactId</span><span>&gt;</span>spring-boot-starter-web<span><span>artifactId</span><span>&gt;</span>
    <span><span>dependency</span><span>&gt;</span>
    <span>&lt;</span><span>dependency</span><span>&gt;</span>
        <span>&lt;</span><span>groupId</span><span>&gt;</span>org.mybatis.spring.boot<span><span>groupId</span><span>&gt;</span>
        <span>&lt;</span><span>artifactId</span><span>&gt;</span>mybatis-spring-boot-starter<span><span>artifactId</span><span>&gt;</span>
        <span>&lt;</span><span>version</span><span>&gt;</span>2.0.1<span><span>version</span><span>&gt;</span>
    <span><span>dependency</span><span>&gt;</span>
    <span>&lt;</span><span>dependency</span><span>&gt;</span>
        <span>&lt;</span><span>groupId</span><span>&gt;</span>com.alibaba<span><span>groupId</span><span>&gt;</span>
        <span>&lt;</span><span>artifactId</span><span>&gt;</span>druid<span><span>artifactId</span><span>&gt;</span>
        <span>&lt;</span><span>version</span><span>&gt;</span>1.1.6<span><span>version</span><span>&gt;</span>
    <span><span>dependency</span><span>&gt;</span>

    <span>&lt;</span><span>dependency</span><span>&gt;</span>
        <span>&lt;</span><span>groupId</span><span>&gt;</span>org.projectlombok<span><span>groupId</span><span>&gt;</span>
        <span>&lt;</span><span>artifactId</span><span>&gt;</span>lombok<span><span>artifactId</span><span>&gt;</span>
        <span>&lt;</span><span>optional</span><span>&gt;</span>true<span><span>optional</span><span>&gt;</span>
    <span><span>dependency</span><span>&gt;</span>
    <span>&lt;</span><span>dependency</span><span>&gt;</span>
        <span>&lt;</span><span>groupId</span><span>&gt;</span>mysql<span><span>groupId</span><span>&gt;</span>
        <span>&lt;</span><span>artifactId</span><span>&gt;</span>mysql-connector-java<span><span>artifactId</span><span>&gt;</span>
        <span>&lt;</span><span>scope</span><span>&gt;</span>runtime<span><span>scope</span><span>&gt;</span>
    <span><span>dependency</span><span>&gt;</span>
    <span>&lt;</span><span>dependency</span><span>&gt;</span>
        <span>&lt;</span><span>groupId</span><span>&gt;</span>com.fasterxml.jackson.core<span><span>groupId</span><span>&gt;</span>
        <span>&lt;</span><span>artifactId</span><span>&gt;</span>jackson-annotations<span><span>artifactId</span><span>&gt;</span>
        <span>&lt;</span><span>version</span><span>&gt;</span>2.9.7<span><span>version</span><span>&gt;</span>
    <span><span>dependency</span><span>&gt;</span>

<span><span>dependencies</span><span>&gt;</span>

<span>&lt;</span><span>build</span><span>&gt;</span>
    <span>&lt;</span><span>plugins</span><span>&gt;</span>
        <span>&lt;</span><span>plugin</span><span>&gt;</span>
            <span>&lt;</span><span>groupId</span><span>&gt;</span>org.springframework.boot<span><span>groupId</span><span>&gt;</span>
            <span>&lt;</span><span>artifactId</span><span>&gt;</span>spring-boot-maven-plugin<span><span>artifactId</span><span>&gt;</span>
        <span><span>plugin</span><span>&gt;</span>
    <span><span>plugins</span><span>&gt;</span>
<span><span>build</span><span>&gt;</span>

project>View Code
实体类User
@TableName("user")
@Data
public class User {
    @TableId
    private Long id;
    private String userName;
    private Integer age;
    private String email;
    private Date birth;

}

UserMapper接口
package com.bootjar.shadeboot.mapper;

import com.bootjar.shadeboot.entity.BaseMapper;
import com.bootjar.shadeboot.entity.User;
import org.apache.ibatis.annotations.Mapper;

/**
 * @author:shf date:2019/7/1 10:40
 */
@Mapper
public interface UserMapper extends BaseMapper {
}

EntityWrapper

package com.bootjar.shadeboot.entity;

import com.baomidou.mybatisplus.core.conditions.segments.MergeSegments;
import com.baomidou.mybatisplus.core.conditions.segments.NormalSegmentList;
import com.baomidou.mybatisplus.core.metadata.TableFieldInfo;
import com.baomidou.mybatisplus.core.metadata.TableInfo;
import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;
import com.baomidou.mybatisplus.core.toolkit.ReflectionKit;
import com.baomidou.mybatisplus.core.toolkit.StringUtils;
import com.baomidou.mybatisplus.core.toolkit.TableInfoHelper;

import java.util.Objects;

/**
 * @author:shf date:2019/7/1 14:13
 */
public class EntityWrapper extends com.baomidou.mybatisplus.mapper.EntityWrapper {
    public T entity;

    public MergeSegments expression;

    public String lastSql = "";

    @Override
    public T getEntity() {
        return this.entity;
    }

    @Override
    public String getSqlSelect() {
        return null;
    }

    public String getSqlSet() {
        return null;
    }

    public MergeSegments getExpression() {
        return this.expression;
    }

    public String getCustomSqlSegment() {
        MergeSegments expression = this.getExpression();
        if (Objects.nonNull(expression)) {
            NormalSegmentList normal = expression.getNormal();
            String sqlSegment = this.getSqlSegment();
            if (StringUtils.isNotEmpty(sqlSegment)) {
                if (normal.isEmpty()) {
                    return sqlSegment;
                }

                return this.concatWhere(sqlSegment);
            }
        }

        return "";
    }

    @Override
    public String getSqlSegment() {
        String sqlSegment = "";
        String sqlWhere = "";
        if (this.expression != null) {
            sqlSegment = this.expression.getSqlSegment();
        } else if (this.sql != null) {
            sqlWhere = this.sql.toString();
        }

        if (StringUtils.isNotEmpty(sqlSegment)) {
            return sqlSegment + this.lastSql;
        } else if (com.baomidou.mybatisplus.toolkit.StringUtils.isNotEmpty(sqlWhere)) {
           // return this.isWhere != null ? (this.isWhere ? sqlWhere : sqlWhere.replaceFirst("WHERE", this.AND_OR)) : sqlWhere.replaceFirst("WHERE", this.AND_OR);
            return sqlWhere;
        } else {
            return StringUtils.isNotEmpty(this.lastSql) ? this.lastSql : null;
        }
    }

    private String concatWhere(String sql) {
        return "WHERE " + sql;
    }

    @Override
    public boolean isEmptyOfWhere() {
        return this.isEmptyOfNormal() && this.isEmptyOfEntity();
    }

    public boolean nonEmptyOfWhere() {
        return !this.isEmptyOfWhere();
    }

    public boolean isEmptyOfNormal() {
        if(this.getExpression() != null){
            return CollectionUtils.isEmpty(this.getExpression().getNormal());
        }
       return true;
    }

    public boolean nonEmptyOfNormal() {
        return !this.isEmptyOfNormal();
    }

    public boolean nonEmptyOfEntity() {
        T entity = this.getEntity();
        if (entity == null) {
            return false;
        } else {
            TableInfo tableInfo = TableInfoHelper.getTableInfo(entity.getClass());
            if (tableInfo == null) {
                return false;
            } else if (tableInfo.getFieldList().stream().anyMatch((e) -> {
                return this.fieldStrategyMatch(entity, e);
            })) {
                return true;
            } else {
                return StringUtils.isNotEmpty(tableInfo.getKeyProperty()) ? Objects.nonNull(ReflectionKit.getMethodValue(entity, tableInfo.getKeyProperty())) : false;
            }
        }
    }

    private boolean fieldStrategyMatch(T entity, TableFieldInfo e) {
        switch (e.getFieldStrategy()) {
            case NOT_NULL:
                return Objects.nonNull(ReflectionKit.getMethodValue(entity, e.getProperty()));
            case IGNORED:
                return true;
            case NOT_EMPTY:
                return StringUtils.checkValNotNull(ReflectionKit.getMethodValue(entity, e.getProperty()));
            default:
                return Objects.nonNull(ReflectionKit.getMethodValue(entity, e.getProperty()));
        }
    }

    public boolean isEmptyOfEntity() {
        return !this.nonEmptyOfEntity();
    }

}

View Code
BaseMapper

package com.bootjar.shadeboot.entity;

import com.baomidou.mybatisplus.mapper.Wrapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.session.RowBounds;

import java.io.Serializable;
import java.util.Collection;
import java.util.List;
import java.util.Map;

/**
 * @author:shf date:2019/7/1 13:17
 */
public interface BaseMapper extends com.baomidou.mybatisplus.core.mapper.BaseMapper {
    int insert(T var1);

    Integer insertAllColumn(T var1);

    int deleteById(Serializable var1);

    int deleteByMap(@Param("cm") Map var1);

    Integer delete(@Param("ew") Wrapper var1);

    int deleteBatchIds(@Param("coll") Collectionextends Serializable> var1);

    int updateById(@Param("et") T var1);

    Integer updateAllColumnById(@Param("et") T var1);

    Integer update(@Param("et") T var1, @Param("ew") Wrapper var2);

    T selectById(Serializable var1);

    List selectBatchIds(@Param("coll") Collectionextends Serializable> var1);

    List selectByMap(@Param("cm") Map var1);

    T selectOne(@Param("ew") T var1);

    Integer selectCount(@Param("ew") Wrapper var1);

    List selectList(@Param("ew") Wrapper var1);

    List> selectMaps(@Param("ew") Wrapper var1);

    List selectObjs(@Param("ew") Wrapper var1);

    List selectPage(RowBounds var1, @Param("ew") Wrapper var2);

    List> selectMapsPage(RowBounds var1, @Param("ew") Wrapper var2);

}

View Code
测试类ShadebootApplicationTests

package com.bootjar.shadeboot;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.bootjar.shadeboot.entity.EntityWrapper;
import com.bootjar.shadeboot.entity.User;
import com.bootjar.shadeboot.mapper.UserMapper;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

@RunWith(SpringRunner.class)
@SpringBootTest
public class ShadebootApplicationTests {

    @Autowired
    private UserMapper userMapper;

    //@Autowired
    //private UserCopyMapper userCopyMapper;

    @Test
    public void contextLoads() {
        User user = userMapper.selectById("1");
        System.out.println("--------------------user:" + user);
        EntityWrapper itemWrapper = new EntityWrapper<>();

        itemWrapper.where("user_name = {0}", "Jack").eq("age", "20");
        List itemsEntities = userMapper.selectList(itemWrapper);
        System.out.println("----------------itemsEntities :" + itemsEntities);

        LambdaQueryWrapper queryWrapper = new LambdaQueryWrapper()
                .eq(User::getUserName, "Jack").last("ORDER BY id DESC");
        List userList = userMapper.selectList(queryWrapper);
        System.out.println("----------------userList:" + userList);
    }

    @Test
    public void insertTest() {
        User user = new User();
        user.setUserName("dada");
        userMapper.insert(user);
    }

    @Test
    public void MapTest() {
        Map map = new HashMap();
        map.put("user_name", "1q");
        map.put("age", 18);
        List MapList = userMapper.selectByMap(map);
        System.out.println("--------------------------MapList：" + MapList);
    }

}

View Code
以上测试方法均通过，这是contextLoads方法的测试结果：

`
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@7718a40f] will not be managed by Spring
==>  Preparing: SELECT id,user_name,age,email,birth FROM user WHERE id=?
==> Parameters: 1(String)
    Columns: id, user_name, age, email, birth
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@397ef2]
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4d95a72e] was not registered for synchronization because synchronization is not active
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@7718a40f] will not be managed by Spring
==>  Preparing: SELECT id,user_name,age,email,birth FROM user WHERE user_name = ? AND ( age LIKE ? ) ORDER BY id DESC
==> Parameters: Jack(String), %24%(String)
    Columns: id, user_name, age, email, birth
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4d95a72e]

Original: https://www.cnblogs.com/better-farther-world2099/p/11114729.html
Author: 奕锋博客
Title: 解决Mybatis-plus高版本不向后兼容的问题