rubbish-db / チュートリアル / テーブルの一覧を取得する


[ rubbish-db ]

ソース

RubbishDatabase dbh = new RubbishDatabase();
dbh.connect("jdbc:hsqldb:hsql://localhost", "sa", "");
Map[] rows = dbh.getTables("PUBLIC");
dbh.disconnect();
println(new TabularFormat(rows));

結果

+---------+-----------+----------+----------+-------+--------+----------+---------+-------------------------+--------------+-----------+---------+
|TABLE_CAT|TABLE_SCHEM|TABLE_NAME|TABLE_TYPE|REMARKS|TYPE_CAT|TYPE_SCHEM|TYPE_NAME|SELF_REFERENCING_COL_NAME|REF_GENERATION|HSQLDB_TYPE|READ_ONLY|
+---------+-----------+----------+----------+-------+--------+----------+---------+-------------------------+--------------+-----------+---------+
|         |PUBLIC     |BOOK      |TABLE     |       |        |          |         |                         |              |MEMORY     |false    |
|         |PUBLIC     |PUBLISHER |TABLE     |       |        |          |         |                         |              |MEMORY     |false    |
+---------+-----------+----------+----------+-------+--------+----------+---------+-------------------------+--------------+-----------+---------+