mybatis 用Log4j输出日志

1 导入commons-logging.jar和log4j-1.2.15.jar包

2 在web项目下增加l og4j.properties

3 log4j.properties的内容如下

# debug config start
log4j.rootLogger=debug,stdout,log,errorlog,debuglog
log4j.Logger=search,Test  
log4j.logger.java.sql=DEBUG
log4j.logger.java.sql.ResultSet=DEBUG
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
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
 
 #   degug config over
  
  
###Console ###  
log4j.appender.stdout = org.apache.log4j.ConsoleAppender  
log4j.appender.stdout.Target = System.out  
log4j.appender.stdout.layout = org.apache.log4j.PatternLayout  
log4j.appender.stdout.layout.ConversionPattern = %d{ABSOLUTE} [ %t ] [ %p ]\:%L - %m%n  
  
### Log ###    
log4j.appender.log = org.apache.log4j.DailyRollingFileAppender  
log4j.appender.log.File =log/info/info.log
log4j.appender.log.Append = true  
log4j.appender.log.Threshold = INFO  
log4j.appender.log.DatePattern='.'yyyy-MM-dd  
log4j.appender.log.layout = org.apache.log4j.PatternLayout  
log4j.appender.log.layout.ConversionPattern = %-d{yyyy-MM-dd HH\:mm\:ss} [ %t ] %m%n  
  
### Error ###  
log4j.appender.errorlog = org.apache.log4j.DailyRollingFileAppender  
log4j.appender.errorlog.File=log/error/error.log
log4j.appender.errorlog.Append = true  
log4j.appender.errorlog.Threshold = ERROR   
log4j.appender.errorlog.DatePattern='.'yyyy-MM-dd  
log4j.appender.errorlog.layout = org.apache.log4j.PatternLayout  

### DEBUG ###  
log4j.appender.debuglog = org.apache.log4j.DailyRollingFileAppender  
log4j.appender.debuglog.File=log/debug/debug.log
log4j.appender.debuglog.Append = true  
log4j.appender.debuglog.Threshold = DEBUG   
log4j.appender.debuglog.DatePattern='.'yyyy-MM-dd  
log4j.appender.debuglog.layout = org.apache.log4j.PatternLayout