在ibatis中传递和返回自定义数组对象,在java中传递和返回oracle

public class CustomArray {
    private String[] array;

    public String[] getArray() {
        return array;
    }

    public void setArray(String[] array) {
        this.array = array;
    }
}

CREATE TYPE custom_array AS TABLE OF VARCHAR2(255);

CREATE TABLE custom_array_table (
    id NUMBER PRIMARY KEY,
    array_data custom_array
);

   <result property="array" column="array_data" typeHandler="ArrayTypeHandler"/>
</parameterMap><select id="getCustomArray" parameterMap="CustomArrayMap" resultMap="CustomArrayMap">
    SELECT array_data FROM custom_array_table WHERE id = #{id}
</select><insert id="insertCustomArray" parameterMap="CustomArrayMap">
    INSERT INTO custom_array_table (id, array_data) VALUES (#{id}, #{array})
</insert>

CustomArray customArray = new CustomArray();
customArray.setArray(new String[]{"value1", "value2", "value3"});

SqlSession sqlSession = sqlSessionFactory.openSession();
CustomArrayMapper customArrayMapper = sqlSession.getMapper(CustomArrayMapper.class);

// 插入自定义数组对象
customArrayMapper.insertCustomArray(customArray);

// 获取自定义数组对象
CustomArray result = customArrayMapper.getCustomArray(1);