log4j mysql_log4j写入mysql数据库 | 学步园

将日志信息记入mysql数据库。

log4j.properties放在src根目录下。

配置内容如下：

log4j.rootLogger=ERROR,appender1,appender2

log4j.appender.appender1=org.apache.log4j.ConsoleAppender

log4j.appender.appender1.layout=org.apache.log4j.PatternLayout

log4j.appender.appender1.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss:SSS}[%p]: %m%n

log4j.appender.appender2=org.apache.log4j.jdbc.JDBCAppender

log4j.appender.appender2.driver=com.mysql.jdbc.Driver

log4j.appender.appender2.URL=jdbc:mysql://localhost:3306/mydb?useUnicode=true&characterEncoding=UTF-8

log4j.appender.appender2.user=admin

log4j.appender.appender2.password=123456

log4j.appender.appender2.sql=insert into logtable (cdate, message) VALUES ('%d{yyyy-MM-dd hh:mm:ss}', '%c %p %m %n')

log4j.appender.appender2.layout=org.apache.log4j.PatternLayout

程序使用如下：

public class TestLog {

public static Logger log = Logger.getLogger(TestLog.class);

public static void main(String[] args)

{

try {

throw new Exception("abcdefg");

} catch (Exception e) {

log.error(e.getMessage());

}

}

}