<if test="bank != null">
AND BINBANKID in
<foreach collection="bank" index="index" item="item" open="(" separator="," close=")">
#{item}
</foreach>
</if>
PS:其中bank为list。
<if test="bank != null">
AND BINBANKID in
<foreach collection="bank" index="index" item="item" open="(" separator="," close=")">
#{item}
</foreach>
</if>
PS:其中bank为list。