?? ?<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() &gt; 0" >
? ? ? and s.orderstatus in?
? ? ? <foreach collection="status" item="listItem" open="(" close=")" separator="," >
? ? ? ? #{listItem}
? ? ? </foreach>
? ? </if> ??

select login,name,email from users u where
<choose>
? ? <when test="sameEmailList != null and sameEmailList.size > 0 ">
? ? ? ? email in <foreach collection="sameEmailList" item="email" open="(" separator="," close=")">
? ? ? ? #{email, jdbcType=VARCHAR}
? ? ? ? </foreach>
? ? </when>
? ? <otherwise>
? ? ? ? 1 = 0
? ? </otherwise>
</choose>
<choose>
? ? <when test="sameNameList != null and sameNameList.size > 0">
? ? ? ? or name in <foreach collection="sameNameList" item="name" open="(" separator="," close=")">
? ? ? ? #{name, jdbcType=VARCHAR}
? ? </foreach>
? ? </when>
? ? <otherwise>
? ? ? ? or 1 = 0
? ? </otherwise>
</choose>
ORDER by name, email ASC