Mybatis打印带参数的SQL语句

原创

已于 2024-11-22 15:27:02 修改

· 665 阅读

10 ·

版权

文章标签：

#mybatis

于 2024-11-22 15:08:02 首次发布

package com.example.interceptor;

import com.mysql.jdbc.PreparedStatement;
import org.apache.ibatis.executor.statement.StatementHandler;
import org.apache.ibatis.plugin.Interceptor;
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.ReflectorFactory;
import org.apache.ibatis.reflection.factory.DefaultObjectFactory;
import org.apache.ibatis.reflection.factory.ObjectFactory;
import org.apache.ibatis.reflection.wrapper.DefaultObjectWrapperFactory;
import org.apache.ibatis.reflection.wrapper.ObjectWrapperFactory;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.stereotype.Component;

import java.sql.Statement;

/**
 * 控制台打印包含参数的SQL日志
 * 请先关闭mybatis的控制台打印功能
 * for MYSQL5.6
 */
@Component
@Intercepts(value = {
        &