如何将java.sql.array转换为列表<MyClass>

import java.sql.Array;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Arrays;
import java.util.List;
import java.util.stream.Collectors;

public class ArrayToListConversion {
    public static void main(String[] args) {
        String jdbcUrl = "jdbc:mysql://localhost:3306/mydatabase";
        String username = "myusername";
        String password = "mypassword";
        
        try (Connection connection = DriverManager.getConnection(jdbcUrl, username, password)) {
            String sql = "SELECT my_array_column FROM my_table";
            ResultSet resultSet = connection.createStatement().executeQuery(sql);
            
            if (resultSet.next()) {
                Array array = resultSet.getArray("my_array_column");
                Object[] arrayData = (Object[]) array.getArray();
                
                List<MyClass> myList = Arrays.stream(arrayData)
                        .map(element -> {
                            // 转换逻辑，将element转换为MyClass对象
                            // 示例中使用了假设的转换逻辑
                            MyClass myObject = new MyClass();
                            myObject.setField((String) element);
                            return myObject;
                        })
                        .collect(Collectors.toList());
                
                // 使用转换后的列表进行后续操作
                // ...
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}