Java - 在mysql中存储HashSet

import java.sql.*;
import java.util.HashSet;

public class HashSetStorage {
    public static void main(String[] args) {
        // 数据库连接信息
        String url = "jdbc:mysql://localhost:3306/mydatabase";
        String username = "root";
        String password = "password";

        // 创建HashSet并添加数据
        HashSet<String> hashSet = new HashSet<>();
        hashSet.add("Apple");
        hashSet.add("Banana");
        hashSet.add("Orange");

        try {
            // 建立数据库连接
            Connection connection = DriverManager.getConnection(url, username, password);

            // 创建表
            String createTableQuery = "CREATE TABLE IF NOT EXISTS mytable (id INT AUTO_INCREMENT PRIMARY KEY, value VARCHAR(255))";
            Statement createTableStatement = connection.createStatement();
            createTableStatement.executeUpdate(createTableQuery);

            // 插入数据
            String insertQuery = "INSERT INTO mytable (value) VALUES (?)";
            PreparedStatement insertStatement = connection.prepareStatement(insertQuery);
            for (String value : hashSet) {
                insertStatement.setString(1, value);
                insertStatement.executeUpdate();
            }

            // 关闭连接
            insertStatement.close();
            createTableStatement.close();
            connection.close();

            System.out.println("HashSet存储到MySQL成功！");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}