log4j.xml数据库保存日志

1. <?xml version="1.0" encoding="UTF-8"?>   
2. <!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">  
3. <log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">  
4.       
5.     <appender name="CONSOLE" class="org.apache.log4j.ConsoleAppender">  
6.         <layout class="org.apache.log4j.PatternLayout">  
7.             <param name="ConversionPattern" value="%d{ABSOLUTE} %3p %c{1}.%M():%L - %m%n" />  
8.         </layout>  
9.     </appender>  
10.   
11.         <!-- 打印数据库数据 -->  
12.     <appender name="db" class="org.apache.log4j.jdbc.JDBCAppender">  
13.     <param name="driver" value="com.mysql.jdbc.Driver" />  
14.     <param name="URL"  
15.         value="jdbc:mysql://10.x.x.x:3306/security_db?useUnicode=true&characterEncoding=utf-8" />  
16.     <param name="user" value="root" />  
17.     <param name="password" value="xxx" />  
18.     <layout class="org.apache.log4j.PatternLayout">  
19.         <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}')" />   
20.     </layout>  
21. </appender>  
22.   
23.     <!--- 异步测试，当日志达到缓存区大小时候执行所包的appender -->  
24. <!--     <appender name="ASYNC" class="org.apache.log4j.AsyncAppender"> -->  
25. <!--         <param name="BufferSize" value="2" /> -->  
26. <!--         <appender-ref ref="db" /> -->  
27. <!--     </appender> -->  
28.       
29.     <logger name="net.dontdrinkandroot.example.angularrestspringsecurity.rest.resources" additivity="false">  
30.         <level value="DEBUG" />   
31.         <appender-ref ref="db" />  
32.     </logger>  
33.       
34.     <!-- 下面是打印 mybatis语句的配置 -->  
35.     <logger name="java.sql.Statement" additivity="true">  
36.         <level value="DEBUG" />  
37.     </logger>  
38.       
39.     <logger name="org.springframework" additivity="true">  
40.         <level value="OFF" />  
41.     </logger>  
42.     <logger name="org.apache.ibatis" additivity="true">  
43.         <level value="OFF" />  
44.     </logger>  
45.     <logger name="org.mybatis.spring" additivity="true">  
46.         <level value="OFF" />  
47.     </logger>  
48.       
49.     <logger name="java.sql.PreparedStatement" additivity="true">  
50.         <level value="DEBUG" />  
51.     </logger>  
52.   
53.     <logger name="java.sql.ResultSet" additivity="true">  
54.         <level value="DEBUG" />  
55.     </logger>  
56.   
57.     <root>  
58.         <level value="DEBUG" />  
59.         <appender-ref ref="CONSOLE" />  
60.     </root>  
61. </log4j:configuration>