Log4jTest Log4jMySql

log4j.rootLogger=ERROR, R4

log4j.category.com.helloweenvsfei.logging.Log4jTest=DEBUG,f

log4j.category.com.helloweenvsfei.logging.Log4jMySql=DEBUG,MySqlDataBase

log4j.appender.R4=org.apache.log4j.ConsoleAppender
log4j.appender.R4.Threshold=DEBUG
log4j.appender.R4.layout=org.apache.log4j.PatternLayout
log4j.appender.R4.layout.ConversionPattern=%-d{yyyy-MM-dd HH\:mm\:ss,SSS} [%C]-[%p] %m%n

log4j.appender.f=org.apache.log4j.FileAppender
log4j.appender.f.File=D:\\tmp\\tomcatLog4j.log
log4j.appender.f.Append=true
log4j.appender.f.layout=org.apache.log4j.PatternLayout
log4j.appender.f.layout.ConversionPattern=%-d{yyyy-MM-dd HH\:mm\:ss,SSS} [%C]-[%p] %m%n

log4j.appender.MySqlDataBase=org.apache.log4j.jdbc.JDBCAppender
log4j.appender.MySqlDataBase.Threshold=DEBUG
log4j.appender.MySqlDataBase.URL=jdbc:mysql://localhost:3306/log4j
log4j.appender.MySqlDataBase.driver=com.mysql.jdbc.Driver
log4j.appender.MySqlDataBase.user=root
log4j.appender.MySqlDataBase.password=123
log4j.appender.MySqlDataBase.sql=INSERT INTO tb_log(date,priority,message,classname) VALUES ('%d','%p','%m','%c')
log4j.appender.MySqlDataBase.layout=org.apache.log4j.PatternLayout
log4j.appender.MySqlDataBase.layout.ConversionPattern=%m

 

CREATE DATABASE log4j CHARACTER SET utf8;

USE log4j;

CREATE TABLE tb_log (id INT AUTO_INCREMENT, date VARCHAR(255), priority VARCHAR(255), message TEXT, classname VARCHAR(255), PRIMARY KEY(id));

package com.helloweenvsfei.logging;

import org.apache.log4j.Logger;

public class Log4jTest {

    public static Logger log = Logger.getLogger(Log4jTest.class);

    public static void main(String[] args) {

        log.trace("trace 信息");
        log.trace("trace 一个异常", new NullPointerException());

        log.debug("debug 信息");
        log.debug("debug 一个异常", new NullPointerException());

        log.info("info 信息");
        log.info("info 一个异常", new NullPointerException());

        log.warn("warn 信息");
        log.warn("warn 一个异常", new NullPointerException());

        log.error("error 信息");
        log.error("error 一个异常", new NullPointerException());

        log.fatal("fatal 信息");
        log.fatal("fatal 一个异常", new NullPointerException());

    }

}

 

package com.helloweenvsfei.logging;

import java.io.UnsupportedEncodingException;

import org.apache.log4j.Logger;

public class Log4jMySql {
    public static Logger log = Logger.getLogger(Log4jMySql.class);

    /**
     * @param args
     * @throws UnsupportedEncodingException 
     */
    public static void main(String[] args) throws UnsupportedEncodingException {
        // TODO Auto-generated method stub
        log.trace("trace 信息");
        log.trace("trace 一个异常", new NullPointerException());

        log.debug("debug 信息");
        log.debug("debug 一个异常", new NullPointerException());

        log.info("info 信息");
        log.info("info 一个异常", new NullPointerException());

        log.warn("warn 信息");
        log.warn("warn 一个异常", new NullPointerException());

        log.error("error 信息");
        log.error("error 一个异常", new NullPointerException());

        log.fatal("fatal 信息");
        log.fatal("fatal 一个异常", new NullPointerException());
    }

}