将列和值的HashMap存储到用户ID的SQL数据库中

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.HashMap;

public class HashMapToDatabase {
    public static void main(String[] args) {
        HashMap<String, String> userData = new HashMap<>();
        userData.put("name", "John Doe");
        userData.put("email", "john.doe@example.com");
        userData.put("age", "30");

        String url = "jdbc:mysql://localhost:3306/mydatabase";
        String user = "username";
        String password = "password";

        try (Connection conn = DriverManager.getConnection(url, user, password)) {
            String sql = "INSERT INTO users (user_id, name, email, age) VALUES (?, ?, ?, ?)";
            PreparedStatement pstmt = conn.prepareStatement(sql);
            pstmt.setInt(1, 1); // 假设用户ID为1
            for (String key : userData.keySet()) {
                pstmt.setString(2 + userData.keySet().indexOf(key), userData.get(key));
            }
            pstmt.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}