log4j.xml数据库保存日志

叁歲伎倆 2022-06-08 23:45 164阅读 0赞

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.       
24.   
25.   
26.   
27.   
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.       
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****>**

#  #