新增时:自动填充创建人、创建时间
修改时:自动填充修改人、修改时间
MybatisInterceptor
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.*;
import org.springframework.stereotype.Component;
import java.lang.reflect.Field;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Date;
import java.util.List;
/**
* @author an
*/
@Slf4j
@Component
@Intercepts({ @Signature(type = Executor.class, method = "update", args = { MappedStatement.class, Object.class }) })
public class MybatisInterceptor implements Interceptor {
@Override
public Object intercept(Invocation invocation) throws Throwable {
MappedStatement mappedStatement = (MappedStatement) invocation.getArgs()[0];
// 获取sql执行类型:insert、update、select、delete
SqlCommandType sqlCommandType = mappedStatement.getSqlCommandType();
Object parameter = invocation.getArgs()[1];
if (parameter == null) {
return invocation.proceed();
}
// 当sql为新增或更新类型时,自动填充操作人相关信息
if (SqlCommandType.INSERT == sqlCommandType) {
Field[] fields = getAllFields(parameter);
for (Field field : fields) {
try {
// 注入创建人 - 可以改成从ThreadLocal获取 (UserInfoHolder.getUserCode();)
if ("createUser".equals(field.getName())) {
field.setAccessible(true);
field.set(parameter, "admin");
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);
}
}
} else if (SqlCommandType.UPDATE == sqlCommandType) {
Field[] fields = getAllFields(parameter);
for (Field field : fields) {
try {
// 注入修改人 - 可以改成从ThreadLocal获取 (UserInfoHolder.getUserCode();)
if ("modifyUser".equals(field.getName())) {
field.setAccessible(true);
field.set(parameter, "admin");
field.setAccessible(false);
}
if ("modifyTime".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);
}
/**
* 获取类的所有属性,包括父类
*/
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;
}
}
MybatisConfiguration
import org.apache.ibatis.session.SqlSessionFactory;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
/**
* @author an
*/
@Configuration
public class MybatisConfiguration {
@Bean
public Boolean setAutoFillValueInterceptor(SqlSessionFactory sqlSessionFactory) {
org.apache.ibatis.session.Configuration configuration = sqlSessionFactory.getConfiguration();
configuration.addInterceptor(new MybatisInterceptor());
return Boolean.TRUE;
}
}