spring boot整合quartz框架,存储到mysql数据库

 时间:2026-02-15 18:42:31

1、利用intellij idea创建java maven项目

spring boot整合quartz框架,存储到mysql数据库

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>

spring boot整合quartz框架,存储到mysql数据库

3、整个pom配置文件如下图所示

spring boot整合quartz框架,存储到mysql数据库

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

spring boot整合quartz框架,存储到mysql数据库

5、打开源码,找到org/quartz/impl/jdbcjobstore/tables_mysql_innodb.sql,复制sql语句,初始化数据库表

spring boot整合quartz框架,存储到mysql数据库

6、如果要在job实现类中,注入spring的其他单例,可以使用@Component注解。然后就可以根据quartz的文档开发,JobBuilder.newJob(jobClass),底层会找到刚才主导到spring容器的job类

spring boot整合quartz框架,存储到mysql数据库

  • spring boot整合quartz
  • spring boot配置mysql
  • spring boot整合mybatis框架
  • spring boot配置redis
  • Spring Boot系列之quartz
  • 热门搜索
    益阳旅游 红旗渠旅游 欧洲旅游指南 大连旅游网 正规旅游网站 宜兴旅游景点大全 葫芦岛旅游景点 旅游综合体 翡翠岛旅游攻略 黄河旅游