Log4J从基础到应用

#####define RootLogger#####
log4j.rootLogger=INFO,console
####define a logger named helloLog####
log4j.logger.helloLog=WARN,console,file

####Appenders#####
log4j.appender.console=org.apache.log4j.ConsoleAppender
log4j.appender.file=org.apache.log4j.RollingFileAppender
log4j.appender.file.File=D:/log.txt
#######LAYOUTS##########
log4j.appender.console.layout=org.apache.log4j.PatternLayout
log4j.appender.console.layout.ConversionPattern=%d  %t %c  %p - %m%n

log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=%d  %t %c  %p - %m%n

########JDBC###########
log4j.logger.jdbc.sqltiming=INFO
log4j.logger.jdbc.sqlonly=WARN
log4j.logger.jdbc.audit=WARN
log4j.logger.jdbc.connection=WARN

package javaee.net.cn.websocket;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.log4j.Logger;
import org.apache.log4j.PropertyConfigurator;
public class MyServlet  extends HttpServlet {

    private static final long serialVersionUID = 1L;

    Logger logger = Logger.getLogger(this.getClass());
    
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp)
            throws ServletException, IOException {;
        Connection conn = null;
        PreparedStatement stmt = null;
        String content = "hello";
        try {
            Class.forName("net.sf.log4jdbc.DriverSpy");
            conn = DriverManager.getConnection("jdbc:log4jdbc:mysql://ip:3306/db1?user=root&password=*****");
            conn.setAutoCommit(false);
            String sql = "insert into db1_table1 (content) values (?)";
            stmt = conn.prepareStatement(sql);
            stmt.setString(1,content);
            stmt.execute();
            conn.commit();
            conn.setAutoCommit(true);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch(SQLException e) {
            e.printStackTrace();
            try {
                if(conn != null)
                {
                    conn.rollback();
                    conn.setAutoCommit(true);
                }
            } catch (SQLException e1) {
                e1.printStackTrace();
            }
        }finally {
            try {
                if(stmt != null)
                    stmt.close();
                if(conn != null)
                    conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
    
    @Override
    public void init() throws ServletException {
        //获取配置文件的完整路径
        String path = this.getServletContext().getRealPath("/");
        String profile = path+this.getInitParameter("profile");
        //配置Log4j环境
        PropertyConfigurator.configure(profile);
    }
    
}

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0">
  <display-name>Tab3</display-name>
  <welcome-file-list>
    <welcome-file>index.html</welcome-file>
    <welcome-file>index.htm</welcome-file>
  </welcome-file-list>
  <filter>
      <filter-name>NoteFilter</filter-name>
      <filter-class>javaee.net.cn.websocket.NoteFilter</filter-class>
  </filter>
  <filter-mapping>
      <filter-name>NoteFilter</filter-name>
      <url-pattern>/myServlet</url-pattern>
  </filter-mapping>
  
   <filter>
      <filter-name>HtmlFilter</filter-name>
      <filter-class>javaee.net.cn.websocket.HtmlFilter</filter-class>
  </filter>
  <filter-mapping>
      <filter-name>HtmlFilter</filter-name>
      <url-pattern>/myServlet</url-pattern>
  </filter-mapping>
  <servlet>
      <servlet-name>MyServlet</servlet-name>
      <servlet-class>javaee.net.cn.websocket.MyServlet</servlet-class>
      <init-param>
          <param-name>profile</param-name>
          <param-value>/WEB-INF/log4j.properties</param-value>
      </init-param>
      <load-on-startup>1</load-on-startup>
  </servlet>
  <servlet-mapping>
      <servlet-name>MyServlet</servlet-name>
      <url-pattern>/myServlet</url-pattern>
  </servlet-mapping>
</web-app>