如何使用java API查询数组类型字段中至少包含一个给定数组元素的所有实体？

import java.sql.*;

public class ArrayQueryExample {
    public static void main(String[] args) {
        try {
            // 1. 建立数据库连接
            Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password");

            // 2. 准备查询语句
            String query = "SELECT * FROM mytable WHERE myarrayfield @> ?";

            // 3. 创建PreparedStatement对象
            PreparedStatement statement = connection.prepareStatement(query);

            // 4. 设置数组参数
            Integer[] givenArray = {1, 2, 3};
            Array arrayParam = connection.createArrayOf("integer", givenArray);
            statement.setArray(1, arrayParam);

            // 5. 执行查询并获取结果集
            ResultSet resultSet = statement.executeQuery();

            // 6. 处理查询结果
            while (resultSet.next()) {
                // 处理每个实体的字段值
                int id = resultSet.getInt("id");
                String name = resultSet.getString("name");
                // ...
                System.out.println("ID: " + id + ", Name: " + name);
            }

            // 7. 关闭连接和其他资源
            resultSet.close();
            statement.close();
            connection.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}