/** * 是否有对话条数；1表示是，0表示否 <br> * 默认为1 */private boolean hasMessages;

/** * @author hanxu  * @mail  * @since 2024/12/4 */@Slf4j@Intercepts({    @Signature(type = StatementHandler.class, method = "prepare", args = {Connection.class, Integer.class}),})public class MyBatisSqlInterceptor implements Interceptor {
    @Override    public Object intercept(Invocation invocation) throws Throwable {        StatementHandler statementHandler = (StatementHandler) invocation.getTarget();        // 获取SQL语句        String sql = statementHandler.getBoundSql().getSql();        // 获取参数        Object parameterObject = statementHandler.getBoundSql().getParameterObject();
        log.info("Executing SQL: {}", sql);        log.info("Parameters: {}", parameterObject);
        // 执行原始方法调用        return invocation.proceed();    }
    @Override    public Object plugin(Object target) {        return Plugin.wrap(target, this);    }
    @Override    public void setProperties(Properties properties) {        // 如果需要可以读取配置    }}

<?xml version="1.0" encoding="UTF-8" ?><!-- mybatis的配置文件 --><!DOCTYPE configurationPUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-config.dtd"><configuration>  <settings>    ...  </settings>  <plugins>    ...    <plugin interceptor="com.alibaba.xxx.utils.mybatis.interceptor.MyBatisSqlInterceptor"/>  </plugins></configuration>

<?xml version="1.0" encoding="UTF-8"?><configuration>  ...
  <appender name="CONSOLE" class="ch.qos.logback.core.ConsoleAppender">    <encoder>      <pattern>${CONSOLE_LOG_PATTERN}</pattern>      <charset>utf8</charset>    </encoder>  </appender>
  <!--  控制台打印dao层日志  -->  <logger name="com.alibaba.xxx.dao" level="DEBUG" additivity="false">    <appender-ref ref="CONSOLE" />  </logger>
  ...</configuration>

c.a.i.u.m.i.MyBatisSqlInterceptor - Parameters: xxxDO(empId=xxx, stageName=xxx, realName=xxx, summary=利物浦的首都是？, status=NORMAL, feature={"talkType":"MODEL"}, sessionId=f703babf-791b-432b-a162-7e5d4731bbca, talkEntityType=MODEL, setAsTop=false, hasMessages=true)
c.a.i.u.m.i.MyBatisSqlInterceptor - Executing SQL: INSERT INTO                 xxx_session             (         gmt_create,        gmt_modified,        emp_id,        stage_name,        real_name,        summary,        feature,        status,        session_id,        talk_entity_type,        is_set_as_up,        is_has_messages     )        VALUES        (         now(),        now(),        ?,        ?,        ?,        ?,        ?,        ?,        ?,        ?,        ?,        ?     )

...
/** * @author Clinton Begin * @author Eduardo Macarron */public class DefaultParameterHandler implements ParameterHandler {
    private final TypeHandlerRegistry typeHandlerRegistry;
    private final MappedStatement mappedStatement;    private final Object parameterObject;    private final BoundSql boundSql;    private final Configuration configuration;
    public DefaultParameterHandler(MappedStatement mappedStatement, Object parameterObject, BoundSql boundSql) {        this.mappedStatement = mappedStatement;        this.configuration = mappedStatement.getConfiguration();        this.typeHandlerRegistry = mappedStatement.getConfiguration().getTypeHandlerRegistry();        this.parameterObject = parameterObject;        this.boundSql = boundSql;    }
    @Override    public Object getParameterObject() {        return parameterObject;    }
    @Override    public void setParameters(PreparedStatement ps) {        ErrorContext.instance().activity("setting parameters").object(mappedStatement.getParameterMap().getId());        List<ParameterMapping> parameterMappings = boundSql.getParameterMappings();        if (parameterMappings != null) {            for (int i = 0; i < parameterMappings.size(); i++) {                ParameterMapping parameterMapping = parameterMappings.get(i);                if (parameterMapping.getMode() != ParameterMode.OUT) {                    Object value;                    String propertyName = parameterMapping.getProperty();                    if (boundSql.hasAdditionalParameter(propertyName)) { // issue #448 ask first for additional params                        value = boundSql.getAdditionalParameter(propertyName);                    } else if (parameterObject == null) {                        value = null;                    } else if (typeHandlerRegistry.hasTypeHandler(parameterObject.getClass())) {                        value = parameterObject;                    } else {                        MetaObject metaObject = configuration.newMetaObject(parameterObject);                        value = metaObject.getValue(propertyName);                    }                    TypeHandler typeHandler = parameterMapping.getTypeHandler();                    JdbcType jdbcType = parameterMapping.getJdbcType();                    if (value == null && jdbcType == null) {                        jdbcType = configuration.getJdbcTypeForNull();                    }                    try {                        typeHandler.setParameter(ps, i + 1, value, jdbcType);                    } catch (TypeException | SQLException e) {                        throw new TypeException("Could not set parameters for mapping: " + parameterMapping + ". Cause: " + e, e);                    }                }            }        }    }
}

private Boolean hasMessages = Boolean.TRUE;