mybaties 的and or 条件 xml 判断

圣英神士

于 2019-11-08 10:51:39 发布

阅读量1.7k

点赞数

CC 4.0 BY-SA版权

分类专栏： mybatis

本文链接：https://blog.csdn.net/qq_34627002/article/details/102968946

mybatis 专栏收录该内容

23 篇文章

订阅专栏

<if test="goodsCode !=null and goodsCode !='' and supplier  !=null and supplier  !='' ">
    goods_code =#{goodsCode}  and   supplier  =#{supplier}
</if>
<if test="goodsCode !=null and goodsCode !='' and (supplier  ==null or supplier  !='')">
    goods_code =#{goodsCode}  and   supplier   is  null
</if>