Spring整合Quartz，并持久化Job到MySQL

最新推荐文章于 2024-07-26 14:37:31 发布

Go in memory

最新推荐文章于 2024-07-26 14:37:31 发布

阅读量7.6k

点赞数

分类专栏：整合文章标签： Quartz 整合 MySQL spring

本文链接：https://blog.csdn.net/gp490609578/article/details/48809479

版权

本文介绍了如何将Spring与Quartz作业调度框架整合，并详细阐述了如何配置项目，创建Quartz专用于存储任务信息的MySQL数据库，以及应用Quartz的SQL脚本来实现任务的持久化。

摘要由CSDN通过智能技术生成

1、创建项目

2、创建quartz数据库，并导入Quartz的SQL脚本

mysql> use quartz

Database changed
mysql> show tables;
+--------------------------+
| Tables_in_quartz         |
+--------------------------+
| QRTZ_BLOB_TRIGGERS       |
| QRTZ_CALENDARS           |
| QRTZ_CRON_TRIGGERS       |
| QRTZ_FIRED_TRIGGERS      |
| QRTZ_JOB_DETAILS         |
| QRTZ_LOCKS               |
| QRTZ_PAUSED_TRIGGER_GRPS |
| QRTZ_SCHEDULER_STATE     |
| QRTZ_SIMPLE_TRIGGERS     |
| QRTZ_SIMPROP_TRIGGERS    |
| QRTZ_TRIGGERS            |
+--------------------------+
11 rows in set (0.00 sec)

mysql>

3、maven依赖

    <dependencies>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context-support</artifactId>
            <version>4.1.7.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>4.1.7.RELEASE</version>
        </dependency>

        <dependency>
            <groupId>org.quartz-scheduler</groupId>
            <artifactId>quartz</artifactId>
            <version>2.2.1</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.25</version>
        </dependency>

        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-test</artifactId>
            <version>4.1.7.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.11</version>
            <scope>test</scope>
        </dependency>
    </dependencies>

4、实现Job

package hello;

import org.quartz.JobExecutionContext;
import org.quartz.JobExecutionException;
import org.quartz.SchedulerContext;
import org.quartz.SchedulerException;
import org.springframework.scheduling.quartz.QuartzJobBean;

import java.util.List;

public class DemoJob extends QuartzJobBean {
    private String hello;

    public void setHello(String hello) {
        this.hello = hello;
    }

    @Override
    protected void executeInternal(JobExecutionContext jobExecutionContext) throws JobExecutionException {
        System.out.println("Job executing……");
        System.out.println("hello " + hello);
        try {
            SchedulerContext context = jobExecutionContext.getScheduler().getContext();
            List list = (List) context.get("list");
            for (Object item : list)
                System.out.println(item.getClass().toString() + " - " + item);
        } catch (SchedulerException e) {
            e.printStackTrace();
        }
    }
}

5、在quartz_data.xml文件配置DemoJob的执行规则，每5秒执行一次