DROP TABLE IF EXISTS `tb_task`;
CREATE TABLE `tb_task`  (
  `task_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '定時(shí)任務(wù)id',
  `task_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '定時(shí)任務(wù)名稱',
  `task_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '定時(shí)任務(wù)描述',
  `task_exp` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '定時(shí)任務(wù)Cron表達(dá)式',
  `task_status` int(1) NULL DEFAULT NULL COMMENT '定時(shí)任務(wù)狀態(tài)，0停用 1啟用',
  `task_class` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '定時(shí)任務(wù)的Runnable任務(wù)類完整路徑',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新時(shí)間',
  `create_time` datetime NULL DEFAULT NULL COMMENT '創(chuàng)建時(shí)間',
  PRIMARY KEY (`task_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '動(dòng)態(tài)定時(shí)任務(wù)表' ROW_FORMAT = Compact;


INSERT INTO `tb_task` VALUES ('1', 'task1', '測(cè)試動(dòng)態(tài)定時(shí)任務(wù)1', '0/5 * * * * ?', 0, 'cn.huanzi.qch.springboottimer.task.MyRunnable1', '2021-08-06 17:39:23', '2021-08-06 17:39:25');
INSERT INTO `tb_task` VALUES ('2', 'task2', '測(cè)試動(dòng)態(tài)定時(shí)任務(wù)2', '0/5 * * * * ?', 0, 'cn.huanzi.qch.springboottimer.task.MyRunnable2', '2021-08-06 17:39:23', '2021-08-06 17:39:25');

<!--添加springdata-jpa依賴 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>

        <!--添加MySQL驅(qū)動(dòng)依賴 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

spring:
    datasource: #數(shù)據(jù)庫(kù)相關(guān)
      url: jdbc:mysql://localhost:3306/test?serverTimezone=GMT%2B8&characterEncoding=utf-8
      username: root
      password: 123456
      driver-class-name: com.mysql.jdbc.Driver
    mvc:
      date-format: yyyy-MM-dd HH:mm:ss #mvc接收參數(shù)時(shí)對(duì)日期進(jìn)行格式化

    jackson:
      date-format: yyyy-MM-dd HH:mm:ss #jackson對(duì)響應(yīng)回去的日期參數(shù)進(jìn)行格式化
      time-zone: GMT+8
    jpa:
      show-sql: true

/**
 * 動(dòng)態(tài)定時(shí)任務(wù)表
 * 重要屬性：唯一表id、Runnable任務(wù)類、Cron表達(dá)式，
 * 其他的都是一些額外補(bǔ)充說(shuō)明屬性
 */
@Entity
@Table(name = "tb_task")
@Data
public class TbTask {
    @Id
    private String taskId;//定時(shí)任務(wù)id
    private String taskName;//定時(shí)任務(wù)名稱
    private String taskDesc;//定時(shí)任務(wù)描述
    private String taskExp;//定時(shí)任務(wù)Cron表達(dá)式
    private Integer taskStatus;//定時(shí)任務(wù)狀態(tài)，0停用 1啟用
    private String taskClass;//定時(shí)任務(wù)的Runnable任務(wù)類完整路徑
    private Date updateTime;//更新時(shí)間
    private Date createTime;//創(chuàng)建時(shí)間
}

/**
 * TbTask動(dòng)態(tài)定時(shí)任務(wù)Repository
 */
@Repository
public interface TbTaskRepository extends JpaRepository<TbTask,String>, JpaSpecificationExecutor<TbTask> {
}

/**
 * 測(cè)試定時(shí)器2-動(dòng)態(tài)定時(shí)器
 */
@Slf4j
@Component
public class TestScheduler2 {

    //數(shù)據(jù)庫(kù)的任務(wù)
    public static ConcurrentHashMap<String, TbTask> tasks = new ConcurrentHashMap<>(10);

    //正在運(yùn)行的任務(wù)
    public static ConcurrentHashMap<String,ScheduledFuture> runTasks = new ConcurrentHashMap<>(10);

    //線程池任務(wù)調(diào)度
    private ThreadPoolTaskScheduler threadPoolTaskScheduler = new ThreadPoolTaskScheduler();

    @Autowired
    private TbTaskRepository tbTaskRepository;

    /**
     * 初始化線程池任務(wù)調(diào)度
     */
    @Autowired
    public TestScheduler2(){
        this.threadPoolTaskScheduler.setPoolSize(10);
        this.threadPoolTaskScheduler.setThreadNamePrefix("task-thread-");
        this.threadPoolTaskScheduler.setWaitForTasksToCompleteOnShutdown(true);
        this.threadPoolTaskScheduler.initialize();
    }

    /**
     * 獲取所有數(shù)據(jù)庫(kù)里的定時(shí)任務(wù)
     */
    private void getAllTbTask(){
        //查詢所有，并put到tasks
        TestScheduler2.tasks.clear();
        List<TbTask> list = tbTaskRepository.findAll();
        list.forEach((task)-> TestScheduler2.tasks.put(task.getTaskId(),task));
    }

    /**
     * 根據(jù)定時(shí)任務(wù)id，啟動(dòng)定時(shí)任務(wù)
     */
    void start(String taskId){
        try {
            //如果為空，重新獲取
            if(TestScheduler2.tasks.size() <= 0){
                this.getAllTbTask();
            }
            TbTask tbTask = TestScheduler2.tasks.get(taskId);

            //獲取并實(shí)例化Runnable任務(wù)類
            Class<?> clazz = Class.forName(tbTask.getTaskClass());
            Runnable runnable = (Runnable)clazz.newInstance();

            //Cron表達(dá)式
            CronTrigger cron = new CronTrigger(tbTask.getTaskExp());

            //執(zhí)行，并put到runTasks
            TestScheduler2.runTasks.put(taskId, Objects.requireNonNull(this.threadPoolTaskScheduler.schedule(runnable, cron)));

            this.updateTaskStatus(taskId,1);

            log.info("{}，任務(wù)啟動(dòng)！",taskId);
        } catch (ClassNotFoundException | InstantiationException | IllegalAccessException e) {
            log.error("{}，任務(wù)啟動(dòng)失敗...",taskId);
            e.printStackTrace();
        }

    }

    /**
     * 根據(jù)定時(shí)任務(wù)id，停止定時(shí)任務(wù)
     */
    void stop(String taskId){
        TestScheduler2.runTasks.get(taskId).cancel(true);

        TestScheduler2.runTasks.remove(taskId);

        this.updateTaskStatus(taskId,0);

        log.info("{}，任務(wù)停止...",taskId);
    }

    /**
     * 更新數(shù)據(jù)庫(kù)動(dòng)態(tài)定時(shí)任務(wù)狀態(tài)
     */
    private void updateTaskStatus(String taskId,int status){
        TbTask task = tbTaskRepository.getOne(taskId);
        task.setTaskStatus(status);
        task.setUpdateTime(new Date());
        tbTaskRepository.save(task);
    }
}

/**
 * Runnable任務(wù)類1
 */
@Slf4j
public class MyRunnable1 implements Runnable {
    @Override
    public void run() {
        log.info("MyRunnable1  {}",new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()));
    }
}

/**
 * 動(dòng)態(tài)定時(shí)任務(wù)Controller測(cè)試
 */
@RestController
@RequestMapping("/tbTask/")
public class TbTaskController {

    @Autowired
    private TestScheduler2 testScheduler2;

    @Autowired
    private TbTaskRepository tbTaskRepository;

    /**
     * 啟動(dòng)一個(gè)動(dòng)態(tài)定時(shí)任務(wù)
     * http://localhost:10085/tbTask/start/2
     */
    @RequestMapping("start/{taskId}")
    public String start(@PathVariable("taskId") String taskId){
        testScheduler2.start(taskId);
        return "操作成功";
    }

    /**
     * 停止一個(gè)動(dòng)態(tài)定時(shí)任務(wù)
     * http://localhost:10085/tbTask/stop/2
     */
    @RequestMapping("stop/{taskId}")
    public String stop(@PathVariable("taskId") String taskId){
        testScheduler2.stop(taskId);
        return "操作成功";
    }

    /**
     * 更新一個(gè)動(dòng)態(tài)定時(shí)任務(wù)
     * http://localhost:10085/tbTask/save?taskId=2&taskExp=0/2 * * * * ?&taskClass=cn.huanzi.qch.springboottimer.task.MyRunnable3
     */
    @RequestMapping("save")
    public String save(TbTask task) throws IllegalAccessException {
        //先更新表數(shù)據(jù)
        TbTask tbTask = tbTaskRepository.getOne(task.getTaskId());

        //null值忽略
        List<String> ignoreProperties = new ArrayList<>(7);

        //反射獲取Class的屬性（Field表示類中的成員變量）
        for (Field field : task.getClass().getDeclaredFields()) {
            //獲取授權(quán)
            field.setAccessible(true);
            //屬性名稱
            String fieldName = field.getName();
            //屬性的值
            Object fieldValue = field.get(task);

            //找出值為空的屬性，我們復(fù)制的時(shí)候不進(jìn)行賦值
            if(null == fieldValue){
                ignoreProperties.add(fieldName);
            }
        }

        //org.springframework.beans BeanUtils.copyProperties(A,B)：A中的值付給B
        BeanUtils.copyProperties(task, tbTask,ignoreProperties.toArray(new String[0]));
        tbTaskRepository.save(tbTask);
        TestScheduler2.tasks.clear();

        //停止舊任務(wù)
        testScheduler2.stop(tbTask.getTaskId());

        //重新啟動(dòng)
        testScheduler2.start(tbTask.getTaskId());
        return "操作成功";
    }
}