log4j.properties

这是我自己做的一个选课系统

## LOGGERS ##
#define a logger 
#log4j.rootLogger=DEBUG,console,file
 log4j.rootLogger=INFO,console,file

## APPENDERS ##
# define an appender named console, which is set to be a ConsoleAppender
log4j.appender.console=org.apache.log4j.ConsoleAppender

# define an appender named file, which is set to be a RollingFileAppender
log4j.appender.file=org.apache.log4j.RollingFileAppender
log4j.appender.file.File=d:/demo_log.txt

#set the log's size
log4j.appender.file.MaxFileSize=1000KB
log4j.appender.file.MaxBackupIndex=20

## LAYOUTS ##
# assign a SimpleLayout to console appender
log4j.appender.console.layout=org.apache.log4j.SimpleLayout

# assign a PatternLayout to file appender
log4j.appender.file.layout=org.apache.log4j.PatternLayout
# For debug
# log4j.appender.file.layout.ConversionPattern=[%-5p][%t][%C][%d{yyyy-MM-dd HH:mm:ss}] %m%n
# For deployment
#log4j.appender.file.layout.ConversionPattern=[%-5p][%d{yyyy-MM-dd HH:mm:ss}] %m%n

 log4j.appender.DATABASE=org.apache.log4j.jdbc.JDBCAppender 
 log4j.appender.DATABASE.driver=com.microsoft.jdbc.sqlserver.SQLServerDriver
 log4j.appender.DATABASE.URL=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=ChooseClass
  
 log4j.appender.DATABASE.user=log
 log4j.appender.DATABASE.password= log
 log4j.appender.DATABASE.sql=INSERT INTO log4j(log_date,log_logger,log_level,log_msg) VALUES ('%d{yyyy-MM-dd HH\:mm\:ss}','%c','%p','%m') 
 log4j.appender.DATABASE.layout=org.apache.log4j.PatternLayout 
 #log4j.appender.DATABASE.layout.ConversionPattern='%d','%c','%p','%m'