mybatis中判断两个集合是否为空

来源:互联网 发布:打击电信网络诈骗视频 编辑:程序博客网 时间:2024/06/03 23:06
在工作中遇到mybatis中判断两个集合是否为空,不为空的话遍历;都为空执行  1=0 or 1=0,则查询出来空集合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
原创粉丝点击