//
1,建立Connection
Connection conn = ...
// 2,获得DatabaseMetaData的实例
DatabaseMetaData metaData = conn.getMetaData();
// 3,获取库名列表
ResultSet rs = metaData.getCatalogs();
while (rs.next()) ... {
System.out.println(rs.getString("TABLE_CAT"));
}
// 4,获取表名列表
ResultSet rs = metaData.getTables(conN.getCatalog(), null , null , new String[] ... {"TABLE"} );
while (rs.next()) ... {
System.out.println(rs.getString("TABLE_NAME"));
}
Connection conn = ...
// 2,获得DatabaseMetaData的实例
DatabaseMetaData metaData = conn.getMetaData();
// 3,获取库名列表
ResultSet rs = metaData.getCatalogs();
while (rs.next()) ... {
System.out.println(rs.getString("TABLE_CAT"));
}
// 4,获取表名列表
ResultSet rs = metaData.getTables(conN.getCatalog(), null , null , new String[] ... {"TABLE"} );
while (rs.next()) ... {
System.out.println(rs.getString("TABLE_NAME"));
}