log4j 配置文件

log4j.rootCategory=INFO,stdout,FILE,DATABASE

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.FILE=org.apache.log4j.DailyRollingFileAppender
#log4j.appender.FILE=org.apache.log4j.RollingFileAppender
#log4j.appender.FILE.maxBackupIndex=100
#log4j.appender.FILE.maxFileSize=10MB
log4j.appender.FILE.File=d:\\log4jtest.log
log4j.appender.FILE.DatePattern='_'yyyy-MM-dd'.log' 
log4j.appender.FILE.Append=true
log4j.appender.FILE.BufferSize=16384
log4j.appender.FILE.ImmediateFlush=true
log4j.appender.FILE.Threshold=INFO
log4j.appender.FILE.BufferedIO=false
log4j.appender.FILE.layout=org.apache.log4j.PatternLayout
log4j.appender.FILE.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss.SSS} %t [%p] - %m --> [%l]%n
log4j.category.org.springframework.web=DEBUG

log4j.appender.DATABASE=org.apache.log4j.jdbc.JDBCAppender
log4j.appender.DATABASE.driver=com.mysql.jdbc.Driver
log4j.appender.DATABASE.URL=jdbc:mysql://116.228.154.114:3306/edutest
log4j.appender.DATABASE.user=yunqitv
log4j.appender.DATABASE.password=1qaz@WSX
log4j.appender.DATABASE.layout=org.apache.log4j.PatternLayout
log4j.appender.DATABASE.sql=insert into log_icecoldmonitor(level,category,thread,time,location,note) values('%p','%c','%t','%d{yyyy-MM-dd HH:mm:ss:SSS}','%l','%m')



CREATE TABLE `log_icecoldmonitor` ( 
  `Id` int(11) NOT NULL AUTO_INCREMENT, 
   `level` varchar(255) NOT NULL DEFAULT '' COMMENT '优先级', 
   `category` varchar(255) NOT NULL DEFAULT '' COMMENT '类目', 
   `thread` varchar(255) NOT NULL DEFAULT '' COMMENT '进程', 
  `time` varchar(30) NOT NULL DEFAULT '' COMMENT '时间', 
  `location` varchar(255) NOT NULL DEFAULT '' COMMENT '位置', 
   `note` text COMMENT '日志信息', 
   PRIMARY KEY (`Id`) 
)