好的，我了解了你的问题。要使用
Quartz2.3.2和
Spring Boot实现数据库
持久化存储多个定时
任务，你可以按照以下步骤操作：
1. 在
Spring Boot项目中添加
Quartz2.3.2的依赖包：
```xml
<dependency>
<groupId>
org.
quartz-scheduler</groupId>
<artifactId>
quartz</artifactId>
<version>2.3.2</version>
</dependency>
```
2. 创建一个继承了`
org.
quartz.impl.jdbc
jobstore.PostgreSQLDelegate`的类，用于实现PostgreSQL数据库的存储。
```
java
public class PostgreSQLDelegateCustom extends PostgreSQLDelegate {
private String tablePrefix = "";
public PostgreSQLDelegateCustom() {
super();
}
@Override
public void setInstanceName(String schedName) {
super.setInstanceName(schedName);
this.tablePrefix = schedName + ".";
}
@Override
public String getSelectNextTriggerToAcquireSql(int maxCount) {
return "SELECT * FROM " + tablePrefix + "QRTZ_TRIGGERS WHERE " + "TRIGGER_STATE = ? AND NEXT_FIRE_TIME <= ? " + "AND MISFIRE_INSTR IN (" + MisfireInstruction.IGNORE_MISFIRE_POLICY + "," + MisfireInstruction.SMART_POLICY + ") ORDER BY NEXT_FIRE_TIME ASC";
}
@Override
public String getSelectNextMisfiredTriggersInStateSql(Connection conn, String state, long ts) {
return "SELECT * FROM " + tablePrefix + "QRTZ_TRIGGERS WHERE " + "TRIGGER_STATE = ? AND NEXT_FIRE_TIME <= ? " + "AND MISFIRE_INSTR NOT IN (" + MisfireInstruction.IGNORE_MISFIRE_POLICY + "," + MisfireInstruction.SMART_POLICY + ") ORDER BY NEXT_FIRE_TIME ASC";
}
@Override
public String getSelectPausedTriggerGroupsSql() {
return "SELECT TRIGGER_GROUP FROM " + tablePrefix + "QRTZ_PAUSED_TRIGGER_GRPS";
}
@Override
public String getSelectPausedTriggerGroupsLikeSql() {
return "SELECT TRIGGER_GROUP FROM " + tablePrefix + "QRTZ_PAUSED_TRIGGER_GRPS WHERE TRIGGER_GROUP LIKE ?";
}
@Override
public String getSelectFiredTriggersSql(int limit) {
return "SELECT * FROM " + tablePrefix + "QRTZ_FIRED_TRIGGERS ORDER BY FIRE_TIME ASC LIMIT " + limit;
}
@Override
public String getSelectFiredTriggerSql() {
return "SELECT * FROM " + tablePrefix + "QRTZ_FIRED_TRIGGERS WHERE ENTRY_ID = ?";
}
@Override
public String getInsertPausedTriggerGroupSql() {
return "INSERT INTO " + tablePrefix + "QRTZ_PAUSED_TRIGGER_GRPS (TRIGGER_GROUP) VALUES (?)";
}
@Override
public String getDeletePausedTriggerGroupSql() {
return "DELETE FROM " + tablePrefix + "QRTZ_PAUSED_TRIGGER_GRPS WHERE TRIGGER_GROUP = ?";
}
@Override
public String getDeleteAllPausedTriggerGroupsSql() {
return "DELETE FROM " + tablePrefix + "QRTZ_PAUSED_TRIGGER_GRPS";
}
@Override
public String getInsertFiredTriggerSql() {
return "INSERT INTO " + tablePrefix + "QRTZ_FIRED_TRIGGERS (ENTRY_ID, " + "TRIGGER_NAME, TRIGGER_GROUP, " + "IS_VOLATILE, INSTANCE_NAME, " + "FIRED_TIME, SCHED_TIME, " + "PRIORITY, STATE, JOB_NAME, " + "JOB_GROUP, IS_STATEFUL, " + "REQUESTS_RECOVERY, " + "MISFIRE_INSTR) " + "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
}
@Override
public String getUpdateFiredTriggerSql() {
return "UPDATE " + tablePrefix + "QRTZ_FIRED_TRIGGERS SET " + "FIRED_TIME = ?, SCHED_TIME = ?, STATE = ? " + "WHERE ENTRY_ID = ?";
}
@Override
public String getDeleteFiredTriggerSql() {
return "DELETE FROM " + tablePrefix + "QRTZ_FIRED_TRIGGERS WHERE ENTRY_ID = ?";
}
@Override
public String getDeleteFiredTriggersSql(String instanceId) {
return "DELETE FROM " + tablePrefix + "QRTZ_FIRED_TRIGGERS WHERE INSTANCE_NAME = ?";
}
@Override
public String getSelectInstancesFiredTriggerCountSql() {
return "SELECT COUNT(*) FROM " + tablePrefix + "QRTZ_FIRED_TRIGGERS WHERE INSTANCE_NAME = ?";
}
}
```
3. 在
Spring Boot配置文件中配置
Quartz的相关参数：
```yaml
spring:
quartz:
job-s
tore-type: jdbc
properties:
org:
quartz:
scheduler:
instanceId: AUTO
instanceName: my-scheduler
jobStore:
driverDelegateClass: com.example.PostgreSQLDelegateCustom
useProperties: false
isClustered: false
dataSource: my
DataSource
tablePrefix: QRTZ_
threadPool:
threadCount: 10
plugin:
shutdownhook:
class:
org.
quartz.plugins.management.ShutdownHookPlugin
cleanShutdown: true
jobHis
tory:
class:
org.
quartz.plugins.his
tory.LoggingJobHis
toryPlugin
jobHis
toryLogLevel: INFO
```
4. 创建一个继承了`
org.
quartz.Job`的类，用于定义
任务的具体逻辑：
```
java
public class MyJob implements Job {
@Override
public void execute(JobExecutionContext context) throws JobExecutionException {
//
任务逻辑代码
}
}
```
5. 在
Spring Boot的任意一个类中添加以下代码，用于配置和启动
Quartz Scheduler：
```
java
@Configuration
public class
QuartzConfig {
@Bean
public JobDetail myJobDetail() {
return JobBuilder.newJob(MyJob.class)
.withIdentity("myJob")
.s
toreDurably()
.build();
}
@Bean
public Trigger myTrigger() {
return TriggerBuilder.newTrigger()
.forJob(myJobDetail())
.withIdentity("myTrigger")
.withSchedule(CronScheduleBuilder.cronSchedule("0/5 * * * * ?"))
.build();
}
@Bean
public SchedulerFac
toryBean schedulerFac
toryBean(
DataSource dataSource) {
SchedulerFac
toryBean schedulerFac
toryBean = new SchedulerFac
toryBean();
schedulerFac
toryBean.set
DataSource(
dataSource);
schedulerFac
toryBean.setJobDetails(myJobDetail());
schedulerFac
toryBean.setTriggers(myTrigger());
return schedulerFac
toryBean;
}
}
```
6. 最后，你需要在PostgreSQL数据库中创建
Quartz所需的表结构。你可以使用
Quartz提供的`tables_postgres.sql`文件进行创建。
至此，你已经成功实现了使用
Quartz2.3.2和
Spring Boot实现数据库
持久化存储多个定时
任务。
413
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
