当前位置: 代码迷 >> SQL >> Ibatis施行SQL操作把SQL打印到控制台
  详细解决方案

Ibatis施行SQL操作把SQL打印到控制台

热度:100   发布时间:2016-05-05 15:15:23.0
Ibatis执行SQL操作把SQL打印到控制台

要想让Ibatis打印SQL语句到控制台,可以在log4j.xml文件加入以下语句:

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE log4j:configuration SYSTEM "log4j.dtd"><log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">	<appender name="IBatis" class="org.apache.log4j.ConsoleAppender">		<layout class="org.apache.log4j.PatternLayout">			<param name="ConversionPattern"				value="%-4r [%t] %-5p %c %x - %m%n" />		</layout>		<filter class="org.apache.log4j.varia.LevelRangeFilter">			<param name="LevelMin" value="DEBUG" />			<param name="LevelMax" value="DEBUG" />		</filter>	</appender>	<logger name="com.ibatis" additivity="true">		<level value="DEBUG"/>	</logger>	<logger name="java.sql.Connection" additivity="true">		<level value="DEBUG" />	</logger>	<logger name="java.sql.Statement" additivity="true">		<level value="DEBUG" />	</logger>	<logger name="java.sql.PreparedStatement" additivity="true">		<level value="DEBUG" />		<appender-ref ref="IBatis" />	</logger>	<logger name="java.sql.ResultSet" additivity="true">		<level value="DEBUG" />		<appender-ref ref="IBatis" />	</logger></log4j:configuration>
  相关解决方案