mybatis 日志打印出sql
<?xml version='1.0' encoding='UTF-8' ?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">
???
??? <appender name="CONSOLE" value="[%7r] %6p - %30.30c - %m \n"/>
??????? </layout>
??? </appender>
??? <appender name="FILE-DEBUG" value="false"/>
??????? <param name="file" value="${wms-example.log.path}/wms-example-debug.log"/>
??????? <layout value="%d [%7r] %6p - %30.30c - %m \n"/>
??????? </layout>
??? </appender>
???
??? <appender name="FILE" value="'.'yyyy-ww"/>
??????? <param name="Append" value="true"/>
??????? <param name="file" value="${wms-example.log.path}/wms-example.log"/>
??????? <layout value="%d [%7r] %6p - %30.30c - %m \n"/>
??????? </layout>
??????? <filter value="INFO"/>
??????????? <!--<param name="LevelMax" value="FATAL "/>-->
??????? </filter>
??? </appender>
??? <appender name="FILE-AOP" value="'.'yyyy-ww"/>
??????? <param name="file" value="${wms-example.log.path}/wms-example-aop.log"/>
??????? <layout value="%d [%7r] %6p - %30.30c - %m \n"/>
??????? </layout>
??????? <filter value="INFO"/>
??????????? <!--<param name="LevelMax" value="FATAL "/>-->
??????? </filter>
??? </appender>
??? <appender name="FILE-SQL" value="'.'yyyy-ww"/>
??????? <param name="file" value="${wms-example.log.path}/wms-example-sql.log"/>
??????? <layout value="%d [%7r] %6p - %30.30c - %m \n"/>
??????? </layout>
??? </appender>
??? <appender name="FILE-VELOCITY" value="'.'yyyy-ww"/>
??????? <param name="file" value="${wms-example.log.path}/wms-example-velocity.log"/>
??????? <layout value="%d [%7r] %6p - %30.30c - %m \n"/>
??????? </layout>
??? </appender>
??? <category name="java.sql" additivity="true">???该句设为true就可以打印sql了
??????? <priority value="${wms-example.log.level}"/>
??????? <appender-ref ref="FILE-SQL"/>
??????? <appender-ref ref="FILE-DEBUG"/>
??????? <appender-ref ref="FILE"/>
??? </category>
??? <category name="org.apache.velocity" additivity="false">
??????? <priority value="${wms-example.log.level}"/>
??????? <appender-ref ref="FILE-VELOCITY"/>
??????? <appender-ref ref="FILE-DEBUG"/>
??????? <appender-ref ref="FILE"/>
??? </category>
??? <category name="com.jd.aop" additivity="false">
??????? <priority value="${wms-example.log.level}"/>
??????? <appender-ref ref="FILE-AOP"/>
??????? <appender-ref ref="FILE"/>
??? </category>
??? <category name="com.jd" additivity="true">
??????? <priority value="${wms-example.log.level}"/>
??????? <appender-ref ref="FILE"/>
??? </category>
??? <root>
??????? <priority value="${wms-example.log.level}"/>
??????? <appender-ref ref="CONSOLE"/>
??????? <appender-ref ref="FILE-DEBUG"/>
??? </root>
</log4j:configuration>
