[ rubbish-db ]

ソース

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

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

Statement pst = new Statement("SELECT ID, NAME FROM PUBLISHER WHERE ID = :id01 OR ID = :id02");
pst.put("id01", "04");
pst.put("id02", "06");
Map[] publishers = dbh.query(pst);
println(new TabularFormat(publishers));

Statement bst = new Statement("UPDATE BOOK SET AUTHOR = ':author', ISSUE_DATE = !:idt WHERE AUTHOR = :author");
bst.put("author", null);
bst.put("idt", null);
dbh.update(bst);

Select sel = new Select(Book.class, "AUTHOR = :author");
sel.put("author", ":author");
Book[] books = (Book[]) dbh.select(sel);

for (int i = 0; i < books.length; i++)
    println(books[i]);

dbh.rollback();
dbh.disconnect();

結果

connect database 'url=jdbc:hsqldb:hsql://localhost, user=sa, password='.
'SELECT ID, NAME FROM PUBLISHER WHERE ID = ? OR ID = ? [04, 06]'
+--+----------+
|ID|NAME      |
+--+----------+
|04|太公望書林|
|06|民明書房  |
+--+----------+
'UPDATE BOOK SET AUTHOR = ':author', ISSUE_DATE = ? WHERE AUTHOR IS NULL [null]'
'SELECT * FROM BOOK WHERE AUTHOR = ? [:author]'
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=000, issue_date=null, publisher=00, title=心に残る戦国名勝負100選, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=000, issue_date=null, publisher=01, title=インド母なる大地を往く, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=001, issue_date=null, publisher=01, title=騎馬民族の逆襲, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=002, issue_date=null, publisher=01, title=中国武闘三千年, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=003, issue_date=null, publisher=01, title=武家社会に於ける風俗・迷信, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=000, issue_date=null, publisher=03, title=撃って候 早くてゴメン, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=001, issue_date=null, publisher=03, title=世界名物兄弟-この兄あってこの弟あり-, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=002, issue_date=null, publisher=03, title=大江戸流行JUST NOW, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=003, issue_date=null, publisher=03, title=鉄仮面の告白, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=000, issue_date=null, publisher=04, title=あなたにも出来る!中国拳法修行百科, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=001, issue_date=null, publisher=04, title=エーゲ海-古代格闘史の浪漫-, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=002, issue_date=null, publisher=04, title=ギリシャ神話に見る現代人への教訓, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=003, issue_date=null, publisher=04, title=シルクロードの彼方, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=004, issue_date=null, publisher=04, title=暗黒組織類聚, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=005, issue_date=null, publisher=04, title=英国貴族の習慣・風俗, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=006, issue_date=null, publisher=04, title=眼球大脳生理学, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=007, issue_date=null, publisher=04, title=世界幻覚大全, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=008, issue_date=null, publisher=04, title=世界残虐刑罰史, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=009, issue_date=null, publisher=04, title=世界頭髪大全, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=010, issue_date=null, publisher=04, title=中国拳法-火の考察-, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=011, issue_date=null, publisher=04, title=動物棲息類聚, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=000, issue_date=null, publisher=06, title=EYEこそ全て, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=001, issue_date=null, publisher=06, title=SKATER'SWALTZ, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=002, issue_date=null, publisher=06, title=アラスカ大紀行, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=003, issue_date=null, publisher=06, title=インド人も吃驚!ヨガに奇跡, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=004, issue_date=null, publisher=06, title=かき氷屋三代記-我永遠に氷をアイス-, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=005, issue_date=null, publisher=06, title=クロコダイル・ダンディ-爬虫類よもやま話-, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=006, issue_date=null, publisher=06, title=スポーツ起源異聞, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=007, issue_date=null, publisher=06, title=ツタンカーメンの逆襲, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=008, issue_date=null, publisher=06, title=バットマンかく語りき, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=009, issue_date=null, publisher=06, title=マグネットパワー-21世紀をこう変える-, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=010, issue_date=null, publisher=06, title=ヨーロッパ中世スポーツの起源, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=011, issue_date=null, publisher=06, title=亜細亜刑史大系, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=012, issue_date=null, publisher=06, title=暗殺秘話, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=013, issue_date=null, publisher=06, title=医学的見地より考察した中国拳法, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=014, issue_date=null, publisher=06, title=泳げ!!騎馬民族, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=015, issue_date=null, publisher=06, title=炎の武将・織田信長, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=016, issue_date=null, publisher=06, title=玩具に見る古代中国の英知, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=017, issue_date=null, publisher=06, title=奇跡の鳥慶漢(ウーケイハン), update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=018, issue_date=null, publisher=06, title=教育と体罰, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=019, issue_date=null, publisher=06, title=驚異の昆虫世界, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=020, issue_date=null, publisher=06, title=剣史記, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=021, issue_date=null, publisher=06, title=拳法興亡史, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=022, issue_date=null, publisher=06, title=現代麻薬集成, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=023, issue_date=null, publisher=06, title=古代刑法全, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=024, issue_date=null, publisher=06, title=室内球技における中国文明の影響, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=025, issue_date=null, publisher=06, title=実用動物辞典, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=026, issue_date=null, publisher=06, title=食うか食われるか!!世界食通事情, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=027, issue_date=null, publisher=06, title=人体-その代謝機能の神秘-, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=028, issue_date=null, publisher=06, title=世界スポーツ奇譚, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=029, issue_date=null, publisher=06, title=世界の怪拳・奇拳, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=030, issue_date=null, publisher=06, title=世界気象大鑑, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=031, issue_date=null, publisher=06, title=世界古代兵器大鑑, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=032, issue_date=null, publisher=06, title=世界拷問史, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=033, issue_date=null, publisher=06, title=世界史に見る現代兵器の源泉, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=034, issue_date=null, publisher=06, title=世界死闘決闘百選, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=035, issue_date=null, publisher=06, title=西欧文明-その爛熟と退廃-, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=036, issue_date=null, publisher=06, title=戦国異聞記, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=037, issue_date=null, publisher=06, title=戦国決闘異聞第七巻, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=038, issue_date=null, publisher=06, title=戦国武芸者往来, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=039, issue_date=null, publisher=06, title=戦国武将考察, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=040, issue_date=null, publisher=06, title=戦国武将人情譚, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=041, issue_date=null, publisher=06, title=相撲人生待ったなし, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=042, issue_date=null, publisher=06, title=大磁界, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=043, issue_date=null, publisher=06, title=大衆操作暗黒史, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=044, issue_date=null, publisher=06, title=誰が為に鐘は鳴る, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=045, issue_date=null, publisher=06, title=男塾白書2000年版, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=046, issue_date=null, publisher=06, title=知られざる秘拳, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=047, issue_date=null, publisher=06, title=中国の奇拳-その起源と発達-, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=048, issue_date=null, publisher=06, title=中国宮廷儀礼典範, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=049, issue_date=null, publisher=06, title=中国拳法-その科学性, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=050, issue_date=null, publisher=06, title=中国拳法に見る東洋医術, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=051, issue_date=null, publisher=06, title=中国拳法修行大鑑, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=052, issue_date=null, publisher=06, title=中国拳法大武鑑, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=053, issue_date=null, publisher=06, title=中国古代吃驚医学大鑑, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=054, issue_date=null, publisher=06, title=中国三千年の歴史に学ぶ現代人の知恵, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=055, issue_date=null, publisher=06, title=中国電化大革命史, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=056, issue_date=null, publisher=06, title=中国日本武術交流秘史, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=057, issue_date=null, publisher=06, title=中国秘拳満漢全席, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=058, issue_date=null, publisher=06, title=中国武具-その創造と継承-, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=059, issue_date=null, publisher=06, title=中国武術大覧, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=060, issue_date=null, publisher=06, title=鉄拳記, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=061, issue_date=null, publisher=06, title=闘う動物大百科, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=062, issue_date=null, publisher=06, title=独習中国拳法, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=063, issue_date=null, publisher=06, title=肉体の神秘, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=064, issue_date=null, publisher=06, title=肉体の神秘とスポーツ, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=065, issue_date=null, publisher=06, title=日本風俗奇譚, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=066, issue_date=null, publisher=06, title=氷の科学, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=067, issue_date=null, publisher=06, title=浮虻流(ふあぶる)昆虫記, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=068, issue_date=null, publisher=06, title=武の中国史, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=069, issue_date=null, publisher=06, title=武士魂, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=070, issue_date=null, publisher=06, title=武道達人逸話集, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=071, issue_date=null, publisher=06, title=分子核構造その理論, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=072, issue_date=null, publisher=06, title=狼少年-拳-, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=073, issue_date=null, publisher=06, title=戮家その全貌, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=074, issue_date=null, publisher=06, title=氣-その効用と実践, update_date=2005-06-10 17:10:00.000}
Book@{author=:author, create_date=1999-06-10 17:10:00.000, id=075, issue_date=null, publisher=06, title=氣の科学, update_date=2005-06-10 17:10:00.000}
rollback transaction.
disconnect database.