Write logs to the database with log4j

The following are the configuration parameters in log4j:

%M the message specified in the output code

%p output priority, i.e. Debug,info,warn,error,fatal

%r output the number of milliseconds that the log information is consumed from the application boot to output

%t output The name of the thread that generated the log event;

%n output a carriage return newline character, Windows platform is "\ r \ n", Unix platform is "\ n"

%d the date or time of the output log time, the default format is ISO8601, or the format can be specified later,
For example:%d{yyy MMM dd hh:mm:ss,sss}, output similar: October 18, 2008 22:10:28:832

%c output belongs to the class, which is usually the full name of the class, such as "Inotes.default";

%l where the output log event occurs, including the class name, the thread that occurred, and the number of rows in the code

%l the number of lines in the output code;

%F the file name in the output code;

pay attention to case

In Java Engineering, the log file (log4j.properties) is placed in the SRC directory, in the Web project, the log file (log4j.properties) is also placed in the SRC root directory.


The code in the action is as follows:

Java code

2. Public class Loginuseraction extends Action {
4. private Userdao Userdao;
6. private static Logger log = Logger.getlogger (loginuseraction.   Class);
8. /** 
10. * Get the Userdao object
12. * @param Userdao
14. */
16. public void Setuserdao (Userdao userdao) {
18. This.userdao = Userdao;
20. }
22. Public Actionforward Execute (actionmapping mapping, actionform form,
24. HttpServletRequest request, HttpServletResponse HttpServletResponse)
26. throws Exception {
28. //sets the character set of the request
30. Request.setcharacterencoding ("Utf-8");
36. Loginuserform loginform = (loginuserform) Form;
40. Log.warn ("User:" +loginform.getusername () +"Login" +"+" IP: "+request.getremoteaddr ());
42. //Call method to get a loginuserform
44. LoginForm = (loginuserform) userdao.getaccount (loginform);
46. return Mapping.findforward ("Success");
48. }
52. }

private static Logger log = Logger.getlogger (Loginuseraction.class);
Log.warn ("User:" +loginform.getusername () + "login" + "+" IP: "+request.getremoteaddr ());

Note the red Word, these two lines are mainly associated with the log, the first red line is to establish a log object, the second red line is to write to the database log.

Code in Log4j.properties:

Java code

1. Log4j.rootlogger=warn,database
3. #直接使用log4j包中的文件
4. Log4j.appender.database=org.apache.log4j.jdbc.jdbcappender
5. #与数据库建立连接
6. Log4j.appender.database.url=jdbc:mysql://localhost:3306/test
7. Log4j.appender.database.driver=com.mysql.jdbc.driver
8. Log4j.appender.database.user=root
9. Log4j.appender.database.password=icy
10. #指定要插入数据库的格式, the format of the specific parameters to look at the beginning of the document
11. Log4j.appender.database.sql=insert to Log4j (Log_date, Log_level, location, message) VALUES ('%d{iso8601} ', ' %p ', '%c,%l ', '%m ')

This makes it possible to write logs to the database.

Original: http://blog.csdn.net/zhengbo0/article/details/38731617

Write logs to the database with log4j