MyBatis在log4j的输出配置,xml方式

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/" debug="true">
<!-- 输出日志到控制台-->
<appender name="CONSOLE" class="org.apache.log4j.ConsoleAppender">
<!-- 信息输出格式 -->
<layout class="org.apache.log4j.PatternLayout">
<param name="ConversionPattern" value="[%d{dd/MM/yy hh:mm:ss:sss z}] %5p %c{2}: %m%n" />
</layout>
</appender>
<!-- 输出日志到文件-->
<appender name="FILE" class="org.apache.log4j.RollingFileAppender">
<!-- 文件路径 -->
<param name="file" value="${user.home}/yanglong-frameworkutil.log" />
<param name="append" value="true" />
<!-- 文件大小 -->
<param name="maxFileSize" value="1MB" />
<!-- 文件备份数量 -->
<param name="maxBackupIndex" value="1000" />
<!-- 信息输出格式 -->
<layout class="org.apache.log4j.PatternLayout">
<param name="ConversionPattern" value="%d [%t] %-5p %C{6} (%F:%L) - %m%n" />
</layout>
</appender>
<!-- 下面是打印mybatis语句的配置-->
<logger name="com.ibatis" additivity="true">
<level value="DEBUG" />
<appender-ref ref="CONSOLE" />
</logger>
<logger name="java.sql.Connection" additivity="true">
<level value="DEBUG" />
<appender-ref ref="CONSOLE" />
</logger>
<logger name="java.sql.Statement" additivity="true">
<level value="DEBUG" />
<appender-ref ref="CONSOLE" />
</logger>
<logger name="java.sql.PreparedStatement" additivity="true">
<level value="DEBUG" />
<appender-ref ref="CONSOLE" />
</logger>
<logger name="java.sql.ResultSet" additivity="true">
<level value="DEBUG" />
<appender-ref ref="CONSOLE" />
</logger>
<root>
<level value="DEBUG" />
<appender-ref ref="CONSOLE" />
<appender-ref ref="FILE" />
</root>
</log4j:configuration>