<select id="findRecordsByFileIdList" parameterClass="java.util.Map" resultMap="EboxFileResultMap">
select id,file_name,parent,physical_symbol,status,type,gmt_modify,length,suffix,owner
from ebox_fs$SHARD_INDEX$
where id in <iterate open="(" close=")" conjunction=",">
#fileIdList[]#
</iterate>
and status > 0 order by type desc, file_name asc, gmt_modify desc
</select>
会报错,Cause: com.ibatis.sqlmap.client.SqlMapException: ParameterObject or property was not a Collection, Array or Iterator. 进行如下配置(红色部分):
<select id="findRecordsByFileIdList" parameterClass="java.util.Map" resultMap="EboxFileResultMap">
select id,file_name,parent,physical_symbol,status,type,gmt_modify,length,suffix,owner
from ebox_fs$SHARD_INDEX$
where id in <iterate open="(" close=")" conjunction="," property="fileIdList">
#fileIdList[]#
</iterate>
and status > 0 order by type desc, file_name asc, gmt_modify desc
</select>