kettle調用自定義java類

1.kettle既然可以調用java.sql的檔案，自然也可以調用自己寫的類，不知道為什麼，将用myeclipse生成的jar包放在libswt檔案夾下，在java腳本中導入不了，最後放入lib檔案夾下才成功。

java代碼：

package dbConn;
import java.sql.*;
public class db {
    String driverName ="com.microsoft.sqlserver.jdbc.SQLServerDriver";
    String urlString = "jdbc:sqlserver://localhost:1433;DatabaseName=teswt";;
    String usernameString = "sa";
    String passwString = "123";
    String connectResultString = "";

    public Connection  dbconn(){
        try {
            Class.forName(driverName);
            Connection dbconConnection  = DriverManager.getConnection(urlString,usernameString,passwString);
            connectResultString = "連接配接成功";
        return dbconConnection;

        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return null;
    }





    public String getDriverName() {
        return driverName;
    }
    public void setDriverName(String driverName) {
        this.driverName = driverName;
    }
    public String getUrlString() {
        return urlString;
    }
    public void setUrlString(String urlString) {
        this.urlString = urlString;
    }
    public String getUsernameString() {
        return usernameString;
    }
    public void setUsernameString(String usernameString) {
        this.usernameString = usernameString;
    }
    public String getPasswString() {
        return passwString;
    }
    public void setPasswString(String passwString) {
        this.passwString = passwString;
    }
    public String getConnectResultString() {
        return connectResultString;
    }
    public void setConnectResultString(String connectResultString) {
        this.connectResultString = connectResultString;
    }


}
           

這裡的代碼隻是寫個連接配接上資料庫的測試結果，然後通過kettle調用後輸出出來。

2.既然java腳本可以調用java類，js為什麼不可以呢？js自然也可以

//Script here

var re= new Packages.dbConn.db();
re.dbconn();
var s = re.getConnectResultString();