SELECT date_sub(now(), interval 1 huor); //就是當(dāng)前時(shí)間的前的一小時(shí)間
 //(date:時(shí)間 sub  減去  interval:間隔 hour :小時(shí))
 //這里我設(shè)置的一個(gè)小時(shí) 你們也可以設(shè)置長一點(diǎn)都可以
 SELECT SYSDATE(); //查詢系統(tǒng)當(dāng)前時(shí)間 (就是你電腦時(shí)間)

 @Override
    public void configureTasks(ScheduledTaskRegistrar taskRegistrar) {
        taskRegistrar.addTriggerTask(
                //1.添加任務(wù)內(nèi)容(Runnable)
                () -> System.out.println("執(zhí)行動(dòng)態(tài)定時(shí)任務(wù): " + LocalDateTime.now().toLocalTime()),
                //2.設(shè)置執(zhí)行周期(Trigger)
                triggerContext -> {
                    //2.1 從數(shù)據(jù)庫獲取執(zhí)行周期
                    String cron = aitravelCheckInfoService.selectCron();
                    System.out.println(cron);
                    String cs = "2023-03-14 01:30:00";//區(qū)間數(shù)據(jù)時(shí)間
                    System.out.println(cs);
                    String kaishi = aitravelCheckInfoService.kaishi();//當(dāng)前時(shí)間的前一個(gè)小時(shí)
                    System.out.println(kaishi);
                    String dangqian = aitravelCheckInfoService.dangqian();//當(dāng)前時(shí)間
                    System.out.println(dangqian);
                    String zong = aitravelCheckInfoService.zong();
                    System.out.println(zong);
                    int i = Integer.parseInt(zong);
                    if (i==0){
                        HttpServletResponse response = null;
                        this.sendCaptcha(response, "19176928269");
                    }else{
                        //String轉(zhuǎn)Date
                        try {
                            SimpleDateFormat ft = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
                            Date wcha =ft.parse(cs);//區(qū)間數(shù)據(jù)時(shí)間(String 轉(zhuǎn) Date)
                            System.out.println(wcha);
                            Date kaishi1 =ft.parse(kaishi);//當(dāng)前時(shí)間往前推一個(gè)小時(shí)(String 轉(zhuǎn) Date)
                            System.out.println(kaishi1);
                            Date dangqian1 =ft.parse(dangqian);//當(dāng)前時(shí)間(String 轉(zhuǎn) Date)
                            System.out.println(dangqian1);
                            Calendar dateC = Calendar.getInstance();
                            dateC.setTime(wcha);//區(qū)間數(shù)據(jù)時(shí)間
                            System.out.println(dateC);
                            Calendar begin = Calendar.getInstance();
                            begin.setTime(kaishi1);//開始時(shí)間
                            Calendar end = Calendar.getInstance();
                            end.setTime(dangqian1);//結(jié)束時(shí)間
                            if (dateC.after(begin) && dateC.before(end)) {
                                System.out.println("在區(qū)間里");
                            }else{
                                System.out.println("不在區(qū)間里");
                                HttpServletResponse response = null;
                                this.sendCaptcha(response, "19176928269");
                            }
                        } catch (ParseException e) {
                            e.printStackTrace();
                        }
                    }
                    //2.3 返回執(zhí)行周期(Date)
                    return new CronTrigger(cron).nextExecutionTime(triggerContext);
                }
        );
    }