[b]1.log4j.properties 放在src目录下 并且要导入log4j包[/b]
[align=left]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 [/align]
[b]
[b]2. 导入mysql包 [/b][/b]
[align=left] 表结构(数据库：beian)
CREATE TABLE LogInfo (
ID int primary key auto_increment,
logDATE datetime ,
logTHREAD varchar(200) ,
logLEVEL varchar(200),
logCLASS varchar(200) ,
logMESSAGES varchar(2000)
) [/align][b]3.写一个带main方法的Java类,测试： [/b]
[align=left] 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("用户正在测试....");
}
} [/align]
