<dependencies>

        <dependency>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-starter</artifactId>

        </dependency>

        <dependency>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-starter-test</artifactId>

            <scope>test</scope>

        </dependency>

        <dependency>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-starter-web</artifactId>

        </dependency>

        <dependency>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-starter-quartz</artifactId>

        </dependency>

        <dependency>

            <groupId>mysql</groupId>

            <artifactId>mysql-connector-java</artifactId>

            <scope>runtime</scope>

        </dependency>

        <dependency>

            <groupId>org.mybatis.spring.boot</groupId>

            <artifactId>mybatis-spring-boot-starter</artifactId>

            <version>1.3.1</version>

        </dependency>

        <dependency>

            <groupId>com.mchange</groupId>

            <artifactId>c3p0</artifactId>

            <version>0.9.5.2</version>

        </dependency>

        <!--&lt;!&ndash; druid数据库连接池 &ndash;&gt;-->

        <dependency>

            <groupId>com.alibaba</groupId>

            <artifactId>druid-spring-boot-starter</artifactId>

            <version>1.1.10</version>

        </dependency>

    </dependencies>

spring:

  datasource:

    url: jdbc:mysql://localhost:3306/aipyun?serverTimezone=GMT&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true

    username: root

    password: root123

    driver-class-name: com.mysql.jdbc.Driver

    type: com.alibaba.druid.pool.DruidDataSource

    druid:

      initialSize: 2

      minIdle: 2

      maxActive: 30

      #StatViewServlet:

      #loginUsername: admin

      #loginPassword: admin

  quartz:

    #相关属性配置

    properties:

      org:

        quartz:

          scheduler:

            instanceName: DefaultQuartzScheduler

            instanceId: AUTO

          jobStore:

            class: org.quartz.impl.jdbcjobstore.JobStoreTX

            driverDelegateClass: org.quartz.impl.jdbcjobstore.StdJDBCDelegate

            tablePrefix: QRTZ_

            isClustered: false

            clusterCheckinInterval: 10000

            useProperties: true

          threadPool:

            class: org.quartz.simpl.SimpleThreadPool

            threadCount: 10

            threadPriority: 5

            threadsInheritContextClassLoaderOfInitializingThread: true

          dataSource:

            default:

              URL: jdbc:mysql://localhost:3306/aipyun?characterEncoding=utf-8

              user: root

              password: root123

              driver: com.mysql.jdbc.Driver

    #数据库方式

    job-store-type: jdbc

      #初始化表结构

    #jdbc:

    #initialize-schema: never

    /**

     * 删除job

     *

     * @param triggerName  触发器名称

     * @param triggerGroup 触发器分组

     * @param jobName      任务名称

     * @param jobGroup     任务分组

     * @throws SchedulerException

     */

    public void deleteJob(String triggerName, String triggerGroup, String jobName, String jobGroup) throws SchedulerException {

        TriggerKey triggerKey = TriggerKey.triggerKey(triggerName, triggerGroup);

        scheduler.pauseTrigger(triggerKey);

        scheduler.unscheduleJob(triggerKey);

        JobKey jobKey = JobKey.jobKey(jobName, jobGroup);

        scheduler.deleteJob(jobKey);

    }

    /**

     * 修改定时任务

     *

     * @param oldTriggerKey 需要修改的TriggerKey 也就是唯一标识

     * @param cron          新的cron表达式

     */

    public void updateJob(TriggerKey oldTriggerKey, String cron) {

        CronScheduleBuilder scheduleBuilder = CronScheduleBuilder.cronSchedule(cron);

        CronTrigger cronTrigger = TriggerBuilder.newTrigger()

                .withIdentity(oldTriggerKey).withSchedule(scheduleBuilder).build();

        try {

            scheduler.rescheduleJob(oldTriggerKey, cronTrigger);

        } catch (SchedulerException e) {

            e.printStackTrace();

        }

    }

    /**

     * 新增job任务

     *

     * @param jobName          job名称

     * @param jobGroupName     job分组名称

     * @param triggerName      触发器名称

     * @param triggerGroupName 触发器分组名称

     * @param jobClass         需要执行的job.class

     * @param cron             cron 表达式

     * @throws SchedulerException

     */

    public void addJob(String jobName, String jobGroupName,

                       String triggerName, String triggerGroupName, Class jobClass, String cron) throws SchedulerException {

        CronScheduleBuilder cronScheduleBuilder = CronScheduleBuilder.cronSchedule(cron);

        JobDetail jobDetail = JobBuilder.newJob(jobClass).withIdentity(jobName, jobGroupName).build();

        Trigger trigger = TriggerBuilder.newTrigger().withIdentity(triggerName, triggerGroupName)

                .withSchedule(cronScheduleBuilder).build();

        scheduler.scheduleJob(jobDetail, trigger);

    }