jdbc mysql 获取表_JDBC获取数据库所有表

当初在JDBC还没研究透的时候，就偷懒去用了hibernate，现在回过头来做jdbc的开发，发现自己真的了解的太少了，惭愧惭愧。

public static List getAllTableName(Connection cnn) throws SQLException{

List tables = new ArrayList();

DatabaseMetaData dbMetaData = cnn.getMetaData();

//可为:"TABLE", "VIEW", "SYSTEM TABLE",

//"GLOBAL TEMPORARY", "LOCAL TEMPORARY", "ALIAS", "SYNONYM"

String[] types = {"TABLE"};

ResultSet tabs = dbMetaData.getTables(null, null, null,types/*只要表就好了*/);

/*记录集的结构如下:

TABLE_CAT String => table catalog (may be null)

TABLE_SCHEM String => table schema (may be null)

TABLE_NAME String => table name

TABLE_TYPE String => table type.

REMARKS String => explanatory comment on the table

TYPE_CAT String => the types catalog (may be null)

TYPE_SCHEM String => the types schema (may be null)

TYPE_NAME String => type name (may be null)

SELF_REFERENCING_COL_NAME String => name of the designated "identifier" column of a typed table (may be null)

REF_GENERATION String => specifies how values in SELF_REFERENCING_COL_NAME are created. Values are "SYSTEM", "USER", "DERIVED". (may be null)

*/

while(tabs.next()){

//只要表名这一列

tables.add(tabs.getObject("TABLE_NAME"));

}

System.out.println(tables);

return tables;

}

分享到：

2009-06-21 15:49

浏览 8425

评论

2 楼

nbkangta

2012-06-23

巴巴米 写道

果然还是得用DatabaseMetaData 吗..

现在回过头看，可以用show tables，但是这样就没办法做到数据库无关了

1 楼

巴巴米

2012-03-02

果然还是得用DatabaseMetaData 吗..