发布时间 : 星期六 文章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+=\