Python 官方文档:入门教程 => 点击学习
目录mybatis判断list不为空mybatis判断两个集合是否为空mybatis判断list不为空 <if test="status != null and sta
<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>
在工作中遇到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
以上为个人经验,希望能给大家一个参考,也希望大家多多支持编程网。
--结束END--
本文标题: mybatis判断list不为空/大小的问题
本文链接: https://www.lsjlt.com/news/163271.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-03-01
2024-03-01
2024-03-01
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0