log4j.xml实现打印sql

1. log4j配置

<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">
 
<!--控制台输出sql执行过程-->
    <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>
 
    <logger name="com.xuanwu.web" additivity="true">
        <level value="DEBUG" />
    </logger>
 
    <root>
        <level value="INFO"></level>
    <appender-ref ref="CONSOLE"/>
    </root>
</log4j:configuration>

注意:

1. log4j.xml标签的顺序

 1 <log4j:configuration>
 2 <renderer></renderer>
 3 ...
 4 <appender></appender>
 5 ...
 6 <plugin></plugin>
 7 ...
 8 <logger></logger>
 9 ...
10 <category></category>
11 ...
12 <root></root>
13 ...
14 <loggerfactory></loggerfactory>
15 ...
16 <categoryfactory></categoryfactory>
17 ...
18 </log4j:configuration>

2. com.xuanwu.web为spring-mybatis.xml文件里自动扫描的base-package的路径

<context:component-scan base-package="com.xuanwu.web"/>