1、建立log4j.xml 文件
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72<?xml version="1.0" encoding="UTF-8" ?>
2、com.test.sys.log.MyJDBCAppender 依赖类的实现
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83import java.sql.Connection;
import java.sql.SQLException;
import org.apache.log4j.jdbc.JDBCAppender;
import org.apache.log4j.spi.ErrorCode;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import com.alibaba.druid.pool.DruidDataSource;
/** *@Description MyJDBCAppender.java * 用于Log4j的数据库Session管理[连接池用Druid] *@version 1.0 */
public class MyJDBCAppender extends JDBCAppender {
/* Druid数据源 */
private static DruidDataSource dataSource;
public MyJDBCAppender() {
super();
}
static{
ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
dataSource= (DruidDataSource) context.getBean("dataSource");
// 这里博主是用的alibaba 的Druid 的连接池 ,原先使用的c3p0连接池，使用此种方式获取不到连接池，而且项目中，c3p0总是关闭连接错误，所以果断改为了Druid ，不失所望，Druid 很好用，效率很高，Druid连接池的配置会贴在此文最后
}
@Override
protected void closeConnection(Connection con) {
try {
/* 如果数据库连接对象不为空和没有被关闭的话，关闭数据库连接 */
if ( con != null && !con.isClosed())
con.close();
} catch (SQLException e) {
errorHandler.error("Error closing MyJDBCAppender.closeConnection() 's connection",e,ErrorCode.GENERIC_FAILURE);
}
}
@Override
protected Connection getConnection() throws SQLException {
return dataSource.getConnection();
}
/* 取消初始化 */
public void uninitialize() {
try {
if (dataSource != null)
dataSource.close();
} finally {
super.close();
}
}
}
3、com.test.sys.log.CustomWarnLevelFilter 依赖类的实现
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67import java.util.regex.Matcher;
import java.util.regex.Pattern;
import org.apache.log4j.spi.LoggingEvent;
import org.slf4j.MDC;
public class CustomWarnLevelFilter extends org.apache.log4j.spi.Filter{
@Override
public int decide(LoggingEvent event) {
//大于等于WARN的日志不允许输出
// if(event.getLevel().toInt() >= Level. WARN.toInt()) {
// return DENY;
// } else {
// return ACCEPT;
// }
event.getMDCCopy();
if(event.getMessage()!=null && isContainChinese(event.getMessage().toString()) && null !=event.getMDC("userid")){
if( isContainGt(event.getMessage().toString())){
String[] split = event.getMessage().toString().split(">");
MDC.put("operate", split[0]+"");
MDC.put("content", event.getMessage().toString()+"");
return ACCEPT;
}else if( event.getMessage().toString().indexOf("登录")>-1 || event.getMessage().toString().indexOf("退出")>-1
|| event.getMessage().toString().indexOf("列表")>-1 || event.getMessage().toString().indexOf("主页")>-1 || event.getMessage().toString().indexOf("导入")>-1){
MDC.put("operate", event.getMessage().toString());
MDC.put("content", event.getMessage().toString());
return ACCEPT;
}else{
return DENY;
}
}else{
return DENY;
}
}
public static boolean isContainChinese(String str) {
Pattern p = Pattern.compile("[\u4e00-\u9fa5]");
Matcher m = p.matcher(str);
if (m.find()) {
return true;
}
return false;
}
public static boolean isContainGt(String str) {
Pattern p = Pattern.compile("(.*)(?:>)");
Matcher m = p.matcher(str);
if (m.find()) {
return true;
}
return false;
}
}
4、在登陆的拦截器 中要将 userId 和 企业id 放入MDC 中去，然后在log4j.xml 中 用 %X{userid} 方式可取出其值
import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse;
import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.slf4j.MDC; import org.springframework.web.method.HandlerMethod; import org.springframework.web.servlet.handler.HandlerInterceptorAdapter;
public class LoginInterceptor extends HandlerInterceptorAdapter{ private static final Logger LOG = LoggerFactory.getLogger(LoginInterceptor.class);
@Override
public boolean preHandle(HttpServletRequest request,
HttpServletResponse response, Object handler) throws Exception {
HandlerMethod handlerMethod = (HandlerMethod) handler;
if ("GET".equalsIgnoreCase(request.getMethod())) {
}
String requestUri = request.getRequestURI();
LOG.info("requestUri:"+requestUri);
String requestURI = request.getRequestURI();
if(null != request.getSession(false)){
UserInfo user = (UserInfo) request.getSession(false).getAttribute("UserInfo");
if(null == user){
LOG.info("未登录，请先登录");
request.getSession(false).setAttribute("msg", "用户未登录，请先登录");
request.getRequestDispatcher("/pages/login.jsp").forward(request, response);
return false;
}else{
MDC.put("userid", user.getUserId()+"");
MDC.put("username", user.getUserName()+"");
MDC.put("ip", request.getRemoteAddr()+"");
Enterprise enter = (Enterprise) request.getSession(false).getAttribute("Enterprise");
if(null !=user.getOrganizationId()){
MDC.put("organization", enter.getEnterprise()+"");
}else{
MDC.put("organization","");
}
}
}else{
LOG.info("未登录，请先登录");
request.getRequestDispatcher("/pages/login.jsp").forward(request, response);
return false;
}
return true;
}
}
5、applicationContext.xml 中的Druid 连接池的配置
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
6、在web.xml 中加入Druid 的监控，启动应用，访问http://localhost/应用名/monitor/ 就可以看到Druid 的监控页面了
DruidStatView
com.alibaba.druid.support.http.StatViewServlet
DruidStatView
/monitor/*
扫一扫
1753
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
