MybatisPlus自定义拦截器修改sql

在MyBatis-Plus中，自定义拦截器可以用来修改SQL语句。你需要实现Interceptor接口，并注册你的拦截器。

以下是一个简单的示例，展示了如何创建一个自定义拦截器并在其中修改SQL语句：

import org.apache.ibatis.executor.statement.StatementHandler;
import org.apache.ibatis.plugin.*;
 
import java.sql.Connection;
import java.util.Properties;
 
@Intercepts({
    @Signature(
        type = StatementHandler.class,
        method = "prepare",
        args = {Connection.class, Integer.class}
    )
})
public class CustomSqlInterceptor implements Interceptor {
 
    @Override
    public Object intercept(Invocation invocation) throws Throwable {
        StatementHandler statementHandler = (StatementHandler) invocation.getTarget();
        String originalSql = statementHandler.getBoundSql().getSql();
        String modifiedSql = originalSql.replaceAll("原来的词汇", "修改后的词汇");
        
        Field sqlField = BoundSql.class.getDeclaredField("sql");
        sqlField.setAccessible(true);
        sqlField.set(statementHandler.getBoundSql(), modifiedSql);
 
        return invocation.proceed();
    }
 
    @Override
    public Object plugin(Object target) {
        return Plugin.wrap(target, this);
    }
 
    @Override
    public void setProperties(Properties properties) {}
}

然后，你需要在MyBatis-Plus的配置中注册这个拦截器：

import com.baomidou.mybatisplus.core.config.GlobalConfig;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
 
import java.util.Collections;
 
@Configuration
public class MybatisPlusConfig {
 
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        interceptor.addInnerInterceptor(new CustomSqlInterceptor());
        return interceptor;
    }
 
    @Bean
    public MybatisSqlSessionFactoryBean sqlSessionFactoryBean(MybatisPlusInterceptor mybatisPlusInterceptor) {
        MybatisSqlSessionFactoryBean sql