JAVA调用ETL批处理指令
常量类

帮助类

日志输出类

package common.shell;import java.util.HashMap;import java.util.Map;/** * <p>类的描述：</p> * @author gao.tang * @version 1.0 * @date 2011-6-2 上午10:13:52 */public class ShellBusinessOp {/** * 删除核销记录数据 * @param annual * @param payId * @return */public synchronized static boolean executeDelHxjl(String annual,String[] pay_id){int state = -1;if(pay_id != null && pay_id.length > 0){StringBuilder payId = new StringBuilder();for(String payid : pay_id){payId.append("'").append(payid).append("',");}Map<String,String> params = new HashMap<String,String>();params.put("annual", annual);params.put("pay_id", payId.substring(0, payId.length() - 1));state = ShellUtil.getInstance().executeTran("/工资自动生成支付", "删除核销记录", params);}return state == 0;}/** * 自动生成工资支付数据 * @return */public synchronized static boolean executeWageAutoPay(){int state = -1;state = ShellUtil.getInstance().executeJob("/工资自动生成支付", "工资支付接口", null);return state == 0; }/** * 未核工资数据更新 * @return */public synchronized static boolean executeUpdateWage(){int state = -1;state = ShellUtil.getInstance().executeJob("/工资自动生成支付", "工资视图删除更新", null);return state == 0;}/** * 同步单位人员数据到表TB_DEPT_PEOPLENUM * @return */public synchronized static boolean executePeopleNum(){int state = -1;state = ShellUtil.getInstance().executeTran("/工资自动生成支付", "单位人口数据抽取", null);return state == 0;}/** * 同步更新工资统发部门工资统计表 * @return */public synchronized static boolean executeStatictsData(){int state = -1;state = ShellUtil.getInstance().executeTran("/工资自动生成支付", "获取工资统计数据接口", null);return state == 0;}}