Log4J对数据库的操作:
其目的就是把日志信息写入数据库以方便开发人员和测试人员查询。
下面是写入数据库的配置文件:log4j.properties
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
对其应用的源文件:
package
database.servlet;
import java.io.File;
import java.io.LineNumberReader;
import java.io.FileReader;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.util.Vector;
import java.sql.Driver;
import java.sql.DriverManager;
// import servlet packages
import javax.servlet.http.HttpServlet;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
// import log4j packages
import org.apache.log4j.Logger;
import org.apache.log4j.PropertyConfigurator;
public class SetupServlet extends HttpServlet{
public void init(ServletConfig config) throws ServletException{
super .init(config);
// first thing to do, is to set up the Driver that we might be using
// in case of JDBCAppender
try {
// Driver d =(Driver)(Class.forName("org.gjt.mm.mysql.Driver").newInstance());
Driver d = (Driver)(Class.forName( " oracle.jdbc.driver.OracleDriver " ).newInstance());
DriverManager.registerDriver(d);
// 加载JDBC驱动程序,当准备将日志记录到数据库的时候可以使用
} catch (Exception e){ System.err.println(e); }
// next load up the properties
// 启动时从web.xml中获得配置文件的信息
String props = config.getInitParameter( " props " );
if (props == null || props.length() == 0 ||
! ( new File(props)).isFile()){
System.err.println(
" ERROR: Cannot read the configuration file. " +
" Please check the path of the config init param in web.xml " );
throw new ServletException();
}
}
public void destroy(){
super .destroy();
}
}
import java.io.File;
import java.io.LineNumberReader;
import java.io.FileReader;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.util.Vector;
import java.sql.Driver;
import java.sql.DriverManager;
// import servlet packages
import javax.servlet.http.HttpServlet;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
// import log4j packages
import org.apache.log4j.Logger;
import org.apache.log4j.PropertyConfigurator;
public class SetupServlet extends HttpServlet{
public void init(ServletConfig config) throws ServletException{
super .init(config);
// first thing to do, is to set up the Driver that we might be using
// in case of JDBCAppender
try {
// Driver d =(Driver)(Class.forName("org.gjt.mm.mysql.Driver").newInstance());
Driver d = (Driver)(Class.forName( " oracle.jdbc.driver.OracleDriver " ).newInstance());
DriverManager.registerDriver(d);
// 加载JDBC驱动程序,当准备将日志记录到数据库的时候可以使用
} catch (Exception e){ System.err.println(e); }
// next load up the properties
// 启动时从web.xml中获得配置文件的信息
String props = config.getInitParameter( " props " );
if (props == null || props.length() == 0 ||
! ( new File(props)).isFile()){
System.err.println(
" ERROR: Cannot read the configuration file. " +
" Please check the path of the config init param in web.xml " );
throw new ServletException();
}
}
public void destroy(){
super .destroy();
}
}