mysql 获取schema_如何获取数据库列表“Schema” MySql的名称使用java JDBC

how to get list of Databases "Schema" names of MySql using java JDBC ?

解决方案

The getSchemas() method of the DatabaseMetaData is the obvious but with MySQL you have to use getCatalogs()

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") );

}