如何使用 java JDBC 获取 MySql 的数据库“架构”名称列表?
The getSchemas()
DatabaseMetaData 的方法是显而易见的,但对于 MySQL 你必须使用getCatalogs()
http://download.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getSchemas() http://download.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getSchemas%28%29
http://download.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getCatalogs() http://download.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getCatalogs%28%29
Example:
Class.forName("com.mysql.jdbc.Driver");
// change user and password as you need it
Connection con = DriverManager.getConnection (connectionURL, "user", "password");
ResultSet rs = con.getMetaData().getCatalogs();
while (rs.next()) {
System.out.println("TABLE_CAT = " + rs.getString("TABLE_CAT") );
}
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)