Kettle ETL如何调用 java代码来进行数据库的增删改查

[c72153770z]

如题，最好能给个例子，不胜感激。

[tianfang]

kettle自己就可以做CRDU 为什么调java做？ kettle中的java是做数据处理的 不是做数据库操作的

[冰心的小屋]

// Generate the transformation.
TransMeta transMeta = TransBuilder.buildCopyTable(
   transformationName,
   sourceDatabaseName,
   sourceTableName,
   sourceFields,
   targetDatabaseName,
   targetTableName,
   targetFields
   );

// Save it as a file:
String xml = transMeta.getXML();
DataOutputStream dos = new DataOutputStream(new FileOutputStream(new File(fileName)));
dos.write(xml.getBytes("UTF-8"));
dos.close();
System.out.println("Saved transformation to file: "+fileName);

// OK, What's the SQL we need to execute to generate the target table?
String sql = transMeta.getSQLStatementsString();

// Execute the SQL on the target table:
Database targetDatabase = new Database(transMeta.findDatabase(targetDatabaseName));
targetDatabase.connect();
targetDatabase.execStatements(sql);

// Now execute the transformation...
Trans trans = new Trans(transMeta);
trans.execute(null);
trans.waitUntilFinished();

// For testing/repeatability, we drop the target table again
targetDatabase.execStatement("drop table "+targetTableName);
targetDatabase.disconnect();

官网上的例子：http://wiki.pentaho.com/display/EAI/Pentaho+Data+Integration+-+Java+API+Examples 欢迎光临我的博客 http://happyshome.cn