mybatis常用循环语句

1.集合

<foreach collection="list" item="item" open="(" close=")" separator=",">
         #{item}
</foreach>

<foreach collection="dataList" item="it" separator=",">
         (#{it.model_code},#{it.city_code},#{it.from_type},#{it.city_id},
           #{it.model_id},#{it.province_id},#{it.brand_id},#{it.serie_id})

</foreach>

2.字符串

<foreach collection="id.split(',')" close=")" open="(" separator="," item="item">
         #{item}
</foreach>

总结：比较给力的语句，超级方便