rubbish-db / チュートリアル / １件のレコードをMapとして取得する

[ rubbish-db ]

ソース

RubbishDatabase dbh = new RubbishDatabase();
dbh.setLogging(true);

dbh.connect("jdbc:hsqldb:hsql://localhost", "sa", "");

Map book = dbh.getRow("SELECT TITLE, AUTHOR FROM BOOK WHERE PUBLISHER=? AND ID=?", "06", "000");
println(book);

dbh.disconnect();

結果

connect database 'url=jdbc:hsqldb:hsql://localhost, user=sa, password='.
'SELECT TITLE, AUTHOR FROM BOOK WHERE PUBLISHER=? AND ID=? [06, 000]'
{TITLE=EYEこそ全て, AUTHOR=null}
disconnect database.