java恢复mysql数据库

import java.io.BufferedReader;
import java.io.File;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

public class MySQLRestore {

    public static void main(String[] args) {
        String mysqlPath = "C:\\Program Files\\MySQL\\MySQL Server 8.0\\bin\\";
        String host = "localhost";
        String port = "3306";
        String database = "mydatabase";
        String username = "root";
        String password = "password";
        String backupPath = "C:\\backup\\backup.sql";
        
        try {
            // Establish MySQL database connection
            String url = "jdbc:mysql://" + host + ":" + port + "/" + database;
            Connection connection = DriverManager.getConnection(url, username, password);
            Statement statement = connection.createStatement();
            
            // Execute MySQL restore command
            String[] restoreCmd = new String[] { mysqlPath + "mysql", database, "-h" + host, "-P" + port, "-u" + username, "-p" + password, "-e", "source " + backupPath };
            Process process = Runtime.getRuntime().exec(restoreCmd);
            
            // Wait for the restore process to complete
            int exitCode = process.waitFor();
            
            // Check the exit code to determine the success or failure of the restore operation
            if (exitCode == 0) {
                System.out.println("Database restore completed successfully.");
            } else {
                System.out.println("Database restore failed. Please check the backup file and try again.");
            }
            
            // Close database connection
            statement.close();
            connection.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}