mybatis-plus 通过自定义拦截修改sql

沐落Code

已于 2024-06-29 20:35:22 修改

阅读量742

点赞数 2

CC 4.0 BY-SA版权

分类专栏： mybatis-plus 文章标签： mybatis sql 后端程序人生

于 2024-06-29 00:02:11 首次发布

本文链接：https://blog.csdn.net/weixin_42566249/article/details/140055072

方案一：使用ibatis 拦截

package com.ml.toolkit.mybatis.plus.config;

import lombok.extern.slf4j.Slf4j;
import org.apache.ibatis.executor.statement.StatementHandler;
import org.apache.ibatis.mapping.BoundSql;
import org.apache.ibatis.mapping.MappedStatement;
import org.apache.ibatis.plugin.Intercepts;
import org.apache.ibatis.plugin.Invocation;
import org.apache.ibatis.plugin.Signature;
import org.apache.ibatis.reflection.DefaultReflectorFactory;
import org.apache.ibatis.reflection.MetaObject;
import org.apache.ibatis.reflection.SystemMetaObject;
import org.springframework.stereotype.Component;

import java.lang.reflect.Field;
import java.sql.Connection;
import java.util.Properties;

/**
 * mybatis-plus 自定义拦截器
 * @author ml
 * @date 2023-05-15
 */
@Slf4j
@Component
//拦截StatementHandler类中参数类型为Statement的prepare方法（prepare=在预编译SQL前加入修改的逻辑）
@Intercepts({
        @Signature(type = StatementHandler.class, method = "prepare", args = {
                Connection.class, Integer.class})})
public class Interceptor implements org.apache.ibatis.plugin.Interceptor {

    /**
     * 拦截sql
     *
     * @param invocation
     */
    @Override
    public Object intercept(Invocation invocation) throws Throwable {

        StatementHandler statementHandler = (StatementHandler) invocation.getTarget();

        // 通过M