mybatis 遍历

记录

<!-- 传入 list 遍历-->
select * from block_file bf
where bf.project_id in 
<foreach collection="query.list" open="[" close="]" separator="," item="item">
       #{item,jdbcType=INTEGER}
</foreach>

<!-- 传入字符串-->
<foreach item="paramCondition.taskKey" 
collection="paramCondition.taskKey.split(',')" open="(" separator="," close=")">
                #{paramCondition.taskKey}
            </foreach>