java 判断mysql数据库是否存在

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DatabaseExistenceChecker {

    public static void main(String[] args) {
        String url = "jdbc:mysql://localhost:3306/";
        String dbName = "your_database_name";
        String user = "your_username";
        String password = "your_password";

        try (Connection conn = DriverManager.getConnection(url, user, password);
             Statement stmt = conn.createStatement()) {

            // 尝试切换到指定数据库
            stmt.execute("USE " + dbName);

            // 如果能够成功切换，则数据库存在
            System.out.println("Database exists.");

        } catch (SQLException e) {
            // 如果捕获到SQLException异常，则数据库不存在或连接信息有误
            if (e.getSQLState().equals("08S01")) {
                System.out.println("Database does not exist or connection error.");
            } else {
                e.printStackTrace();
            }
        }
    }
}