Etl工具-kettle-spoon

import java.io.DataOutputStream;
import java.io.File;
import java.io.FileOutputStream;

import org.pentaho.di.core.Const;
import org.pentaho.di.core.NotePadmeta;
import org.pentaho.di.core.database.Database;
import org.pentaho.di.core.database.Databasemeta;
import org.pentaho.di.core.exception.KettleException;
import org.pentaho.di.core.logging.LogWriter;
import org.pentaho.di.core.util.EnvUtil;
import org.pentaho.di.trans.StepLoader;
import org.pentaho.di.trans.Trans;
import org.pentaho.di.trans.TransHopmeta;
import org.pentaho.di.trans.Transmeta;
import org.pentaho.di.trans.step.Stepmeta;
import org.pentaho.di.trans.step.StepmetaInterface;
import org.pentaho.di.trans.steps.selectvalues.SelectValuesmeta;
import org.pentaho.di.trans.steps.tableinput.TableInputmeta;
import org.pentaho.di.trans.steps.tableoutput.TableOutputmeta;



/**
 * Class created to demonstrate the creation of transformations on-the-fly.
 * 
 * @author Matt
 * 
 */
public class TransBuilder
{
    public static final String[] databasesxml = {
        “l version=“1.0“ encoding=“UTF-8“?>“ +
        ““ +
            “target“ +
            “localhost“ +
            “MSSQL“ +
            “Native“ +
            “se>testse>“ +
            “1433“ +
            “matt“ +
            “abcd“ +
          ““
          
          “l version=“1.0“ encoding=“UTF-8“?>“ +
          ““ +
              “source“ +
              “localhost“ +
              “MYSQL“ +
              “Native“ +
              “se>testse>“ +
              “3306“ +
              “matt“ +
              “abcd“ +
            ““  
    };

    /**
     * Creates a new Transformation using input parameters such as the tablename to read from.
     * @param transformationName The name of the transformation
     * @param sourceDatabaseName The name of the database to read from
     * @param sourceTableName The name of the table to read from
     * @param sourceFields The field names we want to read from the source table
     * @param targetDatabaseName The name of the target database
     * @param targetTableName The name of the target table we want to write to
     * @param targetFields The names of the fields in the target table （same number of fields as sourceFields）
     * @return A new transformation
     * @throws KettleException In the rare case something goes wrong
     */
    public static final Transmeta buildCopyTable（String transformationName String sourceDatabaseName String sourceTableName String[] sourceFields String targetDatabaseName String targetTableName String[] targetFields） throws KettleException
    {
        En

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2009-05-12 13:51  data-integration
     文件         479  2009-05-12 12:49  data-integrationKettle.l4j.ini
     目录           0  2009-05-12 12:50  data-integrationextra
     文件        2562  2009-05-12 12:50  data-integrationextraTransBuilder.bat
     文件       10734  2009-05-12 12:50  data-integrationextraTransBuilder.java
     文件        6463  2009-05-12 12:50  data-integrationextraTransBuilderFilter.java
     文件        1883  2009-05-12 12:49  data-integrationkitchen.sh
     文件        2661  2009-05-12 12:49  data-integrationspoon.png
     文件        2589  2009-05-12 12:49  data-integrationPan.bat
     文件         341  2009-05-12 12:49  data-integrationREADME_UNIX_AS400.txt
     文件        4286  2009-05-12 12:49  data-integrationspoon.ico
     文件        2890  2009-05-12 12:49  data-integrationCarte.bat
     目录           0  2009-05-12 12:49  data-integrationsimple-jndi
     文件         697  2009-05-12 12:49  data-integrationsimple-jndijdbc.properties
     文件        1873  2009-05-12 12:49  data-integrationEncr.bat
     文件         988  2009-05-12 12:49  data-integrationencr.sh
     目录           0  2009-05-12 12:49  data-integrationdocs
     目录           0  2009-05-12 12:49  data-integrationdocsNederlands
     目录           0  2009-05-12 12:49  data-integrationdocsNederlandswelcome
     目录           0  2009-05-12 12:49  data-integrationdocsNederlandswelcomeimages
     文件        6325  2009-05-12 12:49  data-integrationdocsNederlandswelcomeimagesg_banner.png
     文件         203  2009-05-12 12:49  data-integrationdocsNederlandswelcomeimagesullet_green.png
     文件        3230  2009-05-12 12:49  data-integrationdocsNederlandswelcomeimagespentaho_logo.png
     文件        1173  2009-05-12 12:49  data-integrationdocsNederlandswelcomeimagesstyles-new.css
     文件        4794  2009-05-12 12:49  data-integrationdocsNederlandswelcomekettle_document_map.html
     目录           0  2009-05-12 12:49  data-integrationdocsit_IT
     目录           0  2009-05-12 12:49  data-integrationdocsit_ITwelcome
     目录           0  2009-05-12 12:49  data-integrationdocsit_ITwelcomeimages
     文件        6325  2009-05-12 12:49  data-integrationdocsit_ITwelcomeimagesg_banner.png
     文件         203  2009-05-12 12:49  data-integrationdocsit_ITwelcomeimagesullet_green.png
     文件        3230  2009-05-12 12:49  data-integrationdocsit_ITwelcomeimagespentaho_logo.png
............此处省略4420个文件信息