ibatls打印sql语句

 为了方便跟踪调试,利用log4j把ibatis执行的sql语句,参数,执行结果打印出来是一个不错的做法,只要在在配置文件log4j.properties中加入以下代码就可以了:

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, fileout  
log4j.logger.java.sql.ResultSet = DEBUG

log4j.xml

<!--监控sql-->

   <appendername="pic-sql"

      class="com.alibaba.common.logging.spi.log4j.FileAppender">

      <paramname="file"value="${picturecenter.loggingRoot}/pic-sql.log"/>

      <paramname="Append"value="true"/>

      <paramname="DatePattern"value="'.'yyyy-MM-dd"/>

      <layoutclass="org.apache.log4j.PatternLayout">

          <paramname="ConversionPattern"value="%d %-5p [%c] %m%n"/>

      </layout>

   </appender>

   <loggername="com.ibatis">

      <levelvalue="DEBUG"/>

      <appender-refref="pic-sql"/>

   </logger>

   <loggername="com.ibatis.common.jdbc.SimpleDataSource">

      <levelvalue="DEBUG"/>

      <appender-refref="pic-sql"/>

   </logger>

   <loggername="com.ibatis.common.jdbc.ScriptRunner">

      <levelvalue="DEBUG"/>

      <appender-refref="pic-sql"/>

   </logger>

   <loggername="com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate">

      <levelvalue="DEBUG"/>

      <appender-refref="pic-sql"/>

   </logger>

   <loggername="java.sql.Connection">

      <levelvalue="DEBUG"/>

      <appender-refref="pic-sql"/>

   </logger>

   <loggername="java.sql.PreparedStatement">

      <levelvalue="DEBUG"/>

      <appender-refref="pic-sql"/>

    </logger>