jdk1.4的logging的数据库handler实现源码

最新推荐文章于 2021-06-11 02:15:35 发布

最新推荐文章于 2021-06-11 02:15:35 发布 · 67 阅读

文章标签：

#MySQL #SQL #JDBC

此博客展示了使用Java JDBC连接MySQL数据库进行日志记录的代码。通过注册MySQL驱动，建立数据库连接，执行插入SQL语句将日志信息存入数据库，并在最后关闭连接。还包含了测试方法，多次插入日志进行验证。

package com.benqguru.palau.log.jdk14log;

import java.util.logging.*;
import java.sql.*;

class JDBCHandler
extends Handler {

public void flush() {
}

public void publish(LogRecord record) {
Connection conn = null;

PreparedStatement pstmt = null;

try {
Driver d = (Driver) (Class.forName("org.gjt.mm.mysql.Driver").
newInstance());
DriverManager.registerDriver(d);
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/logtest",
"root", "");
if (conn != null) {
Object[] content = record.getParameters();
String sql = "insert into MyLog(logTime,EventType) values(?,?)";
pstmt = conn.prepareStatement(sql);
pstmt.setLong(1, record.getMillis());
pstmt.setString(2, (String) content[0]);
//save loginfo in databse
pstmt.execute();
}
}
catch (Exception e) {
e.printStackTrace();
}
finally {
if (conn != null) {
try {
conn.close();
}
catch (Exception ex) {
ex.printStackTrace();
}
}
if (pstmt != null) {
try {
pstmt.close();
}
catch (Exception ex) {
ex.printStackTrace();
}
}
}
}

public void close() throws java.lang.SecurityException {

}

//测试方法
public static void main(String[] args) {
Logger log = Logger.getLogger(
"com.benqguru.commons.logging.test.JDBCHandler");
JDBCHandler jdbc = new JDBCHandler();
log.addHandler(jdbc);
String[] content = {
"insert"};
LogRecord lr = new LogRecord(Level.INFO, "second test message");
lr.setParameters(content);
// first insert log
log.log(Level.INFO, "first test message", content);
//second insert log
log.log(lr);
}
}