<if test="status != null and status.size()>0" >
and s.orderstatus in
<foreach collection="status" item="listItem" open="(" close=")" separator="," >
#{listItem}
</foreach>
</if>
建议对特殊字符进行处理
<if test="status != null and status.size() > 0" >
and s.orderstatus in
<foreach collection="status" item="listItem" open="(" close=")" separator="," >
#{listItem}
</foreach>
</if>