MySQL과 Java를 사용하여 간단한 데이터 백업 기능을 구현하는 방법

import java.io.FileWriter;
import java.io.IOException;
import java.sql.*;

public class BackupData {
    public static void main(String[] args) {
        String url = "jdbc:mysql://localhost:3306/database";
        String username = "root";
        String password = "123456";

        try (Connection conn = DriverManager.getConnection(url, username, password);
             Statement stmt = conn.createStatement();
             FileWriter writer = new FileWriter("backup.sql")) {

            // 查询数据库中的所有表
            String sql = "SHOW TABLES";
            ResultSet rs = stmt.executeQuery(sql);

            // 遍历表，并导出数据
            while (rs.next()) {
                String tableName = rs.getString(1);
                sql = "SELECT * FROM " + tableName;
                ResultSet resultSet = stmt.executeQuery(sql);

                // 写入文件
                while (resultSet.next()) {
                    String data = resultSet.getString(1) + "," + resultSet.getString(2) + "," + ...; // 根据表的具体列数进行设置
                    writer.write("INSERT INTO " + tableName + " VALUES (" + data + ");
");
                }

                resultSet.close();
            }

            rs.close();
        } catch (SQLException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}

import java.io.BufferedReader;
import java.io.FileReader;
import java.io.IOException;
import java.sql.*;

public class RestoreData {
    public static void main(String[] args) {
        String url = "jdbc:mysql://localhost:3306/new_database";
        String username = "root";
        String password = "123456";
        String file = "backup.sql";

        try (Connection conn = DriverManager.getConnection(url, username, password);
             Statement stmt = conn.createStatement();
             BufferedReader reader = new BufferedReader(new FileReader(file))) {

            String line;
            while ((line = reader.readLine()) != null) {
                stmt.executeUpdate(line);
            }

        } catch (SQLException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}