惠州市惠城区规划建设局网站/全国病毒感染最新消息

判断表是否需要添加租户id > 再判断语句是否需要租户id

屏蔽租户id   @SqlParser(filter = true)

一、基础配置，可以看原来写的这篇

二、配置mybatis-plus（复制一下配置文件到你的配置类中即可）

import com.baomidou.mybatisplus.core.handlers.MetaObjectHandler;
import com.baomidou.mybatisplus.core.parser.ISqlParser;
import com.baomidou.mybatisplus.extension.plugins.OptimisticLockerInterceptor;
import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import com.baomidou.mybatisplus.extension.plugins.PerformanceInterceptor;
import com.baomidou.mybatisplus.extension.plugins.tenant.TenantHandler;
import com.baomidou.mybatisplus.extension.plugins.tenant.TenantSqlParser;
import net.sf.jsqlparser.expression.Expression;
import net.sf.jsqlparser.expression.StringValue;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.transaction.annotation.EnableTransactionManagement;import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;@EnableTransactionManagement(proxyTargetClass = true)
@Configuration
public class MybatisPlusConfig {/** 分页插件，自动识别数据库类型*/@Beanpublic PaginationInterceptor paginationInterceptor() {// 初始化PaginationInterceptor paginationInterceptor = new PaginationInterceptor();// 创建SQL解析器集合List<ISqlParser> sqlParserList = new ArrayList<>();// 创建租户SQL解析器TenantSqlParser tenantSqlParser = new TenantSqlParser();// 设置租户处理器tenantSqlParser.setTenantHandler(new TenantHandler() {@Overridepublic Expression getTenantId() {// 设置当前租户ID，实际情况你可以从cookie、或者缓存中拿都行return new StringValue("1"); //5555}@Overridepublic String getTenantIdColumn() {// 对应数据库租户ID的列名return "dept_id";}@Overridepublic boolean doTableFilter(String tableName) {// 过滤表：配置需要过滤的表System.out.println("验证需要过滤的表名==========： "+tableName);List<String> tableNameList = Arrays.asList("wx_user_tag", "b");if (!tableNameList.contains(tableName)){return true;}else {return false;}}});sqlParserList.add(tenantSqlParser);paginationInterceptor.setSqlParserList(sqlParserList);return paginationInterceptor;}/*** mybatis-plus SQL执行效率插件【生产环境可以关闭】*/@Beanpublic PerformanceInterceptor performanceInterceptor() {return new PerformanceInterceptor();}@Beanpublic OptimisticLockerInterceptor optimisticLockerInterceptor() {return new OptimisticLockerInterceptor();}@Beanpublic MetaObjectHandler metaObjectHandler() { return new CustomMetaObjectHandler(); }