如何在SQL Java中将列表值作为参数传递

import java.sql.*;
import java.util.List;

public class Main {
    public static void main(String[] args) {
        // 假设列表值为一个整数列表
        List<Integer> values = List.of(1, 2, 3, 4, 5);

        try {
            // 连接到数据库
            Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password");

            // 构建SQL查询语句
            String sql = "SELECT * FROM mytable WHERE id IN (?)";

            // 预编译SQL查询语句
            PreparedStatement statement = connection.prepareStatement(sql);

            // 将列表值作为参数传递给PreparedStatement对象
            Array array = connection.createArrayOf("INTEGER", values.toArray());
            statement.setArray(1, array);

            // 执行SQL查询
            ResultSet resultSet = statement.executeQuery();

            // 处理查询结果
            while (resultSet.next()) {
                // 处理每一行数据
                int id = resultSet.getInt("id");
                String name = resultSet.getString("name");
                // 其他字段...

                System.out.println("ID: " + id + ", Name: " + name);
            }

            // 关闭连接
            resultSet.close();
            statement.close();
            connection.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}