log4j.xml数据库保存日志

来源：互联网发布：交换机镜像端口配置编辑：程序博客网时间：2024/05/16 06:30

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">
<appender name="CONSOLE" class="org.apache.log4j.ConsoleAppender">
<layout class="org.apache.log4j.PatternLayout">
<param name="ConversionPattern" value="%d{ABSOLUTE} %3p %c{1}.%M():%L - %m%n" />
</layout>
</appender>
<appender name="db" class="org.apache.log4j.jdbc.JDBCAppender">
<param name="driver" value="com.mysql.jdbc.Driver" />
<param name="URL"
value="jdbc:mysql://10.x.x.x:3306/security_db?useUnicode=true&characterEncoding=utf-8" />
<param name="user" value="root" />
<param name="password" value="xxx" />
<layout class="org.apache.log4j.PatternLayout">
<param name="ConversionPattern" value="insert into bbs_log(log_name, user_name, oper_class, oper_method, create_time, log_level, msg, source, user_type) values ('%X{userid}','%X{username}','%C','%M','%d{yyyy-MM-dd HH:mm:ss}','%p','%m', '%X{source}', '%X{usertype}')" />
</layout>
</appender>
<logger name="net.dontdrinkandroot.example.angularrestspringsecurity.rest.resources" additivity="false">
<level value="DEBUG" />
<appender-ref ref="db" />
</logger>
<logger name="java.sql.Statement" additivity="true">
<level value="DEBUG" />
</logger>
<logger name="org.springframework" additivity="true">
<level value="OFF" />
</logger>
<logger name="org.apache.ibatis" additivity="true">
<level value="OFF" />
</logger>
<logger name="org.mybatis.spring" additivity="true">
<level value="OFF" />
</logger>
<logger name="java.sql.PreparedStatement" additivity="true">
<level value="DEBUG" />
</logger>
<logger name="java.sql.ResultSet" additivity="true">
<level value="DEBUG" />
</logger>
<root>
<level value="DEBUG" />
<appender-ref ref="CONSOLE" />
</root>
</log4j:configuration>

阅读全文

0 0