首先看job ,那么要想传递参数就要先明白kettle job里面三个参数 位置参数 命名参数 变量都代表什么意思。
请看这篇文章:https://blog.csdn.net/kerafan/article/details/86617830
看完上面的文章,job端基本就可以完成了。
参照这四张图
java端代码:
/**
* 测试runJobWithParameter.
*/
@Test
public void testRunJobWithParameter() {
String kjbPath = "job的路径 这里";
Map<String, String> map = new HashMap<>();
map.put("id", "1");
map.put("userName", "'123'");
try {
KettleUtils.runJobWithParameter(map, kjbPath);
} catch (Exception e) {
String msg = "执行带参数的job出现错误" + e.getMessage();
log.error(msg, e);
}
}
/**
* 运行 job(有参数).
* @param map job需要的数据,key为参数,value为值
* @param kjbPath job 路径
* @throws Exception 异常
*/
public static void runJobWithParameter(Map<String, String> map, String kjbPath) throws Exception {
KettleEnvironment.init();
JobMeta jobMeta = new JobMeta(kjbPath, null);
Job job = new Job(null, jobMeta);
for (String key : map.keySet()) {
String value = map.get(key);
job.setVariable(key, value);
}
job.start();
job.waitUntilFinished();
if (job.getErrors() > 0) {
throw new RuntimeException("在job【" + job.getJobname() + "】执行过程中出现错误");
} else {
log.info("job【" + job.getJobname() + "】执行成功!");
}
}
/**
* 日志.
*/
private static Logger log = LoggerFactory.getLogger(KettleUtils.class);
ok