<if test="record.aalSts != null and record.aalSts != ''">
and AAL_STS in (${record.aalSts})
</if>
()这个特别重要
<if test="record.aalSts != null and record.aalSts != ''">
and AAL_STS in
<foreach collection="record.aalStsList" index="index" item="item" open="(" separator="," close=")">
#{item}
</foreach>
</if>
第二种就是把aalSts转成数组进行传输