dao.xml

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

posted @ 2018-08-01 11:54  wuyueping  阅读(166)  评论(0编辑  收藏  举报