mybatisplus 各版本动态表名

1. 版本3.3.1

使用DynamicTableNameParser 的setTableNameHandlerMap 方面

动态表名要放在分页插件里处理,无论是否使用分页都有效,

注意 put("sys_log",.. 中,key大小写要与数据库的表名大小写一致

package com.gzrd.hyfw.common.conf;

import com.baomidou.mybatisplus.extension.parsers.DynamicTableNameParser;
import com.baomidou.mybatisplus.extension.parsers.ITableNameHandler;
import com.baomidou.mybatisplus.extension.plugins.OptimisticLockerInterceptor;
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;
import org.springframework.transaction.annotation.EnableTransactionManagement;

import java.util.Collections;
import java.util.HashMap;

@EnableTransactionManagement
@Configuration
@MapperScan({"com.gzrd.hyfw.*.mapper", "com.gzrd.hyfw.*.*.mapper"})
public class MybatisPlusConfig {
    //注意要public 否则调用是设置不了thredlocal的值
    public static ThreadLocal<String> dynamicTableNameSuffix = new ThreadLocal<>();

    /**
     * 分页插件
     */
    @Bean
    public PaginationInterceptor paginationInterceptor() {
        PaginationInterceptor paginationInterceptor = new PaginationInterceptor();
        // 开启 count 的 join 优化,只针对部分 left join
        paginationInterceptor.setCountSqlParser(new JsqlParserCountOptimize(true));
        //动态表名要放在分页插件里处理,无论是否使用分页都有效
//        DynamicTableNameParser dynamicTableNameParser = new DynamicTableNameParser();
//        dynamicTableNameParser.setTableNameHandlerMap(new HashMap<String, ITableNameHandler>(2) {{
//            //表名的大小写要与数据库一致
//            put("sys_log", (metaObject, sql, tableName) -> {
                return tableName + "_2023";
//                return tableName + "_" + dynamicTableNameSuffix.get();
//            });
//        }});
//        paginationInterceptor.setSqlParserList(Collections.singletonList(dynamicTableNameParser));


        paginationInterceptor.setSqlParserList(Collections.singletonList(dynamicTableNameParser()));
        return paginationInterceptor;
    }

    /**
     * 乐观锁插件
     */
    @Bean
    public OptimisticLockerInterceptor optimisticLockerInterceptor() {
        return new OptimisticLockerInterceptor();
    }

    /**
     * 动态表名插件
     */
    @Bean
    public DynamicTableNameParser dynamicTableNameParser() {
        DynamicTableNameParser dynamicTableNameParser = new DynamicTableNameParser();
        dynamicTableNameParser.setTableNameHandlerMap(new HashMap<String, ITableNameHandler>(2) {{
            //表名的大小写要与数据库一致
            put("sys_log", (metaObject, sql, tableName) -> {
//                return tableName + "_2023";
                return tableName + "_" + dynamicTableNameSuffix.get();
            });
        }});
        return dynamicTableNameParser;
    }
}

2. 3.4.2 以下3.3.1 以上

使用DynamicTableNameInnerInterceptor的setTableNameHandlerMap方法.

package com.hxstrive.mybatis_plus;
 
import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.handler.TableNameHandler;
import com.baomidou.mybatisplus.extension.plugins.inner.*;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import java.util.HashMap;
import java.util.Map;
 
@Configuration
public class MybatisPlusConfig {
    @Bean
    public MybatisPlusInterceptor paginationInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        // 动态表名插件
        DynamicTableNameInnerInterceptor dynamicTabNameInterceptor = new DynamicTableNameInnerInterceptor();
        Map<String, TableNameHandler> tableNameHandlerMap = new HashMap<>();
        tableNameHandlerMap.put("log", new TableNameHandler() {
            @Override
            public String dynamicTableName(String sql, String tableName) {
                String[] tableSuffix = {"2018", "2019", "2020"};
                return tableName + "_" + tableSuffix[(int)(Math.random() * tableSuffix.length)];
            }
        });
        dynamicTabNameInterceptor.setTableNameHandlerMap(tableNameHandlerMap);
        interceptor.addInnerInterceptor(dynamicTabNameInterceptor);
        return interceptor;
    }
}

https://www.hxstrive.com/subject/mybatis_plus.htm?id=314

3. 3.4.3

使用DynamicTableNameInnerInterceptor,但要用setTableNameHandler方法,因为该版本setTableNameHandlerMap已经废弃了

package com.qf.czh.testsys.config;

import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.handler.TableNameHandler;
import com.baomidou.mybatisplus.extension.plugins.inner.DynamicTableNameInnerInterceptor;
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;

@Configuration
@MapperScan(basePackages = "com.qf.czh.testsys.system.mapper")
public class MybatisPlusConfig {

//    @Bean
//    public PaginationInnerInterceptor paginationInnerInterceptor(){
//        PaginationInnerInterceptor interceptor = new PaginationInnerInterceptor(DbType.MYSQL);
//        return  interceptor;
//    }

    @Bean
    public  MybatisPlusInterceptor mybatisPlusInterceptor(){
        MybatisPlusInterceptor mybatisPlusInterceptor = new MybatisPlusInterceptor();
        mybatisPlusInterceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
        mybatisPlusInterceptor.addInnerInterceptor(dynamicTableNameInnerInterceptor());
        return mybatisPlusInterceptor;
    }

    @Bean
    public DynamicTableNameInnerInterceptor dynamicTableNameInnerInterceptor(){
        DynamicTableNameInnerInterceptor dynamicTableNameInnerInterceptor = new DynamicTableNameInnerInterceptor();
        dynamicTableNameInnerInterceptor.setTableNameHandler(new TableNameHandler() {
            @Override
            public String dynamicTableName(String sql, String tableName) {
                //根据实际情况处理,也可参考3.3.1案例中使用threadlocal实现对表名的调用时控制
                return tableName;
            }
        });
        return dynamicTableNameInnerInterceptor;
    }
}

4. 使用threadlocal.实现调用时控制动态表名.

使用threadlocal的原因是该配置类是单例,调用动态表名时是多线程.每次调用都会产生一个threadlocal的副本单独给线程来设置动态表名的后缀,否则就会每次调用都会同一个后缀了.

5!! 注意!! 动态表名非空判断,有时使用手动sqlxml 没有设置动态表名,不用plus,但也会影响到.导致插入一个null.所以如果没有设置动态表名,就只返回原表名.

调用时先设置一下表名后缀.执行查询时就自动加上后缀了.

还要调用remove() ,清除设置,因为如果使用线程池线程不会消亡,就一直绑定theadlocal副本.后缀会一直不变.