[ rubbish-db ]
RubbishDatabase dbh = new RubbishDatabase(); dbh.setLogging(true); dbh.connect("jdbc:hsqldb:hsql://localhost", "sa", ""); Map[] publishers = dbh.query("SELECT * FROM PUBLISHER ORDER BY ID", 2, 3); for (int i = 0; i < publishers.length; i++) println(publishers[i]); dbh.disconnect();
connect database 'url=jdbc:hsqldb:hsql://localhost, user=sa, password='. 'SELECT * FROM PUBLISHER ORDER BY ID' (start=2, lines=3) {ID=02, NAME=時源出版, VOLUMES=4, UPDATE_DATE=2005-07-10 17:10:00.000, CREATE_DATE=1999-07-10 17:10:00.000} {ID=03, NAME=曙蓬莱新聞社, VOLUMES=4, UPDATE_DATE=2005-07-10 17:10:00.000, CREATE_DATE=1999-07-10 17:10:00.000} {ID=04, NAME=太公望書林, VOLUMES=12, UPDATE_DATE=2005-07-10 17:10:00.000, CREATE_DATE=1999-07-10 17:10:00.000} disconnect database.