java备份mysql 表

// 设置字符集为utf8
String url = "jdbc:mysql://localhost:3306/mydatabase?useUnicode=true&characterEncoding=utf8";
Connection conn = DriverManager.getConnection(url, "username", "password");

import java.io.*;
import java.sql.*;

public class MySQLBackup {
    public static void main(String[] args) {
        String url = "jdbc:mysql://localhost:3306/mydatabase?useUnicode=true&characterEncoding=utf8";
        String user = "username";
        String password = "password";
        String tableName = "mytable";
        String backupFilePath = "backup/mytable.sql";

        try (Connection conn = DriverManager.getConnection(url, user, password);
             Statement stmt = conn.createStatement();
             BufferedWriter writer = new BufferedWriter(new FileWriter(backupFilePath))) {

            // 导出表结构
            ResultSet rs = stmt.executeQuery("SHOW CREATE TABLE " + tableName);
            if (rs.next()) {
                writer.write(rs.getString(2));
                writer.newLine();
            }
            rs.close();

            // 导出表数据
            rs = stmt.executeQuery("SELECT * FROM " + tableName);
            ResultSetMetaData metaData = rs.getMetaData();
            int columnCount = metaData.getColumnCount();

            while (rs.next()) {
                writer.write("INSERT INTO " + tableName + " VALUES (");
                for (int i = 1; i <= columnCount; i++) {
                    if (i > 1) writer.write(", ");
                    writer.write("'" + rs.getString(i).replace("'", "''") + "'");
                }
                writer.write(");");
                writer.newLine();
            }
            rs.close();

            System.out.println("Backup completed successfully!");
        } catch (SQLException | IOException e) {
            e.printStackTrace();
        }
    }
}