MyBatis and 里面嵌套or查询

最新推荐文章于 2024-07-26 03:40:06 发布

qq_28744021

最新推荐文章于 2024-07-26 03:40:06 发布

阅读量1.5k

点赞数

文章标签： mybatis java 数据库

本文链接：https://blog.csdn.net/qq_28744021/article/details/128033490

版权

mybatis去除多余的and或者or

<if test="(field1!= null and field1!= '') or (field2!= null and field2!= '') or (field3!= null and field3!= '') ">
   and(
   <trim prefixOverrides="or">
      <if test="field1 != null and field1 != '' ">
         or t1.field1 like '%'+#{field1 }+'%'
      </if>
      <if test="field2!= null and field2!= '' ">
         or t1.field2 like '%'+#{field2}+'%'
      </if>
      <if test="field3!= null and field3!= '' ">
         or t1.field3 like '%'+#{field3}+'%'
      </if>
   </trim>
   )
</if>