log4j级别及保存数据到数据库中

优先级从高到低分别是ERROR、WARN、INFO、DEBUG。通过在这里定义的级别，您可以控制到应用程序中相应级别的日志信息的开关。比如在这里定义了INFO级别，则应用程序中所有DEBUG级别的日志信息将不被打印出来。程序会打印高于或等于所设置级别的日志，设置的日志等级越高，打印出来的日志就越少。

自定义log4j存储的值，通过'%X{userid}引用，通过
       
        MDC.put("userid",0 );

来赋值

log4j.rootLogger=DEBUG,stdout,debug,info,error
# stdout
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{yyyy/MM/dd HH:mm:ss} [%p]%t-%c-%m%n
#debug
log4j.appender.debug=org.apache.log4j.DailyRollingFileAppender
log4j.appender.debug.File=${catalina.home}/logs/weibaoshop
#log4j.appender.R.BufferedIO=true
#log4j.appender.R.BufferSize=8192
#log4j.appender.R.MaxFileSize=10MB
#log4j.appender.R.MaxBackupIndex=10
log4j.appender.debug.DatePattern='.'yyyy-MM-dd'.log'
log4j.appender.debug.layout=org.apache.log4j.PatternLayout
log4j.appender.debug.layout.ConversionPattern=%d{yyyy/MM/dd HH:mm:ss} [%p]%t-%c-%m%n
log4j.appender.debug.encoding=UTF-8
#info
 log4j.logger.org.springframework=OFF
 log4j.appender.info = org.apache.log4j.jdbc.JDBCAppender
 log4j.appender.info.layout=org.apache.log4j.PatternLayout
 log4j.appender.info.BufferSize=1
 log4j.appender.info.Threshold =INFO
 log4j.appender.info.driver=com.mysql.jdbc.Driver
 log4j.appender.info.URL=jdbc:mysql://115.28.64.72:3306/weibaoshop?useOldAliasMetadataBehavior=true
 log4j.appender.info.user=epimap
 log4j.appender.info.password=epimap.123456
 log4j.appender.info.sql=insert into wbs_log_info(Class,Method,username,userid,date,LogLevel,message) values ('%X{class}','%X{method}','%X{username}','%X{userid}','%d{yyyy/MM/dd HH:mm:ss}','%p','%m')
 #error
 log4j.appender.error = org.apache.log4j.jdbc.JDBCAppender
 log4j.appender.error.layout=org.apache.log4j.PatternLayout
 log4j.appender.error.BufferSize=1
 log4j.appender.error.driver=com.mysql.jdbc.Driver
 log4j.appender.error.URL=jdbc:mysql://115.28.64.72:3306/weibaoshop?useOldAliasMetadataBehavior=true
 log4j.appender.error.Threshold =ERROR
 log4j.appender.error.user=epimap
 log4j.appender.error.password=epimap.123456
 log4j.appender.error.sql=insert into wbs_logerror_info(Class,Method,username,userid,date,exceptionMsg) values ('%X{class}','%X{method}','%X{username}','%X{userid}','%d{yyyy/MM/dd HH:mm:ss}','%m')
#mybatis
log4j.logger.org.mybatis.example.BlogMapper=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
#log4j.logger.java.sql.Connection=DEBUG
#log4j.logger.java.sql.Statement=DEBUG
#log4j.logger.java.sql.PreparedStatement=DEBUG