rubbish-db / チュートリアル / 複数件のレコードをJavaBeanの配列として取得する

[ rubbish-db ]

ソース

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

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

Publisher[] publishers = (Publisher[]) dbh.select(Publisher.class, "ORDER BY ID");

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

Book[] books = (Book[]) dbh.select(Book.class, "PUBLISHER IN (?, ?) ORDER BY PUBLISHER, ID", "04", "06");

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

dbh.disconnect();

結果

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