mybatis中if标签的test多判断怎么写

m0_37746602 2017-10-16 11:08:38

<if test="(acquiTime == null or acquiTime =='') and (plateNum == null or plateNum =='') and highspCode != null and highspCode !='' or highspCode !='000') and (chargeCode == null or chargeCode =='' or chargeCode =='000')">
AND datediff(now(),T1.ACQUI_TIME)=6
</if>

各位大神给看看,怎么写才对,这是我写的,运行报错

...全文

6020 3 打赏收藏转发到动态举报

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

吉吉g王 2017-10-16

打赏
举报

highspCode !='' or highspCode !='000') 左边的括号没有

张悟空o 2017-10-16

打赏
举报

<if test="(acquiTime == null or acquiTime =='') and (plateNum == null or plateNum =='') and highspCode != null and (highspCode !='' or highspCode !='000') and (chargeCode == null or chargeCode =='' or chargeCode =='000')"> AND datediff(now(),T1.ACQUI_TIME)=6 </if> 少了个括号吧

qq_39912309 2017-10-16

打赏
举报

<if test="createUid != null and createUid != ''"> AND create_uid = #{createUid} </if> <if test="createCompanyCode != null and createCompanyCode != ''"> AND create_company_code = #{createCompanyCode} </if> <if test="state !=null and state !=''"> AND state = #{state} </if>类似这样