log4j 日志输出数据库

一：添加依赖jar

?

1 2 3 4 5 6 7 8 9 10 11

<dependency>     <groupId>log4j</groupId>     <artifactId>log4j</artifactId>     <version>1.2.17</version> </dependency>   <dependency>     <groupId>mysql</groupId>     <artifactId>mysql-connector-java</artifactId>     <version>6.0.6</version> </dependency>

 二：配置log4j

?

1 2 3 4 5 6 7 8

log4j.rootLogger = stdout,jdbc   log4j.appender.jdbc=org.apache.log4j.jdbc.JDBCAppender log4j.appender.jdbc.driver=com.mysql.jdbc.Driver log4j.appender.jdbc.URL=jdbc:mysql://127.0.0.1:3306/test?characterEncoding=utf8&useSSL=true&serverTimezone=UTC log4j.appender.jdbc.user=root log4j.appender.jdbc.password= log4j.appender.jdbc.sql=insert into log_info(level,category,thread,time,location,note) values('%p','%c','%t','%d{yyyy-MM-dd HH:mm:ss:SSS}','%l','%m')

 三：创建数据库表结构

@Test
    public void jdbcCreateTable() throws Exception {
        Connection connection=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test?characterEncoding=utf8&useSSL=true&serverTimezone=UTC", "root", "");
        
        Class.forName("com.mysql.cj.jdbc.Driver");
        
        connection.createStatement().execute("CREATE TABLE `log_info` ( "
                + "  `Id` int(11) NOT NULL AUTO_INCREMENT, "
                + "  `level` varchar(255) NOT NULL DEFAULT '' COMMENT '优先级', "
                + "  `category` varchar(255) NOT NULL DEFAULT '' COMMENT '类目', "
                + "  `thread` varchar(255) NOT NULL DEFAULT '' COMMENT '进程', "
                + "  `time` varchar(30) NOT NULL DEFAULT '' COMMENT '时间', "
                + "  `location` varchar(255) NOT NULL DEFAULT '' COMMENT '位置', "
                + "  `note` text COMMENT '日志信息', "
                + "  PRIMARY KEY (`Id`) "
                + ")");
    }

四：添加测试代码

/***
 * 
 * @author zhanchaohan
 *
 */
public class PrintTest {
    private static Logger logger = Logger.getLogger(PrintTest.class);

    public static void main(String[] args) throws Exception {
        PropertyConfigurator.configure(PrintTest.class.getResource("/log4j.properties"));
        
        logger.info("普通Info信息");
        logger.debug("调试debug信息");
        logger.error("报错error信息");
        logger.warn("警告warn信息");
        logger.fatal("严重错误fatal信息");
    }
}