spring boot日志配置+mybatis输出SQL
因为项目使用的logback,这里以Logback进行说明。
其实要在日志中输出SQL,只需要加一行配置即可:
<logger name="mapper所在的包名" level="DEBUG"></logger>
将mapper所在包的日志级别设置为debug即可。
下面贴一个完整的logback的配置:
<configuration>
<!-- %m输出的信息,%p日志级别,%t线程名,%d日期,%c类的全名,,,, -->
<appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
<encoder>
<pattern>%d %p (%file:%line\)- %m%n</pattern>
<charset>GBK</charset>
</encoder>
</appender>
<appender name="baselog"
class="ch.qos.logback.core.rolling.RollingFileAppender">
<File>log/base.log</File>
<rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
<fileNamePattern>log/base.log.%d.%i</fileNamePattern>
<timeBasedFileNamingAndTriggeringPolicy class="ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP">
<!-- or whenever the file size reaches 64 MB -->
<maxFileSize>64 MB</maxFileSize>
</timeBasedFileNamingAndTriggeringPolicy>
</rollingPolicy>
<encoder>
<pattern>
%d %p (%file:%line\)- %m%n
</pattern>
<charset>UTF-8</charset>
<!-- 此处设置字符集 -->
</encoder>
</appender>
<root level="info">
<appender-ref ref="STDOUT"/>
</root>
<logger name="com.ybf" level="DEBUG">
<appender-ref ref="baselog"/>
</logger>
<logger name="com.sample.activity.web.mapper" level="DEBUG">
<appender-ref ref="STDOUT" />
</logger>
</configuration>
注:测试的spring boot版本为1.5.4.RELEASE.