kettle调用java代码处理数据
来源:互联网 发布:淘宝男士摩登舞服装 编辑:程序博客网 时间:2024/05/21 23:14
1.新建Java测试类,导出Jar包,放在kettle目录中的libext文件中
package test;
public class Test{
public static final String getMyName(String name){
return name+"12345";
}
}
2.抽数据--经过java处理--输出文件到桌面
import test.Test;
public boolean processRow(StepMetaInterface smi, StepDataInterface sdi) throws KettleException
{
Object[] r = getRow();
if (r == null) {
setOutputDone();
return false;
}
if (first)
{
first = false;
}
// It is always safest to call createOutputRow() to ensure that your output row's Object[] is large
// enough to handle any new fields you are creating in this step.
//r = createOutputRow(r, outputRowSize);
/* TODO: Your code here. (See Sample)
/ Get the value from an input field
String foobar = get(Fields.In, "a_fieldname").getString(r);
foobar += "bar";
// Set a value in a new output field
get(Fields.Out, "output_fieldname").setValue(r, foobar);
*/
//调用jar
String foobar = get(Fields.In, "ENAME").getString(r); //输入参数
foobar += Test.getMyName("我是谁的水");
get(Fields.Out, "ENAME").setValue(r, foobar);
//获取参数
String AGEField = getParameter("AGE");
get(Fields.Out, "AGE").setValue(r, AGEField); //输出参数
// Send the row on to the next step.
putRow(data.outputRowMeta, r);
return true;
}
package test;
public class Test{
public static final String getMyName(String name){
return name+"12345";
}
}
2.抽数据--经过java处理--输出文件到桌面
import test.Test;
public boolean processRow(StepMetaInterface smi, StepDataInterface sdi) throws KettleException
{
Object[] r = getRow();
if (r == null) {
setOutputDone();
return false;
}
if (first)
{
first = false;
}
// It is always safest to call createOutputRow() to ensure that your output row's Object[] is large
// enough to handle any new fields you are creating in this step.
//r = createOutputRow(r, outputRowSize);
/* TODO: Your code here. (See Sample)
/ Get the value from an input field
String foobar = get(Fields.In, "a_fieldname").getString(r);
foobar += "bar";
// Set a value in a new output field
get(Fields.Out, "output_fieldname").setValue(r, foobar);
*/
//调用jar
String foobar = get(Fields.In, "ENAME").getString(r); //输入参数
foobar += Test.getMyName("我是谁的水");
get(Fields.Out, "ENAME").setValue(r, foobar);
//获取参数
String AGEField = getParameter("AGE");
get(Fields.Out, "AGE").setValue(r, AGEField); //输出参数
// Send the row on to the next step.
putRow(data.outputRowMeta, r);
return true;
}
阅读全文
0 0
- kettle调用java代码处理数据
- kettle+java代码调用Webservice
- kettle 中Modified Java Script Value插件调用java代码
- Kettle java调用
- java调用Kettle总结
- Kettle java调用
- 通过java代码来调用kettle的简单实现
- Java调用ETL工具Kettle
- kettle中调用java类
- java调用spoon kettle API
- java调用kettle工具类
- kettle调用自定义java类
- kettle ETL java 调用 kettle job 或 transfer
- kettle ETL java 调用 kettle job 或 transfer
- kettle进行数据的简单处理
- kettle 里用js 调用java类
- java中调用kettle转换文件
- java中调用kettle转换文件
- UVA 10603 Fill(状态空间搜索,倒水问题)
- Linux服务器风险检测与安全加固
- 剑指Offer_面试题21_包含min函数的栈
- 【2017多校 #Round 4 T7】【HDU6073】Matching In Multiplication
- Window 同时安装Python2和Python3 终极版
- kettle调用java代码处理数据
- 使用C++访问OPC Server的简单方法
- Java并发编程:线程池的使用
- unix编程哲学
- 8.4 树----数据结构与算法
- 有序链表拼接
- CentOS7,安装Tomcat8.5、JDK1.8,并设置开机启动(Linux CentOS Tomcat、JDK+Tomcat、Tomcat开机自启动)
- MySQL某表崩溃问题
- Ubuntu14安装之后不能上网的解决办法