<select id="selectItemkindByPolicyNo" resultMap="BaseResultMap" parameterType="java.util.List">
select *
from prpcitemkind kind
where kind.PolicyNo in
<foreach collection="list" item="item" index="index" open="(" separator="," close=")" >
#{item}
</foreach>
</select>
原文：https://www.cnblogs.com/wuyuwuyueping/p/9400473.html