log4j日志保存

1.log4j.properties 放在src目录下  并且要导入log4j包
   

log4j.rootLogger=INFO,DATABASE
   log4j.addivity.org.apache=true
   # JDBC Appender
   log4j.appender.DATABASE.Threshold=INFO
   log4j.appender.DATABASE=org.apache.log4j.jdbc.JDBCAppender
   #log4j.appender.DATABASE.BufferSize=10
   log4j.appender.DATABASE.URL=jdbc:mysql://localhost:3306/beian
   log4j.appender.DATABASE.driver=com.mysql.jdbc.Driver
   log4j.appender.DATABASE.user= root
   log4j.appender.DATABASE.password= root
   log4j.appender.DATABASE.sql=INSERT INTO LogInfo VALUES (null,'%d{yyyy-MM-dd HH:mm:ss}', '%t', '%p', '%l', '%m')
   log4j.appender.DATABASE.layout=org.apache.log4j.PatternLayout

[b]2. 导入mysql包 [/b]
 

  表结构(数据库：beian)
    CREATE TABLE LogInfo (
        ID int primary key auto_increment,
        logDATE  datetime  ,
        logTHREAD  varchar(200) ,
        logLEVEL  varchar(200),
        logCLASS varchar(200)  ,
        logMESSAGES  varchar(2000)
    )

3.写一个带main方法的Java类,测试：
  

package com.edong.log4j.example;
   import org.apache.log4j.BasicConfigurator;
   import org.apache.log4j.Logger;
   public class Log4jTest {
   private static Logger logger=Logger.getLogger(Log4jTest.class);
   public static void main(String[] args){
      BasicConfigurator.configure();
      logger.info("用户正在测试....");
   }
}