kettle循环执行作业中结果集中数据获取

1.JavaScript 

1. var prevRow=previous_result.getRows(); //获取上一个传递的结果,数据库中查询的结果集
2. if (prevRow == null &&(prevRow.size()= 0))
3. {
4. false;
6. } else{
7. parent_job.setVariable( "tables", prevRow); //ArrayList存储表名变量，以数组形式保存入table1，table2
8. parent_job.setVariable( "size", prevRow.size()); //存储执行表的总数量
9. parent_job.setVariable( "i", new Number( 0)); //循环控制变量
10. parent_job.setVariable( "k", 0);
12. parent_job.setVariable( "id", prevRow.get( 0).getString( "hosp", "hosp")); //根据字段名获取值
13. parent_job.setVariable( "hospname", prevRow.get( 0).getString( "hospname", "hospname"));
14. true;
15. }

2.JavaScript2

1. var prevRow=previous_result.getRows();
2. var size = new Number(parent_job.getVariable( "size"));
3. var i = new Number(parent_job.getVariable( "i"))+ 1;
8. if(i<size){
9. parent_job.setVariable( "id",prevRow.get(i).getString( "hosp", "hosp"));
10. parent_job.setVariable( "hospname",prevRow.get(i).getString( "hospname", "hospname"));
11. }
12. parent_job.setVariable( "i",i);
14. true;

3.循环停止条件，

4.数据库结果集查询