SQL Extension

SQL Extension

Provides database connectivity. Access via SQL namespace.

Usage

connId = SQL.connect("org.h2.Driver", "jdbc:h2:mem:test", "sa", "");
conn = Connection(connId);

conn.update("CREATE TABLE Users (ID INT, Name VARCHAR(50))");
conn.update("INSERT INTO Users VALUES (1, 'Alice')");

rsId = conn.query("SELECT * FROM Users");
rs = ResultSet(rsId);

while (rs.next()) {
    print(rs.getInt("ID") + ": " + rs.getString("Name"));
}

rs.close();
conn.close();