package com.finance.web.controller.interceptor;
|
|
import com.finance.framework.web.service.TokenService;
|
import java.lang.reflect.Field;
|
import java.util.ArrayList;
|
import java.util.Arrays;
|
import java.util.Date;
|
import java.util.List;
|
import java.util.Objects;
|
import java.util.Properties;
|
import lombok.extern.slf4j.Slf4j;
|
import org.apache.ibatis.executor.Executor;
|
import org.apache.ibatis.mapping.MappedStatement;
|
import org.apache.ibatis.mapping.SqlCommandType;
|
import org.apache.ibatis.plugin.Interceptor;
|
import org.apache.ibatis.plugin.Intercepts;
|
import org.apache.ibatis.plugin.Invocation;
|
import org.apache.ibatis.plugin.Plugin;
|
import org.apache.ibatis.plugin.Signature;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Component;
|
|
@Slf4j
|
@Component
|
@Intercepts({@Signature(type = Executor.class, method = "update" , args = {MappedStatement.class,
|
Object.class})})
|
public class MybatisInterceptor implements Interceptor {
|
|
@Autowired
|
private TokenService tokenService;
|
|
@Override
|
public Object intercept(Invocation invocation) throws Throwable {
|
MappedStatement mappedStatement = (MappedStatement) invocation.getArgs()[0];
|
log.debug("{}:" + mappedStatement);
|
log.debug("------sqlId------" + mappedStatement.getId());
|
if ("com.finance.system.mapper.SysLogininforMapper.insertLogininfor".equals(
|
mappedStatement.getId())) {
|
return invocation.proceed();
|
}
|
// sql类型：insert、update、select、delete
|
SqlCommandType sqlCommandType = mappedStatement.getSqlCommandType();
|
Object parameter = invocation.getArgs()[1];
|
log.debug("------sqlCommandType------" + sqlCommandType);
|
|
if (parameter == null) {
|
return invocation.proceed();
|
}
|
|
// 当sql为新增或更新类型时，自动填充操作人相关信息
|
if (SqlCommandType.INSERT == sqlCommandType) {
|
|
Field[] fields = getAllFields(parameter);
|
for (Field field : fields) {
|
try {
|
// 注入创建人
|
if ("createBy".equals(field.getName())) {
|
// 获取当前登录用户信息
|
if (Objects.nonNull(tokenService.getLoginUser())) {
|
String userName = tokenService.getLoginUser().getUser().getUserName();
|
field.setAccessible(true);
|
field.set(parameter, userName);
|
field.setAccessible(false);
|
}
|
}
|
//注入创建时间
|
if ("createTime".equals(field.getName())) {
|
field.setAccessible(true);
|
field.set(parameter, new Date());
|
field.setAccessible(false);
|
}
|
} catch (Exception e) {
|
log.error("failed to insert data, exception = " , e);
|
}
|
}
|
}
|
if (SqlCommandType.UPDATE == sqlCommandType) {
|
Field[] fields = getAllFields(parameter);
|
for (Field field : fields) {
|
try {
|
if ("updateBy".equals(field.getName())) {
|
// 获取当前登录用户信息
|
if (Objects.nonNull(tokenService.getLoginUser())) {
|
String userName = tokenService.getLoginUser().getUser().getUserName();
|
field.setAccessible(true);
|
field.set(parameter, userName);
|
field.setAccessible(false);
|
}
|
}
|
if ("updateTime".equals(field.getName())) {
|
field.setAccessible(true);
|
field.set(parameter, new Date());
|
field.setAccessible(false);
|
}
|
} catch (Exception e) {
|
log.error("failed to update data, exception = " , e);
|
}
|
}
|
}
|
return invocation.proceed();
|
}
|
|
@Override
|
public Object plugin(Object target) {
|
return Plugin.wrap(target, this);
|
}
|
|
@Override
|
public void setProperties(Properties properties) {
|
// TODO Auto-generated method stub
|
}
|
|
/**
|
* 获取类的所有属性，包括父类
|
*
|
* @param object
|
* @return
|
*/
|
private Field[] getAllFields(Object object) {
|
Class<?> clazz = object.getClass();
|
List<Field> fieldList = new ArrayList<>();
|
while (clazz != null) {
|
fieldList.addAll(new ArrayList<>(Arrays.asList(clazz.getDeclaredFields())));
|
clazz = clazz.getSuperclass();
|
}
|
Field[] fields = new Field[fieldList.size()];
|
fieldList.toArray(fields);
|
return fields;
|
}
|
|
}
|
