Orange Script 通过JDBC连接数据库的例子

详细代码，请看这里

var conn = $.java.sql.DriverManager.getConnection("jdbc:mysql://localhost/test", "root", "");

var dropTable = function() {
    var stmt = conn.createStatement();
    stmt.execute("DROP TABLE IF EXISTS foo");
    stmt.close();
};

var createTable = function() {
    var stmt = conn.createStatement();
    stmt.execute("CREATE TABLE foo (city VARCHAR(30), state VARCHAR(2), population INT)");
    stmt.close();
};

var filldata = function(city, state, population) {
    var stmt = conn.prepareStatement("INSERT INTO foo(city, state, population) VALUES (?,?,?)");
    stmt.setString(1, city);
    stmt.setString(2, state);
    stmt.setInt(3, population);
    stmt.executeUpdate();
    stmt.close();
};