1.远程数据库链接(这次是获取vpn连接)
2.编辑数据源:
3.新建空项目(我这里是复制之前的项目,保留了配置,只改了配置项目名字,删除了多余的文件,新建了定时任务路径,规范起名)
3.测试能否成功查询客户数据库数据:
a:
package com.interfaces.zhujs.qc34324307.cronJob;
import com.alibaba.fastjson.JSONObject;
import com.interfaces.zhujs.util.LogUtil;
import weaver.conn.RecordSetDataSource;
import weaver.general.BaseBean;
import weaver.interfaces.schedule.BaseCronJob;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.ws.rs.GET;
import javax.ws.rs.Path;
import javax.ws.rs.Produces;
import javax.ws.rs.core.Context;
import javax.ws.rs.core.MediaType;
import java.util.HashMap;
import java.util.Map;
public class RegularlyPullCustomerData extends BaseCronJob {
private static LogUtil logger = new LogUtil(RegularlyPullCustomerData.class);
private String outSource;
//计划任务执行
@Override
public void execute() {
RecordSetDataSource rsd = new RecordSetDataSource(getOutSource());
String sql = " select count(1) as num from MDM_ACCOUNT_COST";
rsd.execute(sql);
while (rsd.next()){
String num = rsd.getString("num");
}
logger.writeLog("=============定时任务执行========");
}
public String getOutSource() {
return outSource;
}
public void setOutSource(String outSource) {
this.outSource = outSource;
}
}
b.打包部署项目:
启动项目: