扩展Log4j 1.2中的JDBCAppender

最新推荐文章于 2024-12-06 10:43:36 发布

原创最新推荐文章于 2024-12-06 10:43:36 发布 · 1k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

本文介绍如何扩展Log4j的JDBCAppender来解析日志消息，并将特定信息写入数据库的不同字段中。通过自定义SQL语句格式化方法，实现了从日志消息中提取操作员ID和动作等信息。

扩展Log4j 1.2中的JDBCAppender

Log4j的日志记录功能已经在Java项目被广泛使用，不但可以记录在文件中，而且通过org.apache.log4j.jdbc.JDBCAppender记录在数据库中。但是有时候我们还需要从Message串中提取不同的信息，存到相应的数据库栏位中。如，我在HeJian项目中需要Message信息中包括了操作人员ID和执行的动作，我需要把两个信息分解开来存到不同的栏位，这个时候就需要扩展JDBCAppender.

例子如下：

import java.io.UnsupportedEncodingException;
import java.net.URLDecoder;
import java.net.URLEncoder;
import java.sql.SQLException;
import java.util.Iterator;

import org.apache.log4j.jdbc.JDBCAppender;
import org.apache.log4j.spi.ErrorCode;
import org.apache.log4j.spi.LoggingEvent;

public class ExtendsLog4j extends JDBCAppender {

//处理默认SQL语句，使之成为你需要的SQL语句
public String FormatSql(String s) {
System.out.println(s);
String tmpStr = s.substring(0, s.lastIndexOf("$"));
tmpStr = tmpStr.substring(tmpStr.lastIndexOf("$") + 1);
String array[] = tmpStr.split(" - ");
System.out.println(array.length + " " + array[1]);
if (array.length > 1) {
   s = replaceFirst(s, tmpStr, array[0]);
   s = replaceFirst(s, "$" + tmpStr + "$", array[1].replaceAll("'", "''"));
} else {
   s = replaceFirst(s, tmpStr, "");
   s = replaceFirst(s, "$" + tmpStr + "$", array[0].replaceAll("'", "''"));
}
System.out.println(s);
return s;
}

public void flushBuffer() {
removes.ensureCapacity(buffer.size());
for (Iterator i = buffer.iterator(); i.hasNext();) {
   try {
    LoggingEvent logEvent = (LoggingEvent) i.next();
    String sql = getLogStatement(logEvent);
    sql = FormatSql(sql);
    if (!sql.equals("")) {
     execute(sql);
    }
    removes.add(logEvent);
   } catch (SQLException e) {
    errorHandler.error("Failed to excute sql", e, ErrorCode.FLUSH_FAILURE);
   }
}

// remove from the buffer any events that were reported
// buffer.removeAll(removes);

// clear the buffer of reported events
// removes.clear();
}

public String[] split(String source, String div) {
int arynum = 0;
int intIdx = 0;
int intIdex = 0;
int div_length = div.length();
if (source.compareTo("") != 0) {
   if (source.indexOf(div) != -1) {
    intIdx = source.indexOf(div);
    int intCount = 1;
    do {
     if (source.indexOf(div, intIdx + div_length) != -1) {
      intIdx = source.indexOf(div, intIdx + div_length);
      arynum = intCount;
     } else {
      arynum += 2;
      break;
     }
     intCount++;
    } while (true);
   } else {
    arynum = 1;
   }
} else {
   arynum = 0;
}
intIdx = 0;
intIdex = 0;
String returnStr[] = new String[arynum];
if (source.compareTo("") != 0) {
   if (source.indexOf(div) != -1) {
    intIdx = source.indexOf(div);
    returnStr[0] = source.substring(0, intIdx);
    int intCount = 1;
    do {
     if (source.indexOf(div, intIdx + div_length) != -1) {
      intIdex = source.indexOf(div, intIdx + div_length);
      returnStr[intCount] = source.substring(intIdx + div_length, intIdex);
      intIdx = source.indexOf(div, intIdx + div_length);
     } else {
      returnStr[intCount] = source.substring(intIdx + div_length, source.length());
      break;
     }
     intCount++;
    } while (true);
   } else {
    returnStr[0] = source.substring(0, source.length());
    return returnStr;
   }
} else {
   return returnStr;
}
return returnStr;
}

public String dealNull(String str) {
String returnstr = null;
if (str == null)
returnstr = "";
else
returnstr = str;
return returnstr;
}

public String replace(String str, String substr, String restr) {
String tmp[] = split(str, substr);
String returnstr = null;
if (tmp.length != 0) {
   returnstr = tmp[0];
   for (int i = 0; i < tmp.length - 1; i++)
    returnstr = dealNull(returnstr) + restr + tmp[i + 1];

}
return dealNull(returnstr);
}

public String replaceFirst(String str, String substr, String restr) {
String tmp[] = split(str, substr);
String returnstr = null;
if (tmp.length != 0) {
   returnstr = tmp[0];
   for (int i = 0; i < tmp.length - 1; i++)
    if (i == 0) {
     returnstr = dealNull(returnstr) + restr + tmp[i + 1];
    } else {
     returnstr = dealNull(returnstr) + substr + tmp[i + 1];
    }

}
return dealNull(returnstr);
}
}

配置文件：

log4j.appender.A3 = com.hejian.ExtendsLog4j
log4j.appender.A3.BufferSize = 1
log4j.appender.A3.Driver = com.microsoft.jdbc.sqlserver.SQLServerDriver
log4j.appender.A3.URL = jdbc:microsoft:sqlserver://C01PC00443:1433;DatabaseName=NorthWind
log4j.appender.A3.User = sa
log4j.appender.A3.Password =
log4j.appender.A3.layout = org.apache.log4j.PatternLayout
log4j.appender.A3.layout.ConversionPattern = INSERT INTO log4j (createDate, thread, priority, category,opuser, message) values( getdate(), '%t', '%-5p', '%c', '%m' ,'$%m$')

import org.apache.log4j.jdbc.JDBCAppender;
import org.apache.log4j.spi.ErrorCode;
import org.apache.log4j.spi.LoggingEvent;

public class ExtendsLog4j extends JDBCAppender {