SpringBoot+Quartz+数据库存储
Spring整合Quartz
a、quartz调度框架是有内置表的
进入quartz的官网 添加链接描述,点击Downloads,
下载后在目录\docs\dbTables下有常用数据库创建quartz表的脚本,例如:“tables_mysql.sql”
table_mysql.sql
table_mysql_innodb.sql
上述两者所有的数据库引擎不一样
quartz项目
导入所需要的pom.xml依赖-------除创建项目后所需的
<dependency>
<groupId>org.quartz-scheduler</groupId>
<artifactId>quartz-jobs</artifactId>
<version>2.2.1</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.1.10</version>
</dependency>
DruidConnectionProvider.java
package com.xzy.quartz02.utils;
import com.alibaba.druid.pool.DruidDataSource;
import org.quartz.SchedulerException;
import org.quartz.utils.ConnectionProvider;
import java.sql.Connection;
import java.sql.SQLException;
/*
#============================================================================
# JDBC
#============================================================================
org.quartz.jobStore.driverDelegateClass:org.quartz.impl.jdbcjobstore.StdJDBCDelegate
org.quartz.jobStore.useProperties:false
org.quartz.jobStore.dataSource:qzDS
#org.quartz.dataSource.qzDS.connectionProvider.class:org.quartz.utils.PoolingConnectionProvider
org.quartz.dataSource.qzDS.connectionProvider.class:com.zking.q03.quartz.DruidConnectionProvider
org.quartz.dataSource.qzDS.driver:com.mysql.jdbc.Driver
org.quartz.dataSource.qzDS.URL:jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=UTF-8
org.quartz.dataSource.qzDS.user:root
org.quartz.dataSource.qzDS.password:root
org.quartz.dataSource.qzDS.maxConnections:30
org.quartz.dataSource.qzDS.validationQuery: select 0
*/
/**
* [Druid连接池的Quartz扩展类]
*
* @ProjectName: []
* @Author: [xuguang]
* @CreateDate: [2015/11/10 17:58]
* @Update: [说明本次修改内容] BY[xuguang][2018/11/15]
* @Version: [v1.0]
*/
public class DruidConnectionProvider implements ConnectionProvider {
/*
* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
*
* 常量配置,与quartz.properties文件的key保持一致(去掉前缀),同时提供set方法,Quartz框架自动注入值。
*
* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
*/
//JDBC驱动
public String driver;
//JDBC连接串
public String URL;
//数据库用户名
public String user;
//数据库用户密码
public String password;
//数据库最大连接数
public int maxConnection;
//数据库SQL查询每次连接返回执行到连接池,以确保它仍然是有效的。
public String validationQuery;
private boolean validateOnCheckout;
private int idleConnectionValidationSeconds;
public String maxCachedStatementsPerConnection;
private String discardIdleConnectionsSeconds;
public static final int DEFAULT_DB_MAX_CONNECTIONS = 10;
public static final int DEFAULT_DB_MAX_CACHED_STATEMENTS_PER_CONNECTION = 120;
//Druid连接池
private DruidDataSource datasource;
/*
* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
*
* 接口实现
*
* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
*/
public Connection getConnection() throws SQLException {
return datasource.getConnection();
}
public void shutdown() throws SQLException {
datasource.close();
}
public void initialize() throws SQLException{
if (this.URL == null) {
throw new SQLException("DBPool could not be created: DB URL cannot be null");
}
if (this.driver == null) {
throw new SQLException("DBPool driver could not be created: DB driver class name cannot be null!");
}
if (this.maxConnection < 0) {
throw new SQLException("DBPool maxConnectins could not be created: Max connections must be greater than zero!");
}
datasource = new DruidDataSource();
try{
datasource.setDriverClassName(this.driver);
} catch (Exception e) {
try {
throw new SchedulerException("Problem setting driver class name on datasource: " + e.getMessage(), e);
} catch (SchedulerException e1) {
}
}
datasource.setUrl(this.URL);
datasource.setUsername(this.user);
datasource.setPassword(this.password);
datasource.setMaxActive(this.maxConnection);
datasource.setMinIdle(1);
datasource.setMaxWait(0);
datasource.setMaxPoolPreparedStatementPerConnectionSize(this.DEFAULT_DB_MAX_CACHED_STATEMENTS_PER_CONNECTION);
if (this.validationQuery != null) {
datasource.setValidationQuery(this.validationQuery);
if(!this.validateOnCheckout)
datasource.setTestOnReturn(true);
else
datasource.setTestOnBorrow(true);
datasource.setValidationQueryTimeout(this.idleConnectionValidationSeconds);
}
}
/*
* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
*
* 提供get set方法
*
* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
*/
public String getDriver() {
return driver;
}
public void setDriver(String driver) {
this.driver = driver;
}
public String getURL() {
return URL;
}
public void setURL(String URL) {
this.URL = URL;
}
public String getUser() {
return user;
}
public void setUser(String user) {
this.user = user;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public int getMaxConnection() {
return maxConnection;
}
public void setMaxConnection(int maxConnection) {
this.maxConnection = maxConnection;
}
public String getValidationQuery() {
return validationQuery;
}
public void setValidationQuery(String validationQuery) {
this.validationQuery = validationQuery;
}
public boolean isValidateOnCheckout() {
return validateOnCheckout;
}
public void setValidateOnCheckout(boolean validateOnCheckout) {
this.validateOnCheckout = validateOnCheckout;
}
public int getIdleConnectionValidationSeconds() {
return idleConnectionValidationSeconds;
}
public void setIdleConnectionValidationSeconds(int idleConnectionValidationSeconds) {
this.idleConnectionValidationSeconds = idleConnectionValidationSeconds;
}
public DruidDataSource getDatasource() {
return datasource;
}
public void setDatasource(DruidDataSource datasource) {
this.datasource = datasource;
}
}
quartz默认的配置
在项目中添加quartz.properties文件(这样就不会加载自带的properties文件) 此文件的内容主要分为:scheduler,ThreadPool,JobStore,plugin,Datasources等部分,覆盖properties文件的目的是覆盖默认的数据源,更换为druid的数据配置
自定义MyJobFactory,解决spring不能在quartz中注入bean的问题
package com.xzy.quartz02.utils;
import lombok.extern.slf4j.Slf4j;
import org.quartz.spi.TriggerFiredBundle;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.config.AutowireCapableBeanFactory;
import org.springframework.scheduling.quartz.AdaptableJobFactory;
import org.springframework.stereotype.Component;
@Component
@Slf4j
public class MyJobFactory extends AdaptableJobFactory {
//这个对象Spring会帮我们自动注入进来 AutowireCapableBeanFactory自动装配
@Autowired
private AutowireCapableBeanFactory autowireCapableBeanFactory;
//重写创建Job任务的实例方法
@Override
protected Object createJobInstance(TriggerFiredBundle bundle) throws Exception {
Object jobInstance = super.createJobInstance(bundle);
//通过以下方式,解决Job任务无法使用Spring中的Bean问题
autowireCapableBeanFactory.autowireBean(jobInstance);
return super.createJobInstance(bundle);
}
}
创建调度器schedule,交给spring进行管理
package com.xzy.quartz02.config;
import com.xzy.quartz02.utils.MyJobFactory;
import org.quartz.Scheduler;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.config.PropertiesFactoryBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.io.ClassPathResource;
import org.springframework.scheduling.quartz.SchedulerFactoryBean;
import java.io.IOException;
import java.util.Properties;
@Configuration
public class QuartzConfiguration {
@Autowired
private MyJobFactory myJobFactory;
//创建调度器工厂
@Bean
public SchedulerFactoryBean schedulerFactoryBean(){
//1.创建SchedulerFactoryBean
//2.加载自定义的quartz.properties配置文件
//3.设置MyJobFactory
SchedulerFactoryBean factoryBean=new SchedulerFactoryBean();
try {
factoryBean.setQuartzProperties(quartzProperties());
factoryBean.setJobFactory(myJobFactory);
return factoryBean;
} catch (IOException e) {
throw new RuntimeException(e);
}
}
@Bean
public Properties quartzProperties() throws IOException {
PropertiesFactoryBean propertiesFactoryBean=new PropertiesFactoryBean();
propertiesFactoryBean.setLocation(new ClassPathResource("/quartz.properties"));
propertiesFactoryBean.afterPropertiesSet();
return propertiesFactoryBean.getObject();
}
@Bean(name="scheduler")
public Scheduler scheduler(){
return schedulerFactoryBean().getScheduler();
}
}
读取数据库来开启定时任务
t_schedule_trigger : 管理具体的任务
t_schedule_trigger——param,管理传递的参数
MyJob
package com.xzy.quartz02.job;
import lombok.extern.slf4j.Slf4j;
import org.quartz.Job;
import org.quartz.JobExecutionContext;
import org.quartz.JobExecutionException;
import org.springframework.stereotype.Component;
import java.util.Date;
@Component
@Slf4j
public class MyJob implements Job {
@Override
public void execute(JobExecutionContext jobExecutionContext) throws JobExecutionException {
System.err.println("MyJob是一个空的任务计划,时间:"+new Date().toLocaleString());
}
}
MyJob1
package com.xzy.quartz02.job;
import lombok.extern.slf4j.Slf4j;
import org.quartz.*;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import java.util.Date;
@Component
@Slf4j
public class MyJob1 implements Job {
// @Autowired
// private ScheduleTriggerParamService scheduleTriggerParamService;
@Override
public void execute(JobExecutionContext jobExecutionContext) throws JobExecutionException {
JobDetail jobDetail =
jobExecutionContext.getJobDetail();
JobDataMap jobDataMap = jobDetail.getJobDataMap();
System.out.println(new Date().toLocaleString()+"-->携带参数个数:"+jobDataMap.size());
}
}
MyJob2
package com.xzy.quartz02.job;
import lombok.extern.slf4j.Slf4j;
import org.quartz.*;
import org.springframework.stereotype.Component;
import java.util.Date;
@Component
@Slf4j
public class MyJob2 implements Job {
@Override
public void execute(JobExecutionContext jobExecutionContext) throws JobExecutionException {
JobDetail jobDetail =
jobExecutionContext.getJobDetail();
JobDataMap jobDataMap = jobDetail.getJobDataMap();
System.out.println(new Date().toLocaleString()+"-->MyJob2参数传递name="+jobDataMap.get("name")+",score="+
jobDataMap.get("score"));
}
}
主要的业务逻辑类,这个类负责控制我们创建的两张中间表和Quartz的内置表中的业务逻辑,比如当我们中间表的状态为0时,我们定时任务就需要停止,那么就需要把内置表中的相关数据删除定时任务才会停止
ScheduleService
package com.xzy.quartz02.service;
import com.xzy.quartz02.entity.ScheduleTrigger;
import org.springframework.stereotype.Repository;
import java.util.List;
@Repository
public interface ScheduleTriggerService {
int deleteByPrimaryKey(Integer id);
int insert(ScheduleTrigger record);
int insertSelective(ScheduleTrigger record);
ScheduleTrigger selectByPrimaryKey(Integer id);
int updateByPrimaryKeySelective(ScheduleTrigger record);
int updateByPrimaryKey(ScheduleTrigger record);
/**
* 查询触发器中包含的所有任务
* @return
*/
List<ScheduleTrigger> queryScheduleTriggerList();
}
ScheduleTriggerServiceImpl
package com.xzy.quartz02.service.impl;
import com.xzy.quartz02.entity.ScheduleTrigger;
import com.xzy.quartz02.entity.ScheduleTriggerParam;
import com.xzy.quartz02.mapper.ScheduleTriggerMapper;
import com.xzy.quartz02.mapper.ScheduleTriggerParamMapper;
import com.xzy.quartz02.service.ScheduleTriggerService;
import org.quartz.*;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.scheduling.annotation.Scheduled;
import org.springframework.stereotype.Service;
import java.util.List;
@Service
public class ScheduleTriggerServiceImpl implements ScheduleTriggerService {
@Autowired
private ScheduleTriggerMapper scheduleTriggerMapper;
@Autowired
private ScheduleTriggerParamMapper scheduleTriggerParamMapper;
@Autowired
private Scheduler scheduler;
@Override
public int deleteByPrimaryKey(Integer id) {
return scheduleTriggerMapper.deleteByPrimaryKey(id);
}
@Override
public int insert(ScheduleTrigger record) {
return scheduleTriggerMapper.insert(record);
}
@Override
public int insertSelective(ScheduleTrigger record) {
return scheduleTriggerMapper.insertSelective(record);
}
@Override
public ScheduleTrigger selectByPrimaryKey(Integer id) {
return scheduleTriggerMapper.selectByPrimaryKey(id);
}
@Override
public int updateByPrimaryKeySelective(ScheduleTrigger record) {
return scheduleTriggerMapper.updateByPrimaryKeySelective(record);
}
@Override
public int updateByPrimaryKey(ScheduleTrigger record) {
return scheduleTriggerMapper.updateByPrimaryKey(record);
}
@Override
public List<ScheduleTrigger> queryScheduleTriggerList() {
return scheduleTriggerMapper.queryScheduleTriggerList();
}
@Scheduled(cron = "0/10 * * * * ?")
public void refreshScheduler(){
try {
List<ScheduleTrigger> scheduleTriggers =
scheduleTriggerMapper.queryScheduleTriggerList();
if(null!=scheduleTriggers){
for (ScheduleTrigger scheduleTrigger : scheduleTriggers) {
String cron = scheduleTrigger.getCron(); //表达式
String jobName = scheduleTrigger.getJob_name(); //任务名称
String jobGroup = scheduleTrigger.getJob_group(); //任务分组
String status = scheduleTrigger.getStatus(); //任务状态
//JobName+JobGroup=Primary Key
//根据jobName和jobGroup生成TriggerKey
TriggerKey triggerKey =
TriggerKey.triggerKey(jobName, jobGroup);
//根据TriggerKey到Scheduler调度器中获取触发器
CronTrigger cronTrigger = (CronTrigger)
scheduler.getTrigger(triggerKey);
if(null==cronTrigger){
// 1是要将自己的业务表的数据同步到quartz内置表钟去
// 0 是 不需要 结束当前循环
if(status.equals("0"))
continue;
System.out.println("创建调度器");
//创建任务详情
JobDetail jobDetail=
JobBuilder.newJob((Class<? extends Job>) Class.forName(jobName))
.withIdentity(jobName,jobGroup)
.build();
//往Job任务中传递参数
JobDataMap jobDataMap = jobDetail.getJobDataMap();
List<ScheduleTriggerParam> params =
scheduleTriggerParamMapper.queryScheduleParamList(scheduleTrigger.getId());
for (ScheduleTriggerParam param : params) {
jobDataMap.put(param.getName(),param.getValue());
}
//创建表达式调度器
CronScheduleBuilder cronSchedule =
CronScheduleBuilder.cronSchedule(cron);
//创建Trigger
cronTrigger=TriggerBuilder.newTrigger()
.withIdentity(jobName,jobGroup)
.withSchedule(cronSchedule)
.build();
//将jobDetail和Trigger注入到scheduler调度器中
scheduler.scheduleJob(jobDetail,cronTrigger);
}else{
//System.out.println("Quartz 调度任务中已存在该任务");
if(status.equals("0")){
JobKey jobKey = JobKey.jobKey(jobName, jobGroup);
scheduler.deleteJob(jobKey);
continue;
}
//调度器中的表达式
String cronExpression =
cronTrigger.getCronExpression();
if(!cron.equals(cronExpression)){
//创建表达式调度器
CronScheduleBuilder cronSchedule =
CronScheduleBuilder.cronSchedule(cron);
//重构
cronTrigger=cronTrigger.getTriggerBuilder()
.withIdentity(triggerKey)
.withSchedule(cronSchedule)
.build();
//刷新调度器
scheduler.rescheduleJob(triggerKey,cronTrigger);
}
}
}
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
QuartzController
package com.xzy.quartz02.controller;
import com.xzy.quartz02.entity.ScheduleTrigger;
import com.xzy.quartz02.service.ScheduleTriggerService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.servlet.ModelAndView;
import java.util.List;
/**
* @author XZY
* @site www.Xzy.com
* @company
* @create 2019-11-15 19:57
*/
@Controller
@RequestMapping("/quartz")
public class QuartzController {
@Autowired
private ScheduleTriggerService scheduleTriggerService;
@RequestMapping("/list")
public ModelAndView getAll(){
ModelAndView mv = new ModelAndView();
List<ScheduleTrigger> list = scheduleTriggerService.queryScheduleTriggerList();
mv.addObject("quartzList",list);
mv.setViewName("list");
return mv;
}
@RequestMapping("/edit")
public String editStatus(ScheduleTrigger scheduleTrigger){
int n = scheduleTriggerService.updateByPrimaryKeySelective(scheduleTrigger);
return "redirect:/quartz/list";
}
@RequestMapping("/proSave/{id}")
public ModelAndView proSave(@PathVariable(value = "id") Integer id){
ModelAndView mv=new ModelAndView();
ScheduleTrigger scheduleTrigger = scheduleTriggerService.selectByPrimaryKey(id);
mv.addObject("schedule",scheduleTrigger);
mv.setViewName("edit");
return mv;
}
}
templates
list.html
<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org">
<head>
<meta charset="UTF-8">
<title>quartz定时任务管理</title>
</head>
<body>
<h1 style="text-align: center">定时任务管理</h1>
<table style="text-align: center" align="center" border="1px" width="50%">
<tr>
<td>任务id</td>
<td>任务表达式</td>
<td>任务状态</td>
<td>job工作类</td>
<td>job分组</td>
<td>操作</td>
</tr>
<tr th:each="q : ${quartzList}">
<td th:text="${q.id}"></td>
<td th:text="${q.cron}"></td>
<td th:text="${q.status}"></td>
<td th:text="${q.job_name}"></td>
<td th:text="${q.job_group}"></td>
<td th:switch ="${q.status} == 0">
<a th:case="true" th:href="@{/quartz/edit(id=${q.id},status=1)}">启动</a>
<a th:case="false" th:href="@{/quartz/edit(id=${q.id},status=0)}">停止</a>
<a th:href="@{'/quartz/proSave/'+${q.id}}">编辑</a>
</td>
</tr>
</table>
</body>
</html>
edit.html
<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org">
<head>
<meta charset="UTF-8">
<title>编辑定时任务</title>
</head>
<body>
<h1>编辑定时任务</h1>
<form th:action="@{/quartz/edit}" method="post">
<input type="hidden" name="id" th:value="${schedule.id}" />
任务表达式: <input width="300px" type="text" name="cron" th:value="${schedule.cron}" /></br>
job工作类: <input width="300px" type="text" name="job_name" th:value="${schedule.job_name}" /></br>
job分组:<input width="300px" type="text" name="job_group" th:value="${schedule.job_group}" /></br>
<input type="submit" value="提交"/>
</form>
</body>
</html>
效果
编辑
点击启动或停止时,自动更新实时状态
over~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~