KETTLE+JAVA+API+开发实战记录

import be.ibridge.kettle.core.NotePadMeta;

import be.ibridge.kettle.core.database.Database;

import be.ibridge.kettle.core.database.DatabaseMeta;

import be.ibridge.kettle.core.exception.KettleException;

import be.ibridge.kettle.core.util.EnvUtil;

import be.ibridge.kettle.trans.StepLoader;

import be.ibridge.kettle.trans.Trans;

import be.ibridge.kettle.trans.TransHopMeta;

import be.ibridge.kettle.trans.TransMeta;

import be.ibridge.kettle.trans.step.StepMeta;

import be.ibridge.kettle.trans.step.StepMetaInterface;

import be.ibridge.kettle.trans.step.selectvalues.SelectValuesMeta;

import be.ibridge.kettle.trans.step.tableinput.TableInputMeta;

import be.ibridge.kettle.trans.step.tableoutput.TableOutputMeta;

//这个包被遗漏了，原始位置kettle根目录\\libswt\\win32\\swt.jar

//add by chq([link=http://www.chq.name]www.chq.name[/link]) on 2006.07.20

//import org.eclipse.swt.dnd.Transfer; /**

* Class created to demonstrate the creation of transformations on-the-fly.

*

* @author Matt * */

public class TransBuilder {

public static final String[] databasesXML = {

\

\

\

\

\

\

\

\

\

\

\

\

\

\

\e>\

\>\

\

\

\

\

\

\

\

\

\

\

\

\

\

\

\

\

\

\e>\

\>\

\

\

\

}; //

// create the source step...

//

String fromstepname = \

TableInputMeta tii = new TableInputMeta();

tii.setDatabaseMeta(sourceDBInfo);

String selectSQL = \

for (int i=0;i

{

/* modi by chq(www.chq.name): use * to replace the fields,经分析,以下语句可以处理‘*‘ */

if (i>0)

selectSQL+=\