1.数据库与表结构
1.1 日志表信息描述sysLog
字段名称 | 字段类型 | 字段描述 |
---|---|---|
id | VARCHAR2 | 主键 无意义uuid |
visitTime | timestamp | 访问时间 |
username | VARCHAR2 | 操作者用户名 |
ip | VARCHAR2 | 访问ip |
url | VARCHAR2 | 访问资源url |
executionTime | int | 执行时长 |
method | VARCHAR2 | 访问方法 |
2.sql语句
CREATE TABLE sysLog(
id VARCHAR2(32) default SYS_GUID() PRIMARY KEY,
visitTime timestamp,
username VARCHAR2(50),
ip VARCHAR2(30),
url VARCHAR2(50),
executionTime int,
method VARCHAR2(200)
)
3.实体类
public class SysLog {
private String id;
private Date visitTime;
private String visitTimeStr;
private String username;
private String ip;
private String url;
private Long executionTime;
private String method;
}
2. 基于AOP日志处理
2.1 创建切面类处理日志
@Component
@Aspect
public class LogAop {
@Autowired
private SysLogService sysLogService;
@Autowired
private HttpServletRequest request;
private Date visitTime; //开始访问时间
private Class visitClass; //访问的类
private Method method; //访问的方法
//前置通知 主要是获取开始时间,执行的类是哪一个,执行的是哪一个方法
@Before("execution(* cn.itcast.controller.*.*(..))")
public void doBefore(JoinPoint joinPoint) throws NoSuchMethodException {
visitTime = new Date(); //当前时间就是开始访问的时间
visitClass = joinPoint.getTarget().getClass(); //获取具体要访问的类
String methodName = joinPoint.getSignature().getName();//获取访问方法的名称
Object[] args = joinPoint.getArgs(); //获取访问方法参数的数组
if (args == null || args.length == 0) {
//如果方法空参,则执行
method = visitClass.getMethod(methodName); //只能获取无参数的方法
} else {
//如果方法有参,则执行else
Class[] classArgs = new Class[args.length];
for (int i = 0; i < args.length; i++) {
classArgs[i] = args[i].getClass();
}
method = visitClass.getMethod(methodName, classArgs);
}
}
/**
* 后置通知
* @param joinPoint
*/
@After("execution(* cn.itcast.controller.*.*(..))")
public void doAfter(JoinPoint joinPoint){
Long executionTime = new Date().getTime() - visitTime.getTime(); //获得访问时长
String url = "";
//获取访问资源的url
if (visitClass != null && method != null && visitClass != LogAop.class && visitClass != SysLogController.class){
//1.获取类上的@RequestMapping("/xxx")
RequestMapping classAnnotation = (RequestMapping) visitClass.getAnnotation(RequestMapping.class);
String[] classUrl = classAnnotation.value();
if (classAnnotation != null){
//2.获取方法上的@RequestMapping(/xxx)
RequestMapping methodAnnotation = method.getAnnotation(RequestMapping.class);
String[] methodUrl = methodAnnotation.value();
url = classUrl[0]+ methodUrl[0];
//获取ip
String ip = request.getRemoteAddr();
//获取操作用户名
SecurityContext securityContext = SecurityContextHolder.getContext();//从上下文中获取登录用户
User user = (User) securityContext.getAuthentication().getPrincipal();
String username = user.getUsername();
SysLog sysLog = new SysLog();
sysLog.setExecutionTime(executionTime);
sysLog.setIp(ip);
sysLog.setMethod("[类名:]"+ visitClass.getName() + " " + "[方法名:]" + method.getName());
sysLog.setUrl(url);
sysLog.setUsername(username);
sysLog.setVisitTime(visitTime);
sysLogService.save(sysLog);
}
}
}
}
在切面类中我们需要获取登录用户的username,还需要获取ip地址,我们怎么处理?
- username获取
SecurityContextHolder获取 - ip地址获取
ip地址的获取我们可以通过request.getRemoteAddr()方法获取到。
在Spring中可以通过RequestContextListener来获取request或session对象。