ibatis打印sql日志的方法

ibatis打印sql日志的方法，在log4j.xml中加入如下配置即可

<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.properties配置如下：

log4j.appender.stdout=org.apache.log4j.ConsoleAppender  
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout  
log4j.appender.stdout.layout.ConversionPattern=%d %p [%c] - %m%n  
  
  
log4j.logger.com.ibatis=debug  
log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=debug  
log4j.logger.com.ibatis.common.jdbc.ScriptRunner=debug  
log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=debug  
log4j.logger.java.sql.Connection=debug  
log4j.logger.java.sql.Statement=debug  
log4j.logger.java.sql.PreparedStatement=debug,stdout