<select id="findCompatibilityMTs" resultType="String" parameterType="java.util.List">
... in
<foreach item="optCpId" collection="list" open="(" separator="," close=")" index="index" >
#{optCpId }
</foreach>
</select>
<select id="findOptionCompatibilityMTInfos" resultType="hashmap" parameterType="hashmap">
... tco.pk_id in
<foreach item="optCpId" collection="optCpIds" open="(" separator="," close=")" index="index" >
#{optCpId }
</foreach>
</select>
... in
<foreach item="optCpId" collection="list" open="(" separator="," close=")" index="index" >
#{optCpId }
</foreach>
</select>
<select id="findOptionCompatibilityMTInfos" resultType="hashmap" parameterType="hashmap">
... tco.pk_id in
<foreach item="optCpId" collection="optCpIds" open="(" separator="," close=")" index="index" >
#{optCpId }
</foreach>
</select>
本文介绍使用MyBatis进行批量查询的方法,包括通过foreach标签实现参数列表的动态SQL构建。具体展示了如何利用.foreach标签对列表进行遍历并形成SQL IN子句。

被折叠的 条评论
为什么被折叠?



