<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>