Spring+mybatis 配置输出SQL语句

来源：互联网发布：二少脸型数据编辑：程序博客网时间：2024/05/18 17:24

在这个博客学习的http://blog.csdn.net/zht666/article/details/9042373

首先先创建个log4j.xml文件，然后在里面加入如下代码。

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE log4j:configuration SYSTEM "http://toolkit.alibaba-inc.com/dtd/log4j/log4j.dtd"><log4j:configuration xmlns:log4j='http://jakarta.apache.org/log4j/'><!-- ===================================================================== --><!-- 定义全局输出适配器 --><!-- ===================================================================== --><appender name="consoleAppender" class="org.apache.log4j.ConsoleAppender"><layout class="org.apache.log4j.PatternLayout"><param name="ConversionPattern" value="[%d{yyyy-MM-dd HH:mm:ss.SSS}] %m%n" /></layout></appender><!-- Mybatis and SQL --><logger name="org.apache.ibatis" additivity="true"><level value="DEBUG" /><appender-ref ref="consoleAppender" /></logger><logger name="org.mybatis.spring" additivity="true"><level value="ERROR" /><appender-ref ref="consoleAppender" /></logger><logger name="java.sql" additivity="true"><level value="DEBUG" /><appender-ref ref="consoleAppender" /></logger><logger name="java.sql.Connection" additivity="true"><level value="DEBUG" /><appender-ref ref="consoleAppender" /></logger><logger name="java.sql.Statement" additivity="true"><level value="DEBUG" /><appender-ref ref="consoleAppender" /></logger><logger name="java.sql.PreparedStatement" additivity="true"><level value="DEBUG" /><appender-ref ref="consoleAppender" /></logger><!-- Spring --><logger name="org.springframework" additivity="true"><level value="ERROR" /><appender-ref ref="consoleAppender" /></logger><!-- ActiveMQ --><logger name="org.apache.activemq" additivity="true"><level value="ERROR" /><appender-ref ref="consoleAppender" /></logger><!-- ===================================================================== --><!-- 根日志记录器 --><!-- ===================================================================== --><root><level value="DEBUG" /><appender-ref ref="consoleAppender" /></root></log4j:configuration>

然后在web.xml里面配置一下

<context-param><param-name>log4jConfigLocation</param-name><param-value>/WEB-INF/log4j.xml</param-value></context-param><context-param><param-name>log4jRefreshInterval</param-name><param-value>60000</param-value></context-param>

就OK了。

测试输出结果

0 0