ibatis执行SQL语句打印控制台的log4j.xml文件配置方法

原文：http://blog.csdn.net/liulin_good/article/details/6101526  ＆＆ http://blog.csdn.net/guirudaoge/article/details/8609080 

1、打印SQL语句到控制台

在开发调试过程中，我遇到在调试 ibatis 执行的 SQL 是否正确时，无法查看 ibatis 是否执行了我想要执行的 SQL 语句，现发现一种解决方案就是在 log4j.xml 配置文件中加入以下代码就可以在控制台中打印出 ibatis 执行的 SQL 语句：

<!--begin ibatis-->
	<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>
	<!--end ibatis-->

2、DEBUG调试如何跟踪

jar包：sourceforge.ibatis-2.3.4-sources.jar

file ：com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.java

protected void executeQueryWithCallback(StatementScope statementScope, Connection conn, Object parameterObject, Object resultObject, RowHandler rowHandler, int skipResults, int maxResults)
      throws SQLException {
    
    try {
     
//断点
      errorContext.setMoreInfo("Check the SQL statement.");
      String sqlString = sql.getSql(statementScope, parameterObject);

      
    } catch (SQLException e) {
      errorContext.setCause(e);
      throw new NestedSQLException(errorContext.toString(), e.getSQLState(), e.getErrorCode(), e);
    } catch (Exception e) {
      errorContext.setCause(e);
      throw new NestedSQLException(errorContext.toString(), e);
    }
  }