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

最新推荐文章于 2024-05-22 13:48:22 发布

浪子骑驴

最新推荐文章于 2024-05-22 13:48:22 发布

阅读量1.4k

点赞数

分类专栏： Mybatis 文章标签： java

本文链接：https://blog.csdn.net/RodJohnson_523391/article/details/84923417

版权

Mybatis 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

[quote]在工作中遇到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>
[color=red][b]<when test="sameNameList != null and sameNameList.size > 0">[/b][/color]
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
[/quote]

[url]https://blog.csdn.net/cloudzpc/article/details/78254479[/url]