<dependency>
    <groupId>org.aspectj</groupId>
    <artifactId>aspectjweaver</artifactId>
    <version>1.9.4</version>
</dependency>
 

/**
 * 數(shù)據(jù)庫操作類型
 */
public enum OperationType {
 
    /**
     * 更新操作
     */
    UPDATE,
 
    /**
     * 插入操作
     */
    INSERT
 
}

@Target(ElementType.METHOD)
@Retention(RetentionPolicy.RUNTIME)
public @interface AutoFill {
    // 數(shù)據(jù)庫操作類型：UPDATE INSERT
    OperationType value();
}

    /**
     * 新增員工
     * @param employee
     */
    @Insert("INSERT INTO employee" +
            "(name, username, password, phone, sex, id_number, create_time, update_time, create_user, update_user)" +
            "VALUES" +
            "(#{name}, #{username}, #{password}, #{phone}, #{sex}, #{idNumber}, #{createTime}, #{updateTime}, #{createUser}, #{updateUser})")
    @AutoFill(value = OperationType.INSERT)
    void insert(Employee employee);
 
    /**
     * 修改員工信息
     * @param employee
     */
    @AutoFill(value = OperationType.UPDATE)
    void update(Employee employee);
 
    /**
     * 根據(jù)ID查詢員工
     * @param id
     * @return
     */
    @Select("SELECT * FROM employee WHERE id = #{id}")
    Employee getById(Long id);
 
    /**
     * 密碼修改
     * @param passwordEditDTO
     */
    @AutoFill(value = OperationType.UPDATE)
    @Update("UPDATE employee SET `password` = #{newPassword} WHERE `id` = #{empId} AND `password` = #{oldPassword}")
    void updatePwd(PasswordEditDTO passwordEditDTO);

@Slf4j
@Component
@Aspect
public class AutoFillAspect {
 
    /**
     * 切面 && 指定切入點(diǎn)
     */
    @Pointcut("execution(* com.sky.mapper.*.*(..)) && @annotation(com.sky.annotation.AutoFill)")
    public void autoFillPointCut(){}
 
    /**
     * 切面 && 此方法(autoFill()) 在切入點(diǎn)之前執(zhí)行
     * @param joinPoint
     */
    @Before("autoFillPointCut()")
    public void autoFill(JoinPoint joinPoint) {
        log.info("開始進(jìn)行公共字段自動(dòng)填充...");
 
        // 拿到當(dāng)前被攔截的方法上的數(shù)據(jù)庫操作類型
        MethodSignature signature = (MethodSignature)joinPoint.getSignature();// 拿到實(shí)現(xiàn)類的簽名信息，不過我們只需要方法的簽名信息，強(qiáng)轉(zhuǎn)成MethodSignature
        AutoFill autoFill = signature.getMethod().getAnnotation(AutoFill.class);// 獲得簽名對(duì)象的注解對(duì)象
        OperationType operationType = autoFill.value(); // 拿到數(shù)據(jù)庫操作類型
 
        // 拿到當(dāng)前被攔截方法的方法參數(shù)（新增、更改方法的參數(shù)一般都是實(shí)體類）
        Object[] args = joinPoint.getArgs();
        if (args == null || args.length == 0){ // 防止null，防止空參
            return;
        }
 
        Object entity = args[0]; // 這一行就要求，以后的新增、更改方法參數(shù)，實(shí)體類必須寫在首形參位置
 
        // 需填充的數(shù)據(jù)
        LocalDateTime now = LocalDateTime.now();
        Long currentId = BaseContext.getCurrentId();
 
        // 根據(jù)當(dāng)前不同的操作類型，使用反射為對(duì)應(yīng)的屬性賦值
        if (operationType == OperationType.INSERT) {
            // 為4個(gè)公共字段賦值
            try {
                Method setCreateTime = entity.getClass().getDeclaredMethod(AutoFillConstant.SET_CREATE_TIME, LocalDateTime.class);
                Method setUpdateTime = entity.getClass().getDeclaredMethod(AutoFillConstant.SET_UPDATE_TIME, LocalDateTime.class);
                Method setCreateUser = entity.getClass().getDeclaredMethod(AutoFillConstant.SET_CREATE_USER, Long.class);
                Method setUpdateUser = entity.getClass().getDeclaredMethod(AutoFillConstant.SET_UPDATE_USER, Long.class);
 
                // 通過反射給對(duì)象屬性賦值
                setCreateTime.invoke(entity, now);
                setUpdateTime.invoke(entity, now);
                setCreateUser.invoke(entity, currentId);
                setUpdateUser.invoke(entity, currentId);
 
            } catch (Exception e) {
                e.printStackTrace();
            }
        } else if (operationType == OperationType.UPDATE) {
            // 為2個(gè)公共字段賦值
            try {
                Method setUpdateTime = entity.getClass().getDeclaredMethod(AutoFillConstant.SET_UPDATE_TIME, LocalDateTime.class);
                Method setUpdateUser = entity.getClass().getDeclaredMethod(AutoFillConstant.SET_UPDATE_USER, Long.class);
 
                // 通過反射給對(duì)象屬性賦值
                setUpdateTime.invoke(entity, now);
                setUpdateUser.invoke(entity, currentId);
            } catch (Exception e) {
                e.printStackTrace();
            }
 
        }
    }
}

/**
 * 公共字段自動(dòng)填充相關(guān)常量
 */
public class AutoFillConstant {
    /**
     * 實(shí)體類中的方法名稱
     */
    public static final String SET_CREATE_TIME = "setCreateTime";
    public static final String SET_UPDATE_TIME = "setUpdateTime";
    public static final String SET_CREATE_USER = "setCreateUser";
    public static final String SET_UPDATE_USER = "setUpdateUser";
}

public class BaseContext {
 
    public static ThreadLocal<Long> threadLocal = new ThreadLocal<>();
 
    public static void setCurrentId(Long id) {
        threadLocal.set(id);
    }
 
    public static Long getCurrentId() {
        return threadLocal.get();
    }
 
    public static void removeCurrentId() {
        threadLocal.remove();
    }
 
}

@SpringBootApplication
@EnableTransactionManagement //開啟注解方式的事務(wù)管理
@EnableAspectJAutoProxy // 開啟注解方式的AOP
@Slf4j
public class SkyApplication {
    public static void main(String[] args) {
        SpringApplication.run(SkyApplication.class, args);
        log.info("server started");
    }
}