SpringBoot 整合Quartz扩展数据源Druid

引入依赖

	<dependency>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-quartz</artifactId>
	</dependency>

配置Quartz

import org.springframework.boot.autoconfigure.quartz.SchedulerFactoryBeanCustomizer;
import org.springframework.context.annotation.Configuration;
import org.springframework.scheduling.quartz.SchedulerFactoryBean;

/**
 * Quartz配置类
 * @ClassName DruidPooling_connectionProvider
 * @Description TODO
 * @Author loukaikai
 * @Data 2020/4/2
 **/
@Configuration
public class SchedulerConfig implements SchedulerFactoryBeanCustomizer {
   

    @Override
    public void customize(SchedulerFactoryBean schedulerFactoryBean) {
   
        schedulerFactoryBean.setStartupDelay(2);
        schedulerFactoryBean.setAutoStartup(true);
        schedulerFactoryBean.setOverwriteExistingJobs(true);
    }
}

修改默认的连接池

Quartz默认的连接池是c3po,要使用druid需要修改进行扩展，同时需要将扩展的类写到quartz.perproties文件

import com.alibaba.druid.pool.DruidDataSource;
import lombok.Data;
import lombok.SneakyThrows;
import org.quartz.SchedulerException;
import org.quartz.utils.ConnectionProvider;

import java.sql.Connection;
import java.sql.SQLException;

/**
 * [Druid连接池的Quartz扩展类]
 * @ClassName DruidPooling_connectionProvider
 * @Description TODO
 * @Author loukaikai
 * @Data 2020/4/2
 **/
@Data
public class DruidPoolingconnectionProvider