<select>
<![CDATA[
select * from 表 a where a.claimGroup='1'
and (a.poCoy,a.policyNo) in(values
]]>
<foreach item="item" index="index" collection="policyinfos" separator=",">
<trim prefix="(" suffix=")" suffixOverrides=",">
<![CDATA[ #{item.coy},]]>
<![CDATA[ #{item.policyNo},]]>
</trim>
</foreach>
<![CDATA[ ) ]]>
</select>
注释:
policyinfos 对应传过来的参数 map中的key
coy和policyNo是值
例如 map.put(policyinfos,[{coy="1",policyNo="123"},{coy="1",policyNo="123"},{coy="1",policyNo="123"}] )