mybatis 使用log4j打印sql

需要两个jar包：log4j.jar、commons-logging.jar

log4j.properties内容如下：

#####################################################

log4j.rootLogger=DEBUG, stdout, logfile


log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=[IMS] %d{yyyy-MM-dd HH:mm:ss} - %p - [%t] - [%c.%M : %L] - %m%n


log4j.appender.logfile=org.apache.log4j.DailyRollingFileAppender
log4j.appender.logfile.File=/ProjectLogs/TestSSMProject/TestSSMProject.log
log4j.appender.logfile.MaxFileSize=1KB
log4j.appender.logfile.MaxBackupIndex=3
log4j.appender.logfile.Threshold=DEBUG
log4j.appender.logfile.layout=org.apache.log4j.PatternLayout
log4j.appender.logfile.layout.ConversionPattern=[IMS] %d{yyyy-MM-dd HH:mm:ss} - %p - [%t] - [%c.%M : %L] - %m%n


log4j.logger.org.mybatis=DEBUG
log4j.logger.java.sql=DEBUG

#####################################################

注意“log4j.logger.org.mybatis”与“log4j.rootLogger”日志记录优先级，前者不能比后者低，否则打印不出来！！切记 ！！！！