<if test="orderIds != null and orderIds.size > 0">
AND order_id IN
<foreach item="item" collection="orderIds" separator="," open="(" close=")" index="">
#{item}
</foreach>
</if>
解释:orderIds是一个类型为integer的list