mysql分表spring拦截器进行日志采集

最新推荐文章于 2024-07-05 17:52:41 发布

2401_84815240

最新推荐文章于 2024-07-05 17:52:41 发布

阅读量247

点赞数 4

分类专栏：程序员文章标签： mysql spring 数据库

本文链接：https://blog.csdn.net/2401_84815240/article/details/138965953

版权

程序员专栏收录该内容

113 篇文章 0 订阅

订阅专栏

public Date getCreate_time() {

return create_time;

}

public void setCreate_time(Date create_time) {

this.create_time = create_time;

}

public Date getState_time() {

return state_time;

}

public void setState_time(Date state_time) {

this.state_time = state_time;

}

public Date getEnd_time() {

return end_time;

}

public void setEnd_time(Date end_time) {

this.end_time = end_time;

}

拦截器采集日志

id是用redis生成的小伙伴可以用别的

新增语句这里就不贴出来了

以下操作查询的放一个表

其他放一张表

package com.web.common.intercept;

import cn.hutool.core.date.DateUtil;

import com.alibaba.fastjson.JSON;

import com.alibaba.fastjson.serializer.SerializerFeature;

import com.web.common.controller.BaseController;

import com.web.entity.TbLogging;

import com.web.entity.TbLoggingSelect;

import nl.bitwalker.useragentutils.UserAgent;

import org.apache.commons.beanutils.BeanUtils;

import org.apache.commons.lang3.StringUtils;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.web.method.HandlerMethod;

import org.springframework.web.servlet.ModelAndView;

import org.springframework.web.servlet.handler.HandlerInterceptorAdapter;

import redis.clients.jedis.Jedis;

import web.dao.hsdao.TbLoggingMapper;

import web.dao.hsdao.TbLoggingSelectMapper;

import web.util.JedisUtil;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import java.util.Date;

/**

@ClassName SginAop
@Description
@Author heng
@Date 2020/4/26 10:41
@Version 1.0

public class LogInterceptor extends HandlerInterceptorAdapter {

private final String redisKey = “LOG:LOGGING_KEY”;

private final static Logger LOGGER = LoggerFactory.getLogger(LogInterceptor.class);

//请求开始时间标识

private static final String LOGGER_SEND_TIME = “_send_time”;

//请求日志实体标识

private static final String LOGGER_ENTITY = “_logger_entity”;

@Autowired

private TbLoggingSelectMapper tbLoggingSelectMapper;

@Autowired

private TbLoggingMapper tbLoggingMapper;

public Long incr(String key) {

Jedis jedis =JedisUtil.getJedis();

try {

return jedis.incr(key);

} finally {

if (null != jedis) {

jedis.close();

}

@Override

public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws Exception {

if (handler.getClass().isAssignableFrom(HandlerMethod.class)) {

try {

TbLogging tbLogging = new TbLogging();

Long start_long_time = System.currentTimeMillis();

tbLogging.setState_time(DateUtil.date(start_long_time));

//获取ip

tbLogging.setIp(getRemoteHost(request));

//获取控制器的名字

tbLogging.setClass_name(((HandlerMethod) handler).getBean().getClass().getName());

//获取方法名

tbLogging.setMethod_name(((HandlerMethod) handler).getMethod().getName());

//获取请求参数信息

String param = JSON.toJSONString(request.getParameterMap(),

SerializerFeature.DisableCircularReferenceDetect,

SerializerFeature.WriteMapNullValue);

tbLogging.setParam(param);

try {

tbLogging.setCreate_user_id(new BaseController().obtainLoginUserId(request));

}catch (Exception ex){

LOGGER.info(“拿到当前登录人失败”);

}

//请求方法

tbLogging.setMethod(request.getMethod());

//请求url到后端的url

tbLogging.setUrl(request.getRequestURI());

//浏览器

//获取浏览器信息

String ua = request.getHeader(“User-Agent”);

//转成UserAgent对象

UserAgent userAgent = UserAgent.parseUserAgentString(ua);

tbLogging.setBrowser(userAgent.toString());

//获取返回值

//tbLogging.setReturn_value(response.getWriter().toString());

//设置请求开始时间

request.setAttribute(LOGGER_SEND_TIME, start_long_time);

//设置请求实体到request内，方便afterCompletion方法调用

request.setAttribute(LOGGER_ENTITY, tbLogging);

} catch (Exception e) {

LOGGER.info(“日志添加失败”);

}

return true;

}

@Override

public void postHandle(HttpServletRequest request, HttpServletResponse response, Object handler, ModelAndView modelAndView) throws Exception {

}

@Override

public void afterCompletion(HttpServletRequest request, HttpServletResponse response, Object handler, Exception ex) throws Exception {

try {

String uri = request.getRequestURI();

String contextPath = request.getContextPath();

if (StringUtils.length(contextPath) > 0) {

contextPath = StringUtils.substring(uri, contextPath.length());

}

TbLogging tbLogging = (TbLogging) request.getAttribute(LOGGER_ENTITY);

//获取请求错误码

int status = response.getStatus();

//当前时间

long currentTime = System.currentTimeMillis();

//请求开始时间

long time = Long.valueOf(request.getAttribute(LOGGER_SEND_TIME).toString());

//获取本次请求日志实体

tbLogging.setState(status+“”);

//设置请求时间差

tbLogging.setLong_time((currentTime - time)+“”);

tbLogging.setEnd_time(DateUtil.date(currentTime));

tbLogging.setCreate_time(DateUtil.date(currentTime));

// Long longId = IdUtil.createSnowflake(1, 1).nextId();

Long longId = incr(redisKey);

tbLogging.setId(longId.intValue());

if(tbLogging.getClass_name().indexOf(“TbLoggingController”) == -1){

if (contextPath.indexOf(“search_”) == -1

&& !tbLogging.getMethod_name().startsWith(“search”)

&& !tbLogging.getMethod_name().startsWith(“get”)

&& !tbLogging.getMethod_name().startsWith(“query”)

&& !tbLogging.getMethod_name().startsWith(“find”)

&& !tbLogging.getMethod_name().startsWith(“select”)

&& !tbLogging.getMethod_name().equals(“index”)) {

//执行将日志写入数据库，可以根据实际需求进行保存

// sysLogRepo.save(sysLog);

tbLoggingMapper.insertTbLogging(tbLogging);

}else {

TbLoggingSelect select = new TbLoggingSelect();

//把tbLogging的值给select

BeanUtils.copyProperties(select,tbLogging);

tbLoggingSelectMapper.insertTbLoggingSelect(select);

}

}catch (Exception e){

LOGGER.info(“日志添加失败”);

}

public int difference(Date nowDate, String decrypted){

return Math.abs((int)(nowDate.getTime()-Long.valueOf(decrypted))/1000);

}

/**

@Title: getRemoteHost
@Description: 获取Ip地址
@return: String
@version V1.0

public String getRemoteHost(HttpServletRequest request) {

String ip = request.getHeader(“x-forwarded-for”);