jdbc修改mysql数据库名称

import java.sql.*;

public class RenameDatabase {
    public static void main(String[] args) {
        String url = "jdbc:mysql://localhost:3306";
        String user = "your_username";
        String password = "your_password";
        String oldDatabaseName = "old_db";
        String newDatabaseName = "new_db";

        try (Connection conn = DriverManager.getConnection(url, user, password)) {
            // Step 1: Create a new database with the desired name
            String createNewDatabaseSQL = "CREATE DATABASE " + newDatabaseName;
            try (Statement stmt = conn.createStatement()) {
                stmt.executeUpdate(createNewDatabaseSQL);
            }

            // Step 2: Copy tables and data from old database to new database
            String copyTablesSQL = "CREATE TABLE " + newDatabaseName + ".`%s` LIKE " + oldDatabaseName + ".`%s`";
            DatabaseMetaData metaData = conn.getMetaData();
            ResultSet tables = metaData.getTables(oldDatabaseName, null, "%", new String[] {"TABLE"});
            while (tables.next()) {
                String tableName = tables.getString("TABLE_NAME");
                try (Statement stmt = conn.createStatement()) {
                    stmt.executeUpdate(String.format(copyTablesSQL, tableName, tableName));
                }
                // Copy data from old table to new table
                String copyDataSQL = "INSERT INTO " + newDatabaseName + ".`%s` SELECT * FROM " + oldDatabaseName + ".`%s`";
                try (Statement stmt = conn.createStatement()) {
                    stmt.executeUpdate(String.format(copyDataSQL, tableName, tableName));
                }
            }

            // Step 3: Drop the old database
            String dropOldDatabaseSQL = "DROP DATABASE " + oldDatabaseName;
            try (Statement stmt = conn.createStatement()) {
                stmt.executeUpdate(dropOldDatabaseSQL);
            }

            System.out.println("Database renamed successfully.");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}