quartz动态定时任务在执行时是以线程的形式在后台定期执行,Mybatis链接数据库基于spring框架运行,如果想要通过在quartz中借助mybatis操作数据库需要进行如下配置:
工具类:
package com.skyinfo.report.web.quarz.utils;
import org.springframework.beans.BeansException;
import org.springframework.context.ApplicationContext;
import org.springframework.context.ApplicationContextAware;
import org.springframework.stereotype.Component;
/**
* quarz 实现mybatis bean
* @author wb
*/
@Component
public class SpringUtil implements ApplicationContextAware {
private static ApplicationContext applicationContext;
@Override
public void setApplicationContext(ApplicationContext applicationContext) throws BeansException {
if(SpringUtil.applicationContext == null) {
SpringUtil.applicationContext = applicationContext;
}
}
//获取applicationContext
public static ApplicationContext getApplicationContext(){
return applicationContext;
}
//通过name获取 Bean.
public static Object getBean(String name){
return getApplicationContext().getBean(name);
}
//通过class获取Bean.
public static <T> T getBean(Class<T> clazz){
return getApplicationContext().getBean(clazz);
}
//通过name,以及Clazz返回指定的Bean
public static <T> T getBean(String name,Class<T> clazz){
return getApplicationContext().getBean(name, clazz);
}
}
quartz中job借助mybatis操作数据库
public class JtsjRyzpxxRunJob implements Job {
private JdbcConnectService jdbcConnectService;
public void execute(JobExecutionContext context) {
JobDataMap jobDataMap = context.getMergedJobDataMap();
String rwbh = jobDataMap.getString("rwbh");
JobManagerService jobManagerService = null;
//将需要操作的service从bean中取出注入到线程中使用
jobManagerService = SpringUtil.getBean(JobManagerService.class);
}
}
借助工具类实现ApplicationContextAware 接口,重写方法可以将service注入到Job中,并借助service操作数据库