How to List All MySQL Database Schemas Using Java JDBC?

How to Retrieve a List of MySQL Database Schemas Using Java JDBC

When dealing with MySQL databases, it's common to work with multiple schemas. To manage these schemas effectively, you might need to obtain a list of their names through your Java program. JDBC provides a method to accomplish this task.

Solution Using DatabaseMetaData

The DatabaseMetaData class in Java JDBC provides a way to retrieve various metadata about the database you're connected to. To obtain a list of schemas in MySQL, you can use the getCatalogs() method.

Example Code:

<code class="java">import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.DatabaseMetaData;
import java.sql.ResultSet;

public class GetMySQLSchemas {

    public static void main(String[] args) throws Exception {
        // Replace "connectionURL", "user", and "password" with your actual values
        String connectionURL = "jdbc:mysql://localhost:3306/databaseName";
        String user = "username";
        String password = "password";

        try (Connection con = DriverManager.getConnection(connectionURL, user, password)) {
            DatabaseMetaData metaData = con.getMetaData();
            ResultSet rs = metaData.getCatalogs();

            while (rs.next()) {
                System.out.println("Schema Name: " + rs.getString("TABLE_CAT"));
            }
        }
    }
}</code>

In MySQL, the term "catalog" is used instead of "schema" in the DatabaseMetaData API. Therefore, the getCatalogs() method provides you with a list of schema names.

This code snippet demonstrates how to connect to a MySQL database, retrieve its list of schemas, and print them to the console. You can modify the connection parameters as needed to connect to your specific database.

The above is the detailed content of How to List All MySQL Database Schemas Using Java JDBC?. For more information, please follow other related articles on the PHP Chinese website!