<select id="OmsAttemperIsChargeQuery" parameterType="map" resultType="hashMap">
select * from acc_freight
where oms_order_id in
<foreach item="item" index="index" collection="orderIds" open="(" separator="," close=")">
#{item}
</foreach>
</select>
Xml文件中,sql语句添加循环输出