如何使用Java JDBC获得MySql的数据库“模式”名称列表

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

SHOW DATABASES

USE DATABASE;

DatabaseMetaData meta = conn.getMetaData();
ResultSet schemas = meta.getSchemas();
while (schemas.next()) {
  String tableSchema = schemas.getString(1);    // \"TABLE_SCHEM\"
  String tableCatalog = schemas.getString(2); //\"TABLE_CATALOG\"
  System.out.println(\"tableSchema\"+tableSchema);
}

DatabaseMetaData dbmd = con.getMetaData();
ResultSet ctlgs = dbmd.getCatalogs();
while(ctlgs.next())
{
System.out.println(\"ctlgs  =  \"+ctlgs.getString(1));
}