使用log4j获取SQL语句

    log4j.rootLogger=DEBUG,stdout  
    log4j.logger.java.sql.PreparedStatement=DEBUG,stdout  
      
    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.appender.logfile=org.apache.log4j.FileAppender  
    log4j.appender.logfile.File=c:/log.txt  
    log4j.appender.logfile.layout=org.apache.log4j.PatternLayout  
    log4j.appender.logfile.layout.ConversionPattern=%d %p [%c] - %m%n 

• 2009-04-29 09:47:27,078 DEBUG [com.ibatis.common.jdbc.SimpleDataSource] - Created connection 3045408.  
• 2009-04-29 09:47:27,078 DEBUG [java.sql.Connection] - {conn-100000} Connection  
• 2009-04-29 09:47:27,078 DEBUG [java.sql.Connection] - {conn-100000} Preparing Statement:  SELECT * FROM pubttree        
• 2009-04-29 09:47:27,125 DEBUG [java.sql.PreparedStatement] - {pstm-100001} Executing Statement:  SELECT * FROM pubttree        
• 2009-04-29 09:47:27,125 DEBUG [java.sql.PreparedStatement] - {pstm-100001} Executing Statement:  SELECT * FROM pubttree        
• 2009-04-29 09:47:27,125 DEBUG [java.sql.PreparedStatement] - {pstm-100001} Parameters: []  
• 2009-04-29 09:47:27,125 DEBUG [java.sql.PreparedStatement] - {pstm-100001} Parameters: []  
• 2009-04-29 09:47:27,125 DEBUG [java.sql.PreparedStatement] - {pstm-100001} Types: []  
• 2009-04-29 09:47:27,125 DEBUG [java.sql.PreparedStatement] - {pstm-100001} Types: []  
• 2009-04-29 09:47:27,125 DEBUG [java.sql.ResultSet] - {rset-100002} ResultSet  
• 2009-04-29 09:47:27,156 DEBUG [java.sql.ResultSet] - {rset-100002} Header: [id, name]  
• 2009-04-29 09:47:27,156 DEBUG [java.sql.ResultSet] - {rset-100002} Result: [3, aaa]  
• 2009-04-29 09:47:27,187 DEBUG [com.ibatis.common.jdbc.SimpleDataSource] - Returned connection 3045408 to pool