方法一 :基于 Spring Boot logback-spring.xml 配置
以 Spring Boot 项目为例
在 logback-spring.xml 文件中添加以下日志配置项
<property name="APP_NAME" value="demo" />
<appender name="MYBATIS" class="ch.qos.logback.core.rolling.RollingFileAppender">
<file>${user.home}/${APP_NAME}/logs/mybatis.log</file>
<encoder>
<pattern>%d{yyyy-MM-dd HH:mm:ss} %msg%n</pattern>
</encoder>
<rollingPolicy class="ch.qos.logback.core.rolling.SizeAndTimeBasedRollingPolicy">
<fileNamePattern>${user.home}/${APP_NAME}/logs/mybatis.log.%d{yyyy-MM-dd}.%i</fileNamePattern>
<maxHistory>7</maxHistory>
<maxFileSize>100MB</maxFileSize>
<totalSizeCap>1GB</totalSizeCap>
</rollingPolicy>
</appender>
<!--日志级别:ERROR, WARN, INFO, DEBUG, TRACE-->
<logger name="com.demo.dal" additivity="true">
<level value="trace" />
<appender-ref ref="MYBATIS" />
</logger>
注:logger 中 name 为对应 dal 层包名
方法二:mybatis-config.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<settings>
<setting name="logImpl" value="STDOUT_LOGGING"/> //添加改行配置即可
</settings>
<mappers>
</mappers>
</configuration>
查看SQL日志
IDEA 插件:MyBatis Log Plugin
IDEA 装上该插件后,点击 Tools>MyBatis Log Plugin 然后运行程序后,就会看到对应的SQL日志信息