Log4j写入数据库详解

if exists (select * from dbo.sysobjects where id = object_id(N‘[dbo].[WDZLOG]‘) and OBJECTPROPERTY(id, N‘IsUserTable‘) = 1)
drop table [dbo].[WDZLOG]
GO

CREATE TABLE [dbo].[WDZLOG] (
    [WDZLOGID] [int] IDENTITY (1, 1) NOT NULL ,
    [LogName] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,//用户ID
    [UserName] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,//用户姓名
    [Class] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,//类名
    [Mothod] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL //,方法名
    [CreateTime] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,//产生时间
    [LogLevel] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,//日志级别
    [MSG] [varchar] (555) COLLATE Chinese_PRC_CI_AS NULL //日志信息
) ON [PRIMARY]
GO

log4j.properties
log4j.rootLogger=INFO,stdout
            
log4j.logger.org.springframework.web.servlet=INFO,db

log4j.logger.org.springframework.beans.factory.xml=INFO
log4j.logger.com.neam.stum.user=INFO,db

log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %p [%c] - - <%m>%n

log4j.appender.logfile=org.apache.log4j.DailyRollingFileAppender
log4j.appender.logfile.File=${webapp.root}/WEB-INF/logs/exppower.log
log4j.appender.logfile.DatePattern=.yyyy-MM-dd
log4j.appender.logfile.layout=org.apache.log4j.PatternLayout
log4j.appender.logfile.layout.ConversionPattern=%d %p [%c] wang- <%m>%n

########################

# JDBC Appender

#######################


#log4j.logger.business=INFO,db
#log4j.appender.db=com.neam.commons.MyJDBCAppender
log4j.appender.db=JDBCExtAppender

log4j.appender.db.BufferSize=10

log4j.appender.db.sqlname=log

log4j.appender.db.driver=net.sourceforge.jtds.jdbc.Driver
                      
log4j.appender.db.URL=jdbc:jtds:SqlServer://localhost:1433;DatabaseName=pubs

log4j.appender.db.user=sa

log4j.appender.db.password=sa

log4j.appender.db.sql=insert into WDZLOG (LogName,UserName,Class,Mothod,createTime,LogLevel,MSG) values (‘%X{userId}‘,‘%X{userName}‘,‘%C‘,‘%M‘,‘%d{yyyy-MM-dd HH:mm:ss}‘,‘%p‘,‘%m‘)

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

import java.io.IOException;
import javax.servlet.Filter;
import javax.servlet.FilterChain;
import javax.servlet.FilterConfig;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;

import org.apache.log4j.Logger;
import org.apache.log4j.MDC;

import com.neam.domain.User;

public class ResFilter implements Filter{

     
    private final static double DEFAULT_USERID= Math.random()*100000.0;  

    public void destroy() {
    }

    public void doFilter(ServletRequest request, ServletResponse response,
           FilterChain chain) throws IOException, ServletException {
       HttpServletRequest req=(HttpServletRequest)request;
        HttpSession session= req.getSession();
        if (session==null){
            MDC.put("userId",DEFAULT_USERID);  
        }
        else{
            User customer=(User)session.getAttribute("user");
            if (customer==null){
                MDC.put("userId",DEFAULT_USERID);
                MDC.put("userName",DEFAULT_USERID);
            }
            else
            {
                MDC.put("userId",customer.getName());
                MDC.put("userName",customer.getName());
            }
        }
        //logger.info("test for MDC.");

       chain.doFilter(request, response);
    }
    public void init(FilterConfig Config) throws ServletException {
//     this.filterConfig = Config;
//     String ccc = Config.getServletContext().getInitParameter("cherset");
//     this.targetEncoding = Config.getInitParameter("cherset");

    }
}

private Log logger = LogFactory.getLog(this.getClass());

在具体方法中就可以写入日志
logger.info("");
logger.debug("");
logger.warn("");
logger.error("");