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#getCatalogs()
例:
Class.forName("com.mysql.jdbc.Driver");// change user and password as you need itConnection con = DriverManager.getConnection (connectionURL, "user", "password");ResultSet rs = con.getmetaData().getCatalogs();while (rs.next()) { System.out.println("TABLE_CAT = " + rs.getString("TABLE_CAT") );}


