Question

ibatis 配置文件中 <select >中增加一个<iterate>，就报Element type "iterate" must be declared

<select id="search_jobtable_getJobListbyJobord" parameterType="map" resultType="map">
select * from JOBTABLE where JOBORD in
<iterate conjunction="," close=")" open="(">$jobtableList[].JOBORD$</iterate>
</select>

Answer 1

这是因为没有定义property属性，需要在之后添加property属性，代码如下:

<iterate open="(" close=")" conjunction="," property="jobtableList">
                    $jobtableList[].JOBORD$
                </iterate>

Answer 2

好久没有用过这个了
<iterate property="jobtableList" open="(" conjunction="," close=")">
$jobtableList[].JOBORD$
</iterate>
或者可以考虑用<foreach>......</foreach>尝试下？

Answer 3

<iterate open="(" close=")" conjunction="," property="jobtableList">
$jobtableList[].JOBORD$
</iterate>
没有写property属性