Spring Boot+Quartz+Sql Server+vue实现定时任务（带界面）

╰+哭是因爲堅強的太久メ 2022-02-03 02:49 266阅读 0赞

目录结构：

![20190509174739562.png][]

数据库表：（如果是Mysql在官网找到相应脚本即可，网上也很多）

USE [quartz]
    GO
    
    SET ANSI_NULLS ON
    GO
    
    SET QUOTED_IDENTIFIER ON
    GO
    
    SET ANSI_PADDING ON
    GO
    
    IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_QRTZ_TRIGGERS_QRTZ_JOB_DETAILS]') AND OBJECTPROPERTY(id, N'ISFOREIGNKEY') = 1)
    ALTER TABLE [dbo].[QRTZ_TRIGGERS] DROP CONSTRAINT FK_QRTZ_TRIGGERS_QRTZ_JOB_DETAILS
    GO
    IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_QRTZ_CRON_TRIGGERS_QRTZ_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISFOREIGNKEY') = 1)
    ALTER TABLE [dbo].[QRTZ_CRON_TRIGGERS] DROP CONSTRAINT FK_QRTZ_CRON_TRIGGERS_QRTZ_TRIGGERS
    GO
    IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_QRTZ_SIMPLE_TRIGGERS_QRTZ_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISFOREIGNKEY') = 1)
    ALTER TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS] DROP CONSTRAINT FK_QRTZ_SIMPLE_TRIGGERS_QRTZ_TRIGGERS
    GO
    IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_QRTZ_SIMPROP_TRIGGERS_QRTZ_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISFOREIGNKEY') = 1)
    ALTER TABLE [dbo].[QRTZ_SIMPROP_TRIGGERS] DROP CONSTRAINT FK_QRTZ_SIMPROP_TRIGGERS_QRTZ_TRIGGERS
    GO
    IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_QRTZ_JOB_LISTENERS_QRTZ_JOB_DETAILS]') AND parent_object_id = OBJECT_ID(N'[dbo].[QRTZ_JOB_LISTENERS]'))
    ALTER TABLE [dbo].[QRTZ_JOB_LISTENERS] DROP CONSTRAINT [FK_QRTZ_JOB_LISTENERS_QRTZ_JOB_DETAILS]
    IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_QRTZ_TRIGGER_LISTENERS_QRTZ_TRIGGERS]') AND parent_object_id = OBJECT_ID(N'[dbo].[QRTZ_TRIGGER_LISTENERS]'))
    ALTER TABLE [dbo].[QRTZ_TRIGGER_LISTENERS] DROP CONSTRAINT [FK_QRTZ_TRIGGER_LISTENERS_QRTZ_TRIGGERS]
    IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_CALENDARS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
    DROP TABLE [dbo].[QRTZ_CALENDARS]
    GO
    IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_CRON_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
    DROP TABLE [dbo].[QRTZ_CRON_TRIGGERS]
    GO
    IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_BLOB_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
    DROP TABLE [dbo].[QRTZ_BLOB_TRIGGERS]
    GO
    IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_FIRED_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
    DROP TABLE [dbo].[QRTZ_FIRED_TRIGGERS]
    GO
    IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_PAUSED_TRIGGER_GRPS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
    DROP TABLE [dbo].[QRTZ_PAUSED_TRIGGER_GRPS]
    GO
    IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[QRTZ_JOB_LISTENERS]') AND type in (N'U'))
    DROP TABLE [dbo].[QRTZ_JOB_LISTENERS]
    IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_SCHEDULER_STATE]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
    DROP TABLE [dbo].[QRTZ_SCHEDULER_STATE]
    GO
    IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_LOCKS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
    DROP TABLE [dbo].[QRTZ_LOCKS]
    GO
    IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[QRTZ_TRIGGER_LISTENERS]') AND type in (N'U'))
    DROP TABLE [dbo].[QRTZ_TRIGGER_LISTENERS]
    IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_JOB_DETAILS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
    DROP TABLE [dbo].[QRTZ_JOB_DETAILS]
    GO
    IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_SIMPLE_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
    DROP TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS]
    GO
    IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_SIMPROP_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
    DROP TABLE [dbo].QRTZ_SIMPROP_TRIGGERS
    GO
    IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
    DROP TABLE [dbo].[QRTZ_TRIGGERS]
    GO
    CREATE TABLE [dbo].[QRTZ_CALENDARS] (
      [SCHED_NAME] [NVARCHAR] (100)  NOT NULL ,
      [CALENDAR_NAME] [NVARCHAR] (200)  NOT NULL ,
      [CALENDAR] [IMAGE] NOT NULL
    ) ON [PRIMARY]
    GO
    CREATE TABLE [dbo].[QRTZ_CRON_TRIGGERS] (
      [SCHED_NAME] [NVARCHAR] (100)  NOT NULL ,
      [TRIGGER_NAME] [NVARCHAR] (150)  NOT NULL ,
      [TRIGGER_GROUP] [NVARCHAR] (150)  NOT NULL ,
      [CRON_EXPRESSION] [NVARCHAR] (120)  NOT NULL ,
      [TIME_ZONE_ID] [NVARCHAR] (80) 
    ) ON [PRIMARY]
    GO
    CREATE TABLE [dbo].[QRTZ_FIRED_TRIGGERS] (
      [SCHED_NAME] [NVARCHAR] (100)  NOT NULL ,
      [ENTRY_ID] [NVARCHAR] (95)  NOT NULL ,
      [TRIGGER_NAME] [NVARCHAR] (150)  NOT NULL ,
      [TRIGGER_GROUP] [NVARCHAR] (150)  NOT NULL ,
      [INSTANCE_NAME] [NVARCHAR] (200)  NOT NULL ,
      [FIRED_TIME] [BIGINT] NOT NULL ,
      [SCHED_TIME] [BIGINT] NOT NULL ,
      [PRIORITY] [INTEGER] NOT NULL ,
      [STATE] [NVARCHAR] (16)  NOT NULL,
      [JOB_NAME] [NVARCHAR] (150)  NULL ,
      [JOB_GROUP] [NVARCHAR] (150)  NULL ,
      [IS_NONCONCURRENT] BIT  NULL ,
      [REQUESTS_RECOVERY] BIT  NULL 
    ) ON [PRIMARY]
    GO
    CREATE TABLE [dbo].[QRTZ_PAUSED_TRIGGER_GRPS] (
      [SCHED_NAME] [NVARCHAR] (100)  NOT NULL ,
      [TRIGGER_GROUP] [NVARCHAR] (150)  NOT NULL 
    ) ON [PRIMARY]
    GO
    CREATE TABLE [dbo].[QRTZ_SCHEDULER_STATE] (
      [SCHED_NAME] [NVARCHAR] (100)  NOT NULL ,
      [INSTANCE_NAME] [NVARCHAR] (200)  NOT NULL ,
      [LAST_CHECKIN_TIME] [BIGINT] NOT NULL ,
      [CHECKIN_INTERVAL] [BIGINT] NOT NULL
    ) ON [PRIMARY]
    GO
    CREATE TABLE [dbo].[QRTZ_LOCKS] (
      [SCHED_NAME] [NVARCHAR] (100)  NOT NULL ,
      [LOCK_NAME] [NVARCHAR] (40)  NOT NULL 
    ) ON [PRIMARY]
    GO
    CREATE TABLE [dbo].[QRTZ_JOB_DETAILS] (
      [SCHED_NAME] [NVARCHAR] (100)  NOT NULL ,
      [JOB_NAME] [NVARCHAR] (150)  NOT NULL ,
      [JOB_GROUP] [NVARCHAR] (150)  NOT NULL ,
      [DESCRIPTION] [NVARCHAR] (250) NULL ,
      [JOB_CLASS_NAME] [NVARCHAR] (250)  NOT NULL ,
      [IS_DURABLE] BIT  NOT NULL ,
      [IS_NONCONCURRENT] BIT  NOT NULL ,
      [IS_UPDATE_DATA] BIT  NOT NULL ,
      [REQUESTS_RECOVERY] BIT  NOT NULL ,
      [JOB_DATA] [IMAGE] NULL
    ) ON [PRIMARY]
    GO
    CREATE TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS] (
      [SCHED_NAME] [NVARCHAR] (100)  NOT NULL ,
      [TRIGGER_NAME] [NVARCHAR] (150)  NOT NULL ,
      [TRIGGER_GROUP] [NVARCHAR] (150)  NOT NULL ,
      [REPEAT_COUNT] [INTEGER] NOT NULL ,
      [REPEAT_INTERVAL] [BIGINT] NOT NULL ,
      [TIMES_TRIGGERED] [INTEGER] NOT NULL
    ) ON [PRIMARY]
    GO
    CREATE TABLE [dbo].[QRTZ_SIMPROP_TRIGGERS] (
      [SCHED_NAME] [NVARCHAR] (100)  NOT NULL ,
      [TRIGGER_NAME] [NVARCHAR] (150)  NOT NULL ,
      [TRIGGER_GROUP] [NVARCHAR] (150)  NOT NULL ,
      [STR_PROP_1] [NVARCHAR] (512) NULL,
      [STR_PROP_2] [NVARCHAR] (512) NULL,
      [STR_PROP_3] [NVARCHAR] (512) NULL,
      [INT_PROP_1] [INT] NULL,
      [INT_PROP_2] [INT] NULL,
      [LONG_PROP_1] [BIGINT] NULL,
      [LONG_PROP_2] [BIGINT] NULL,
      [DEC_PROP_1] [NUMERIC] (13,4) NULL,
      [DEC_PROP_2] [NUMERIC] (13,4) NULL,
      [BOOL_PROP_1] BIT NULL,
      [BOOL_PROP_2] BIT NULL,
    ) ON [PRIMARY]
    GO
    CREATE TABLE [dbo].[QRTZ_BLOB_TRIGGERS] (
      [SCHED_NAME] [NVARCHAR] (100)  NOT NULL ,
      [TRIGGER_NAME] [NVARCHAR] (150)  NOT NULL ,
      [TRIGGER_GROUP] [NVARCHAR] (150)  NOT NULL ,
      [BLOB_DATA] [IMAGE] NULL
    ) ON [PRIMARY]
    GO
    CREATE TABLE [dbo].[QRTZ_TRIGGERS] (
      [SCHED_NAME] [NVARCHAR] (100)  NOT NULL ,
      [TRIGGER_NAME] [NVARCHAR] (150)  NOT NULL ,
      [TRIGGER_GROUP] [NVARCHAR] (150)  NOT NULL ,
      [JOB_NAME] [NVARCHAR] (150)  NOT NULL ,
      [JOB_GROUP] [NVARCHAR] (150)  NOT NULL ,
      [DESCRIPTION] [NVARCHAR] (250) NULL ,
      [NEXT_FIRE_TIME] [BIGINT] NULL ,
      [PREV_FIRE_TIME] [BIGINT] NULL ,
      [PRIORITY] [INTEGER] NULL ,
      [TRIGGER_STATE] [NVARCHAR] (16)  NOT NULL ,
      [TRIGGER_TYPE] [NVARCHAR] (8)  NOT NULL ,
      [START_TIME] [BIGINT] NOT NULL ,
      [END_TIME] [BIGINT] NULL ,
      [CALENDAR_NAME] [NVARCHAR] (200)  NULL ,
      [MISFIRE_INSTR] [INTEGER] NULL ,
      [JOB_DATA] [IMAGE] NULL
    ) ON [PRIMARY]
    GO
    ALTER TABLE [dbo].[QRTZ_CALENDARS] WITH NOCHECK ADD
      CONSTRAINT [PK_QRTZ_CALENDARS] PRIMARY KEY  CLUSTERED
      (
        [SCHED_NAME],
        [CALENDAR_NAME]
      )  ON [PRIMARY]
    GO
    ALTER TABLE [dbo].[QRTZ_CRON_TRIGGERS] WITH NOCHECK ADD
      CONSTRAINT [PK_QRTZ_CRON_TRIGGERS] PRIMARY KEY  CLUSTERED
      (
        [SCHED_NAME],
        [TRIGGER_NAME],
        [TRIGGER_GROUP]
      )  ON [PRIMARY]
    GO
    ALTER TABLE [dbo].[QRTZ_FIRED_TRIGGERS] WITH NOCHECK ADD
      CONSTRAINT [PK_QRTZ_FIRED_TRIGGERS] PRIMARY KEY  CLUSTERED
      (
        [SCHED_NAME],
        [ENTRY_ID]
      )  ON [PRIMARY]
    GO
    ALTER TABLE [dbo].[QRTZ_PAUSED_TRIGGER_GRPS] WITH NOCHECK ADD
      CONSTRAINT [PK_QRTZ_PAUSED_TRIGGER_GRPS] PRIMARY KEY  CLUSTERED
      (
        [SCHED_NAME],
        [TRIGGER_GROUP]
      )  ON [PRIMARY]
    GO
    ALTER TABLE [dbo].[QRTZ_SCHEDULER_STATE] WITH NOCHECK ADD
      CONSTRAINT [PK_QRTZ_SCHEDULER_STATE] PRIMARY KEY  CLUSTERED
      (
        [SCHED_NAME],
        [INSTANCE_NAME]
      )  ON [PRIMARY]
    GO
    ALTER TABLE [dbo].[QRTZ_LOCKS] WITH NOCHECK ADD
      CONSTRAINT [PK_QRTZ_LOCKS] PRIMARY KEY  CLUSTERED
      (
        [SCHED_NAME],
        [LOCK_NAME]
      )  ON [PRIMARY]
    GO
    ALTER TABLE [dbo].[QRTZ_JOB_DETAILS] WITH NOCHECK ADD
      CONSTRAINT [PK_QRTZ_JOB_DETAILS] PRIMARY KEY  CLUSTERED
      (
        [SCHED_NAME],
        [JOB_NAME],
        [JOB_GROUP]
      )  ON [PRIMARY]
    GO
    ALTER TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS] WITH NOCHECK ADD
      CONSTRAINT [PK_QRTZ_SIMPLE_TRIGGERS] PRIMARY KEY  CLUSTERED
      (
        [SCHED_NAME],
        [TRIGGER_NAME],
        [TRIGGER_GROUP]
      )  ON [PRIMARY]
    GO
    ALTER TABLE [dbo].[QRTZ_SIMPROP_TRIGGERS] WITH NOCHECK ADD
      CONSTRAINT [PK_QRTZ_SIMPROP_TRIGGERS] PRIMARY KEY  CLUSTERED
      (
        [SCHED_NAME],
        [TRIGGER_NAME],
        [TRIGGER_GROUP]
      )  ON [PRIMARY]
    GO
    ALTER TABLE [dbo].[QRTZ_TRIGGERS] WITH NOCHECK ADD
      CONSTRAINT [PK_QRTZ_TRIGGERS] PRIMARY KEY  CLUSTERED
      (
        [SCHED_NAME],
        [TRIGGER_NAME],
        [TRIGGER_GROUP]
      )  ON [PRIMARY]
    GO
    ALTER TABLE [dbo].[QRTZ_CRON_TRIGGERS] ADD
      CONSTRAINT [FK_QRTZ_CRON_TRIGGERS_QRTZ_TRIGGERS] FOREIGN KEY
      (
        [SCHED_NAME],
        [TRIGGER_NAME],
        [TRIGGER_GROUP]
      ) REFERENCES [dbo].[QRTZ_TRIGGERS] (
        [SCHED_NAME],
        [TRIGGER_NAME],
        [TRIGGER_GROUP]
      ) ON DELETE CASCADE
    GO
    ALTER TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS] ADD
      CONSTRAINT [FK_QRTZ_SIMPLE_TRIGGERS_QRTZ_TRIGGERS] FOREIGN KEY
      (
        [SCHED_NAME],
        [TRIGGER_NAME],
        [TRIGGER_GROUP]
      ) REFERENCES [dbo].[QRTZ_TRIGGERS] (
        [SCHED_NAME],
        [TRIGGER_NAME],
        [TRIGGER_GROUP]
      ) ON DELETE CASCADE
    GO
    ALTER TABLE [dbo].[QRTZ_SIMPROP_TRIGGERS] ADD
      CONSTRAINT [FK_QRTZ_SIMPROP_TRIGGERS_QRTZ_TRIGGERS] FOREIGN KEY
      (
        [SCHED_NAME],
        [TRIGGER_NAME],
        [TRIGGER_GROUP]
      ) REFERENCES [dbo].[QRTZ_TRIGGERS] (
        [SCHED_NAME],
        [TRIGGER_NAME],
        [TRIGGER_GROUP]
      ) ON DELETE CASCADE
    GO
    ALTER TABLE [dbo].[QRTZ_TRIGGERS] ADD
      CONSTRAINT [FK_QRTZ_TRIGGERS_QRTZ_JOB_DETAILS] FOREIGN KEY
      (
        [SCHED_NAME],
        [JOB_NAME],
        [JOB_GROUP]
      ) REFERENCES [dbo].[QRTZ_JOB_DETAILS] (
        [SCHED_NAME],
        [JOB_NAME],
        [JOB_GROUP]
      )
    GO
    CREATE INDEX IDX_QRTZ_T_J ON QRTZ_TRIGGERS(SCHED_NAME,JOB_NAME,JOB_GROUP)
    CREATE INDEX IDX_QRTZ_T_JG ON QRTZ_TRIGGERS(SCHED_NAME,JOB_GROUP)
    CREATE INDEX IDX_QRTZ_T_C ON QRTZ_TRIGGERS(SCHED_NAME,CALENDAR_NAME)
    CREATE INDEX IDX_QRTZ_T_G ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_GROUP)
    CREATE INDEX IDX_QRTZ_T_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_STATE)
    CREATE INDEX IDX_QRTZ_T_N_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_STATE)
    CREATE INDEX IDX_QRTZ_T_N_G_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_GROUP,TRIGGER_STATE)
    CREATE INDEX IDX_QRTZ_T_NEXT_FIRE_TIME ON QRTZ_TRIGGERS(SCHED_NAME,NEXT_FIRE_TIME)
    CREATE INDEX IDX_QRTZ_T_NFT_ST ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_STATE,NEXT_FIRE_TIME)
    CREATE INDEX IDX_QRTZ_T_NFT_MISFIRE ON QRTZ_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME)
    CREATE INDEX IDX_QRTZ_T_NFT_ST_MISFIRE ON QRTZ_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_STATE)
    CREATE INDEX IDX_QRTZ_T_NFT_ST_MISFIRE_GRP ON QRTZ_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_GROUP,TRIGGER_STATE)
    CREATE INDEX IDX_QRTZ_FT_TRIG_INST_NAME ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,INSTANCE_NAME)
    CREATE INDEX IDX_QRTZ_FT_INST_JOB_REQ_RCVRY ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,INSTANCE_NAME,REQUESTS_RECOVERY)
    CREATE INDEX IDX_QRTZ_FT_J_G ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,JOB_NAME,JOB_GROUP)
    CREATE INDEX IDX_QRTZ_FT_JG ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,JOB_GROUP)
    CREATE INDEX IDX_QRTZ_FT_T_G ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
    CREATE INDEX IDX_QRTZ_FT_TG ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,TRIGGER_GROUP)

pom依赖：

<?xml version="1.0" encoding="UTF-8"?>
    <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    	<modelVersion>4.0.0</modelVersion>
    
    	<groupId>com.example.quartz</groupId>
    	<artifactId>springboot-quartz</artifactId>
    	<version>0.0.1-SNAPSHOT</version>
    	<packaging>jar</packaging>
    
    	<name>springboot-quartz</name>
    	<description>Demo project for Spring Boot quartz</description>
    
    	<parent>
    		<groupId>org.springframework.boot</groupId>
    		<artifactId>spring-boot-starter-parent</artifactId>
    		<version>2.0.5.RELEASE</version>
    		<relativePath/> 
    	</parent>
    
    	<properties>
    		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    		<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
    		<java.version>1.8</java.version>
    	</properties>
    
    	<dependencies>
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-quartz</artifactId>
    		</dependency>
    		<dependency>
    			<groupId>com.alibaba</groupId>
    			<artifactId>druid</artifactId>
    			<version>1.0.11</version>
    		</dependency>
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-web</artifactId>
    		</dependency>
    		<dependency>
    			<groupId>org.mybatis.spring.boot</groupId>
    			<artifactId>mybatis-spring-boot-starter</artifactId>
    			<version>1.3.2</version>
    		</dependency>
    
    		
    		<dependency>
    			<groupId>com.microsoft.sqlserver</groupId>
    			<artifactId>mssql-jdbc</artifactId>
    			<scope>runtime</scope>
    		</dependency>
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-test</artifactId>
    			<scope>test</scope>
    		</dependency>
    		<dependency>
    			<groupId>com.github.pagehelper</groupId>
    			<artifactId>pagehelper</artifactId>
    			<version>5.0.0</version>
    		</dependency>
    		<dependency>
    			<groupId>com.mchange</groupId>
    			<artifactId>c3p0</artifactId>
    			<version>0.9.5.2</version>
    		</dependency>
    		
    		
    	</dependencies>
    
    	<build>
    		<plugins>
    			<plugin>
    				<groupId>org.springframework.boot</groupId>
    				<artifactId>spring-boot-maven-plugin</artifactId>
    			</plugin>
    		</plugins>
    	</build>
    
    </project>

yml配置文件：

mybatis:
      configuration:
        log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
      mapper-locations: classpath*:mappers/*Mapper.xml
    
    spring:
      datasource:
        driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
        url:jdbc:sqlserver://120.78.250.117:51000;instanceName=CTR_SERVER;DatabaseName=gameData
        username: shui
        password: Lh969339353
        type: com.alibaba.druid.pool.DruidDataSource

quartz配置文件：

# 固定前缀org.quartz
    # 主要分为scheduler、threadPool、jobStore、plugin等部分
    #
    #
    org.quartz.scheduler.instanceName = DefaultQuartzScheduler
    
    #如果您希望Quartz Scheduler通过RMI作为服务器导出本身，则将“rmi.export”标志设置为true。
    #在同一个配置文件中为'org.quartz.scheduler.rmi.export'和'org.quartz.scheduler.rmi.proxy'指定一个'true'值是没有意义的,如果你这样做，'export '选项将被忽略
    org.quartz.scheduler.rmi.export = false
    #如果要连接（使用）远程服务的调度程序，则将“org.quartz.scheduler.rmi.proxy”标志设置为true。您还必须指定RMI注册表进程的主机和端口 - 通常是“localhost”端口1099。
    org.quartz.scheduler.rmi.proxy = false
    
    org.quartz.scheduler.wrapJobExecutionInUserTransaction = false
    
    # 实例化ThreadPool时，使用的线程类为SimpleThreadPool
    org.quartz.threadPool.class = org.quartz.simpl.SimpleThreadPool
    
    # threadCount和threadPriority将以setter的形式注入ThreadPool实例
    # 并发个数  如果你只有几个工作每天触发几次 那么1个线程就可以,如果你有成千上万的工作，每分钟都有很多工作 那么久需要50-100之间.
    # 只有1到100之间的数字是非常实用的
    org.quartz.threadPool.threadCount = 5
    
    # 优先级 默认值为5
    org.quartz.threadPool.threadPriority = 5
    
    #可以是“true”或“false”，默认为false。
    org.quartz.threadPool.threadsInheritContextClassLoaderOfInitializingThread = true
    
    #在被认为“misfired”(失火)之前，调度程序将“tolerate(容忍)”一个Triggers(触发器)将其下一个启动时间通过的毫秒数。默认值（如果您在配置中未输入此属性）为60000（60秒）
    org.quartz.jobStore.misfireThreshold = 5000
    
    # 默认存储在内存中,RAMJobStore快速轻便，但是当进程终止时，所有调度信息都会丢失。
    #org.quartz.jobStore.class = org.quartz.simpl.RAMJobStore
    
    #持久化
    org.quartz.jobStore.class = org.quartz.impl.jdbcjobstore.JobStoreTX
    
    #您需要为JobStore选择一个DriverDelegate才能使用。DriverDelegate负责执行特定数据库可能需要的任何JDBC工作。
    # StdJDBCDelegate是一个使用“vanilla”JDBC代码（和SQL语句）来执行其工作的委托,用于完全符合JDBC的驱动程序
    org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.StdJDBCDelegate
    
    #可以将“org.quartz.jobStore.useProperties”配置参数设置为“true”（默认为false），以指示JDBCJobStore将JobDataMaps中的所有值都作为字符串，
    # 因此可以作为名称 - 值对存储而不是在BLOB列中以其序列化形式存储更多复杂的对象。从长远来看，这是更安全的，因为您避免了将非String类序列化为BLOB的类版本问题。
    org.quartz.jobStore.useProperties=true
    
    #表前缀
    org.quartz.jobStore.tablePrefix = QRTZ_
    
    #您需要设置JobStore应该使用哪个DataSource。
    org.quartz.jobStore.dataSource = qzDS
    
    
    org.quartz.dataSource.qzDS.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
    org.quartz.dataSource.qzDS.URL=jdbc:sqlserver://120.78.250.117:51000;instanceName=CTR_SERVER;DatabaseName=gameData
    org.quartz.dataSource.qzDS.user=shui
    org.quartz.dataSource.qzDS.password=Lh969339353
    org.quartz.dataSource.qzDS.maxConnections = 10
    
    #设置为“true”以打开群集功能。如果您有多个Quartz实例使用同一组数据库表，则此属性必须设置为“true”，否则您将遇到破坏。
    #org.quartz.jobStore.isClustered=false
    
    #配置集群参见:  https://www.w3cschool.cn/quartz_doc/quartz_doc-3x7u2doc.html

xml文件：

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
    <mapper namespace="com.example.quartz.dao.JobAndTriggerMapper">
        <select id="getJobAndTriggerDetails" resultType="com.example.quartz.model.JobAndTrigger">
            SELECT DISTINCT
            QRTZ_JOB_DETAILS.JOB_NAME,
            QRTZ_JOB_DETAILS.JOB_GROUP,
            QRTZ_JOB_DETAILS.JOB_CLASS_NAME,
            QRTZ_TRIGGERS.TRIGGER_NAME,
            QRTZ_TRIGGERS.TRIGGER_GROUP,
            QRTZ_CRON_TRIGGERS.CRON_EXPRESSION,
            QRTZ_CRON_TRIGGERS.TIME_ZONE_ID
            FROM
            QRTZ_JOB_DETAILS
            INNER JOIN QRTZ_TRIGGERS ON QRTZ_TRIGGERS.TRIGGER_GROUP=QRTZ_JOB_DETAILS.JOB_GROUP
            INNER JOIN QRTZ_CRON_TRIGGERS ON QRTZ_JOB_DETAILS.JOB_NAME = QRTZ_TRIGGERS.JOB_NAME
            and QRTZ_TRIGGERS.TRIGGER_NAME = QRTZ_CRON_TRIGGERS.TRIGGER_NAME
            and QRTZ_TRIGGERS.TRIGGER_GROUP = QRTZ_CRON_TRIGGERS.TRIGGER_GROUP
        </select>
    </mapper>

配置类config:

@Configuration
    public class SchedulerConfig {
    
        @Bean(name="SchedulerFactory")
        public SchedulerFactoryBean schedulerFactoryBean() throws IOException {
            SchedulerFactoryBean factory = new SchedulerFactoryBean();
            factory.setQuartzProperties(quartzProperties());
            return factory;
        }
    
        @Bean
        public Properties quartzProperties() throws IOException {
            PropertiesFactoryBean propertiesFactoryBean = new PropertiesFactoryBean();
            propertiesFactoryBean.setLocation(new ClassPathResource("/quartz.properties"));
            //在quartz.properties中的属性被读取并注入后再初始化对象
            propertiesFactoryBean.afterPropertiesSet();
            return propertiesFactoryBean.getObject();
        }
    
        /**
         * quartz初始化监听器
         * 这个监听器可以监听到工程的启动，在工程停止再启动时可以让已有的定时任务继续进行。
         * @return
         */
        @Bean
        public QuartzInitializerListener executorListener() {
            return new QuartzInitializerListener();
        }
    
        /**
         *
         *通过SchedulerFactoryBean获取Scheduler的实例
         */
    
        @Bean(name="Scheduler")
        public Scheduler scheduler() throws IOException {
            return schedulerFactoryBean().getScheduler();
        }
    
    }

前端（放在quartzproject\\src\\main\\resources\\templates）：

<!DOCTYPE html>
    <html>
    <head>
        <meta charset="UTF-8">
        <title>QuartzDemo</title>
        <link rel="stylesheet" href="https://unpkg.com/element-ui@2.0.5/lib/theme-chalk/index.css">
        <script src="https://unpkg.com/vue/dist/vue.js"></script>
        <script src="http://cdn.bootcss.com/vue-resource/1.3.4/vue-resource.js"></script>
        <script src="https://unpkg.com/element-ui@2.0.5/lib/index.js"></script>
    
        <style>
            #top {
                background:#20A0FF;
                padding:5px;
                overflow:hidden
            }
        </style>
    
    </head>
    <body>
    <div id="test">
    
        <div id="top">
            <el-button type="text" @click="search" style="color:white">查询</el-button>
            <el-button type="text" @click="handleadd" style="color:white">添加</el-button>
            </span>
        </div>
    
        <br/>
    
        <div style="margin-top:15px">
    
            <el-table
                    ref="testTable"
                    :data="tableData"
                    style="width:100%"
                    border
            >
                <el-table-column
                        prop="job_NAME"
                        label="任务名称"
                        sortable
                        show-overflow-tooltip>
                </el-table-column>
    
                <el-table-column
                        prop="job_GROUP"
                        label="任务所在组"
                        sortable>
                </el-table-column>
    
                <el-table-column
                        prop="job_CLASS_NAME"
                        label="任务类名"
                        sortable>
                </el-table-column>
    
                <el-table-column
                        prop="trigger_NAME"
                        label="触发器名称"
                        sortable>
                </el-table-column>
    
                <el-table-column
                        prop="trigger_GROUP"
                        label="触发器所在组"
                        sortable>
                </el-table-column>
    
                <el-table-column
                        prop="cron_EXPRESSION"
                        label="表达式"
                        sortable>
                </el-table-column>
    
                <el-table-column
                        prop="time_ZONE_ID"
                        label="时区"
                        sortable>
                </el-table-column>
    
                <el-table-column label="操作" width="300">
                    <template scope="scope">
                        <el-button
                                size="small"
                                type="warning"
                                @click="handlePause(scope.$index, scope.row)">暂停</el-button>
    
                        <el-button
                                size="small"
                                type="info"
                                @click="handleResume(scope.$index, scope.row)">恢复</el-button>
    
                        <el-button
                                size="small"
                                type="danger"
                                @click="handleDelete(scope.$index, scope.row)">删除</el-button>
    
                        <el-button
                                size="small"
                                type="success"
                                @click="handleUpdate(scope.$index, scope.row)">修改</el-button>
                    </template>
                </el-table-column>
            </el-table>
    
            <div align="center">
                <el-pagination
                        @size-change="handleSizeChange"
                        @current-change="handleCurrentChange"
                        :current-page="currentPage"
                        :page-sizes="[10, 20, 30, 40]"
                        :page-size="pagesize"
                        layout="total, sizes, prev, pager, next, jumper"
                        :total="totalCount">
                </el-pagination>
            </div>
        </div>
        <el-dialog title="选择任务" :visible.sync="checkboxChange">
                <el-radio-group v-model="ruleForm.resource">
                    <el-radio :label="3">Simple Trigger</el-radio>
                    <el-radio :label="6">Cron Trigger</el-radio>
                </el-radio-group>
            <div slot="footer" class="dialog-footer">
                <el-button @click="checkboxChange = false">取 消</el-button>
                <el-button type="primary" @click="change">确 定</el-button>
            </div>
        </el-dialog>
        <el-dialog title="添加任务" :visible.sync="dialogFormVisibleChange" v-if="ruleForm.resource==3">
            <el-form :model="form" >
                <el-form-item label="任务名称" label-width="120px" style="width:35%">
                    <el-input v-model="form.jobName" auto-complete="off"></el-input>
                </el-form-item>
                <el-form-item label="任务分组" label-width="120px" style="width:35%">
                    <el-input v-model="form.jobGroup" auto-complete="off"></el-input>
                </el-form-item>
                <el-form-item label="多久之后执行" label-width="120px" style="width:35%">
                    <el-input v-model="form.cronExpression" auto-complete="off"></el-input>
    
                    <el-select v-model="value4"  placeholder="请选择">
                        <el-option
                                v-for="item in options"
                                :key="item.value"
                                :label="item.label"
                                :value="item.value">
                        </el-option>
                    </el-select>
                </el-form-item>
            </el-form>
            <div slot="footer" class="dialog-footer">
                <el-button @click="dialogFormVisibleChange = false">取 消</el-button>
                <el-button type="primary" @click="addSimTir">确 定</el-button>
            </div>
        </el-dialog>
        <el-dialog title="添加任务" :visible.sync="dialogFormVisibleChange" v-if="ruleForm.resource==6">
            <el-form :model="form">
                <el-form-item label="任务名称" label-width="120px" style="width:35%">
                    <el-input v-model="form.jobName" auto-complete="off"></el-input>
                </el-form-item>
                <el-form-item label="任务分组" label-width="120px" style="width:35%">
                    <el-input v-model="form.jobGroup" auto-complete="off"></el-input>
                </el-form-item>
                <el-form-item label="表达式" label-width="120px" style="width:35%">
                    <el-input v-model="form.cronExpression" auto-complete="off"></el-input>
                </el-form-item>
            </el-form>
            <div slot="footer" class="dialog-footer">
                <el-button @click="dialogFormVisibleChange = false">取 消</el-button>
                <el-button type="primary" @click="add">确 定</el-button>
            </div>
        </el-dialog>
    
        <el-dialog title="修改任务" :visible.sync="updateFormVisible">
            <el-form :model="updateform">
                <el-form-item label="表达式" label-width="120px" style="width:35%">
                    <el-input v-model="updateform.cronExpression" auto-complete="off"></el-input>
                </el-form-item>
            </el-form>
            <div slot="footer" class="dialog-footer">
                <el-button @click="updateFormVisible = false">取 消</el-button>
                <el-button type="primary" @click="update">确 定</el-button>
            </div>
        </el-dialog>
    
    </div>
    
    <footer align="center">
        <p>© Quartz 任务管理</p>
    </footer>
    
    <script>
        var vue = new Vue({
            el:"#test",
            data: {
                //表格当前页数据
                tableData: [],
    
                //请求的URL
                url:'job/queryjob',
    
                //默认每页数据量
                pagesize: 10,
    
                //当前页码
                currentPage: 1,
    
                //查询的页码
                start: 1,
    
                //默认数据总数
                totalCount: 1000,
    
                //添加对话框默认可见性
                dialogFormVisible: false,
    
                //修改对话框默认可见性
                updateFormVisible: false,
                //选择对话框
                dialogFormVisibleChange: false,
    
                checkboxChange:false,
    
                //提交的表单
                form: {
                    jobName: '',
                    jobGroup: '',
                    cronExpression: '',
                    timeType: ''
                },
                ruleForm: {
                    resource: 3
                },
    
                updateform: {
                    jobName: '',
                    jobGroup: '',
                    cronExpression: '',
                },
                options: [{
                    value: 1,
                    label: '年'
                }, {
                    value: 2,
                    label: '月'
                }, {
                    value: 3,
                    label: '天'
                }, {
                    value: 4,
                    label: '小时'
                }, {
                    value: 5,
                    label: '分钟'
                }, {
                    value: 6,
                    label: '周'
                },{
                  value: 7,
                  label: '秒'
                 }],
                value4: ''
            },
            methods: {
    
                //从服务器读取数据
                loadData: function(pageNum, pageSize){
                    this.$http.get('job/queryjob?' + 'pageNum=' +  pageNum + '&pageSize=' + pageSize).then(function(res){
                        console.log(res)
                        this.tableData = res.body.JobAndTrigger.list;
                        this.totalCount = res.body.number;
                    },function(){
                        console.log('failed');
                    });
                },
    
                //单行删除
                handleDelete: function(index, row) {
                    this.$http.post('job/deletejob',{"jobClassName":row.job_NAME,"jobGroupName":row.job_GROUP},{emulateJSON: true}).then(function(res){
                        this.loadData( this.currentPage, this.pagesize);
                    },function(){
                        console.log('failed');
                    });
                },
    
                //暂停任务
                handlePause: function(index, row){
                    this.$http.post('job/pausejob',{"jobClassName":row.job_NAME,"jobGroupName":row.job_GROUP},{emulateJSON: true}).then(function(res){
                        this.loadData( this.currentPage, this.pagesize);
                    },function(){
                        console.log('failed');
                    });
                },
    
                //恢复任务
                handleResume: function(index, row){
                    this.$http.post('job/resumejob',{"jobClassName":row.job_NAME,"jobGroupName":row.job_GROUP},{emulateJSON: true}).then(function(res){
                        this.loadData( this.currentPage, this.pagesize);
                    },function(){
                        console.log('failed');
                    });
                },
    
                //搜索
                search: function(){
                    this.loadData(this.currentPage, this.pagesize);
                },
    
                //弹出对话框
                handleadd: function(){
                    this.checkboxChange = true;
                },
                change: function(){
                    this.dialogFormVisibleChange = true;
                },
    
                //添加
                add: function(){
                    this.$http.post('job/addjob',{"jobClassName":this.form.jobName,"jobGroupName":this.form.jobGroup,"cronExpression":this.form.cronExpression}).then(function(res){
                        this.loadData(this.currentPage, this.pagesize);
                        this.dialogFormVisibleChange = false;
                        this.checkboxChange = false;
                    },function(){
                        console.log('failed');
                    });
                },
                addSimTir: function () {
                    console.log(this.value4)
                    this.$http.post('job/addjob',{"jobClassName":this.form.jobName,"jobGroupName":this.form.jobGroup,"cronExpression":this.form.cronExpression,
                        "timeType":this.value4}).then(function(res){
                        this.loadData(this.currentPage, this.pagesize);
                        this.dialogFormVisibleChange = false;
                        this.checkboxChange = false;
                    },function(){
                        console.log('failed');
                    });
                },
    
                //更新
                handleUpdate: function(index, row){
                    console.log(row)
                    this.updateFormVisible = true;
                    this.updateform.jobName = row.job_CLASS_NAME;
                    this.updateform.jobGroup = row.job_GROUP;
                },
    
                //更新任务
                update: function(){
                    this.$http.post
                    ('job/reschedulejob',
                        {"jobClassName":this.updateform.jobName,
                            "jobGroupName":this.updateform.jobGroup,
                            "cronExpression":this.updateform.cronExpression
                        },{emulateJSON: true}
                    ).then(function(res){
                        this.loadData(this.currentPage, this.pagesize);
                        this.updateFormVisible = false;
                    },function(){
                        console.log('failed');
                    });
    
                },
    
                //每页显示数据量变更
                handleSizeChange: function(val) {
                    this.pagesize = val;
                    this.loadData(this.currentPage, this.pagesize);
                },
    
                //页码变更
                handleCurrentChange: function(val) {
                    this.currentPage = val;
                    this.loadData(this.currentPage, this.pagesize);
                },
    
            },
    
    
        });
    
        //载入数据
        vue.loadData(vue.currentPage, vue.pagesize);
    </script>
    
    </body>
    </html>

源码下载：[quartz项目][quartz]

直接问我要也行

[20190509174739562.png]: /images/20220203/c8261c29f79f4bb0957fbeca0ce5695e.png
[quartz]: https://download.csdn.net/download/qq_41618510/11169475