mybatis去除多余的and或者or

最新推荐文章于 2024-09-03 17:39:19 发布

淘技术

最新推荐文章于 2024-09-03 17:39:19 发布

阅读量1.7w

点赞数 1

分类专栏： mybatis 文章标签： java mybatis and or trim

mybatis 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

<select id="selectBySelective" resultType="xxx.UserInfo">


select


<include refid="Base_Column_List" />


from uc_user


<trim prefix="WHERE (" suffix=")" prefixOverrides="AND |OR ">


<if test="userName != null" >


user_name = #{userName}


</if>


<if test="email != null" >


or email = #{email}


</if>


<if test="phone != null" >


or phone = #{phone}


</if>


<if test="weiboId != null" >


or weibo_id = #{weiboId}


</if>


<if test="wxId != null" >


or wx_id = #{wxId}


</if>


<if test="qqId != null" >


or qq_id = #{qqId}


</if>


</trim>


and status = 1

</select>