Java实现mysql数据库的导入导出的代码

Java实现MySQL数据库的导入导出需要使用JDBC驱动。下面是一个示例代码：

导出：

import java.io.File;
import java.io.FileWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class Export {
    public static void main(String[] args) {
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
            Statement statement = connection.createStatement();
            ResultSet resultSet = statement.executeQuery("SELECT * FROM users");
            FileWriter fileWriter = new FileWriter(new File("users.csv"));
            while (resultSet.next()) {
                fileWriter.append(resultSet.getString(1));
                fileWriter.append(",");
                fileWriter.append(resultSet.getString(2));
                fileWriter.append(",");
                fileWriter.append(resultSet.getString(3));
                fileWriter.append("\n");
            }
            fileWriter.flush();
            fileWriter.close();
            resultSet.close();
            statement.close();
            connection.close();
            System.out.println("导出成功");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}