rubbish-db / チュートリアル / 表形式で表示する


[ rubbish-db ]

ソース

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

dbh.connect("jdbc:hsqldb:hsql://localhost", "sa", "");
Map[] rows = dbh.query("SELECT * FROM PUBLISHER");
dbh.disconnect();

println(new TabularFormat(rows));

結果

connect database 'url=jdbc:hsqldb:hsql://localhost, user=sa, password='.
'SELECT * FROM PUBLISHER'
disconnect database.
+--+--------------------+-------+-----------------------+-----------------------+
|id|name                |volumes|update_date            |create_date            |
+--+--------------------+-------+-----------------------+-----------------------+
|00|ミュンヒハウゼン出版|1      |2005-07-10 17:10:00.000|1999-07-10 17:10:00.000|
|01|栄学館              |4      |2005-07-10 17:10:00.000|1999-07-10 17:10:00.000|
|02|時源出版            |4      |2005-07-10 17:10:00.000|1999-07-10 17:10:00.000|
|03|曙蓬莱新聞社        |4      |2005-07-10 17:10:00.000|1999-07-10 17:10:00.000|
|04|太公望書林          |12     |2005-07-10 17:10:00.000|1999-07-10 17:10:00.000|
|05|日本曙蓬莱武術協会  |5      |2005-07-10 17:10:00.000|1999-07-10 17:10:00.000|
|06|民明書房            |76     |2005-07-10 17:10:00.000|1999-07-10 17:10:00.000|
+--+--------------------+-------+-----------------------+-----------------------+