我的quartz配置文件中连的是数据库,现在我通过程序(JSP页面)可以自由添加任务,代码如下: if(!"".equals(request.getParameter("username")) && null!=request.getParameter("username") && !"".equals(request.getParameter("corn")) && null!=request.getParameter("corn")){
String username = request.getParameter("username");
String corn = request.getParameter("corn");
org.quartz.SchedulerFactory scheduleFactory = new org.quartz.impl.StdSchedulerFactory();
org.quartz.Scheduler scheduler = scheduleFactory.getScheduler();
JobDetail jobDetail = new JobDetail(username.trim(),"Message",MessageJob.class);
org.quartz.CronTrigger newTrigger = new org.quartz.CronTrigger(username.trim(), "Message",corn.trim());
jobDetail.getJobDataMap().put("uname", username.trim());
scheduler.scheduleJob(jobDetail, newTrigger);
}
通过执行完这段代码后,数据中相应的表中有数据,可是我现在用JDBC连的数据库,通过SQL语句往数据库里写任务,任务和触发器都可以正常被写入,可是jobDetail.getJobDataMap().put("uname", username.trim());
如果换成SQL语句该怎么写呢?我找不到有哪个表是存jobDataMap数据的,前辈请指点。
String username = request.getParameter("username");
String corn = request.getParameter("corn");
org.quartz.SchedulerFactory scheduleFactory = new org.quartz.impl.StdSchedulerFactory();
org.quartz.Scheduler scheduler = scheduleFactory.getScheduler();
JobDetail jobDetail = new JobDetail(username.trim(),"Message",MessageJob.class);
org.quartz.CronTrigger newTrigger = new org.quartz.CronTrigger(username.trim(), "Message",corn.trim());
jobDetail.getJobDataMap().put("uname", username.trim());
scheduler.scheduleJob(jobDetail, newTrigger);
}
通过执行完这段代码后,数据中相应的表中有数据,可是我现在用JDBC连的数据库,通过SQL语句往数据库里写任务,任务和触发器都可以正常被写入,可是jobDetail.getJobDataMap().put("uname", username.trim());
如果换成SQL语句该怎么写呢?我找不到有哪个表是存jobDataMap数据的,前辈请指点。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货