Spring+mybatis 配置输出SQL语句

在这个博客学习的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了。

测试输出结果