spring boot整合quartz框架,存储到mysql数据库
1、利用intellij idea创建java maven项目
2、添加如下重要依赖spring-boot-starter-quartz
<!-- https://mvnrepository.com/artifact/org.springframework.boot/spring-boot-starter-quartz -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-quartz</artifactId>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework.boot/spring-boot-starter-jdbc -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.38</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.1.10</version>
</dependency>
3、整个pom配置文件如下图所示
4、在application.yml配置文件，添加数据源配置，quartz相关配置，如下图所示
logging:
level:
root: debug
spring:
datasource:
druid:
driver-class-name: com.mysql.jdbc.Driver
url: jdbc:mysql://localhost:3306/quartz?serverTimezone=Hongkong&characterEncoding=utf8&useUnicode=true&useSSL=false&allowMultiQueries=true
username: root
password: 123456
initialSize: 5
minIdle: 50
maxActive: 500
maxWait: 60000
timeBetweenEvictionRunsMillis: 60000
minEvictableIdleTimeMillis: 300000
validationQuery: SELECT 1
testWhileIdle: true
testOnBorrow: false
testOnReturn: false
poolPreparedStatements: true
maxPoolPreparedStatementPerConnectionSize: 20
filters: stat,wall,log4j
connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
useGlobalDataSourceStat: true
quartz:
job-store-type: jdbc
5、打开源码，找到org/quartz/impl/jdbcjobstore/tables_mysql_innodb.sql，复制sql语句，初始化数据库表
6、如果要在job实现类中，注入spring的其他单例，可以使用@Component注解。然后就可以根据quartz的文档开发，JobBuilder.newJob(jobClass)，底层会找到刚才主导到spring容器的job类
