How can I get the quartz cron trigger from a mysql database in java code?

0

I have an application in which I use Quartz and I store the information of the triggers in mysql, but to set the parameters of the trigger I want to get the information from the base so as not to have hardcoding in my java code, could someone tell me how to do it.

package quartz;

import java.io.IOException;
import java.util.Properties;
import org.quartz.CronScheduleBuilder;
import org.quartz.CronTrigger;
import org.quartz.JobBuilder;
import org.quartz.JobDetail;
import org.quartz.JobKey;
import org.quartz.Scheduler;
import org.quartz.SchedulerException;
import org.quartz.SchedulerFactory;
import org.quartz.SimpleScheduleBuilder;

import org.quartz.Trigger;
import org.quartz.TriggerBuilder;

import org.quartz.TriggerKey;
import org.quartz.impl.StdSchedulerFactory;

public class QuartzScheduler
{

    public static void main(String[] args) throws ClassNotFoundException,IOException, SchedulerException
    {

        Properties prop=new Properties();
        prop.load(QuartzScheduler.class.getResourceAsStream("quartz.properties"));

        SchedulerFactory sch=new StdSchedulerFactory(prop);
        Scheduler scheduler=sch.getScheduler();
        scheduler.start();

        JobDetail job=JobBuilder.newJob(TestJob.class).withIdentity("test","test").build();

        //Trigger trig=TriggerBuilder.newTrigger().withIdentity("test","test").withSchedule(SimpleScheduleBuilder.simpleSchedule().withIntervalInSeconds(1).repeatForever()).build();

        CronTrigger trig=TriggerBuilder.newTrigger().withIdentity("test","test").withSchedule(CronScheduleBuilder.cronSchedule("0/10 * * * * ?")).build();
        JobKey jobk=JobKey.jobKey("test","test"); 

        scheduler.deleteJob(jobk);
        scheduler.scheduleJob(job,trig);
    }
}
    
asked by rogeliofca 11.04.2018 в 18:10
source

0 answers