解决MybatisPlus多数据源下关键字冲突问题

鸢尾和木棉

已于 2024-11-26 17:08:06 修改

阅读量650

点赞数 3

分类专栏： mybatisplus 文章标签： mybatis springboot java oracle mysql

于 2024-11-26 17:06:41 首次发布

本文链接：https://blog.csdn.net/m0_52285196/article/details/144063354

版权

mybatisplus 专栏收录该内容

1 篇文章

订阅专栏

都知道mysql解决冲突的办法为在存在冲突的字段上加``,mybatis可以在@TableField注解上加``

但该解决方法不适用于多数据源的情况，例如达梦数据库需要加"",Oracle数据库可以加""也可以不做处理，因此需要其他的方法。

MybatisPlus的InnerInterceptor 可以解决该问题，原理就是在查询前修改SQL，代码如下


public class MybatisKeywordInterceptor implements InnerInterceptor {
    @Override
    public void beforeQuery(Executor executor, MappedStatement ms, Object parameter, RowBounds rowBounds, ResultHandler resultHandler, BoundSql boundSql) throws SQLException {
        DbType dbType = JdbcUtils.getDbType(executor);
        String buildSql = boundSql.getSql();
        String newSql="";
        if(dbType == DbType.MYSQL){
            newSql = buildSql
                .replaceAll(" range,", "`range`,")
                .replaceAll(",range,", ",`range`,")
                .replaceAll(",range ", ",`range`")
                .replaceAll(" range ", "`range`")

                .replaceAll(" RANGE,", "`RANGE`,")
                .replaceAll(",RANGE,", ",`RANGE`,")
                .replaceAll(",RANGE ", ",`RANGE`")
                .replaceAll(" RANGE ", "`RANGE`")

                .replaceAll(" language,", "`language`,")
                .replaceAll(",language,", ",`language`,")
                .replaceAll(",language ", ",`language`")
                .replaceAll(" language ", "`language`")

                .replaceAll(" LANGUAGE,", "`LANGUAGE`,")
                .replaceAll(",LANGUAGE,", ",`LANGUAGE`,")
                .replaceAll(",LANGUAGE ", ",`LANGUAGE`")
                .replaceAll(" LANGUAGE ", "`LANGUAGE`");
        }
        PluginUtils.MPBoundSql mpBoundSql = PluginUtils.mpBoundSql(boundSql);
        mpBoundSql.sql(newSql);
    }
}

@Configuration
public class MybatisPlusConfig {

    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        // 自定义查询重写
        interceptor.addInnerInterceptor(mybatisKeywordInterceptor());
        return interceptor;
    }

    /**
     * 自定义关键字查询重写插件
     */
    public MybatisKeywordInterceptor mybatisKeywordInterceptor(){
        return new MybatisKeywordInterceptor();
    }


}