mybatis里面xml中SQL语句if语句里嵌套if语句

来源：互联网发布：周末排课软件编辑：程序博客网时间：2024/04/29 20:10

mybatis里面的if语句需要加上(但是有时不需要但是（又是在if语句中的

案例一不完善

<select id="selectRechargeInfoChainCount" resultType="int">
   select count(*) from t_group_card_recharge_info
<where>
     <if test="cardNo!=null and cardNo!=''">
     and card_no =#{cardNo}
     </if>
      <if test="mobile!=null and mobile!=''">
     and mobile =#{mobile}
     </if>
    <if test="null!=beginDate">
    and back_time <![CDATA[>=]]> #{beginDate}
    </if>
    <if test="null!=endDate">
    and back_time <![CDATA[<=]]> #{endDate}
    </if>
    <if test="clinicId!=null and clinicId!=''">
    and
    ( //这个括号与下一个括号一一对应但是下面不满足时会报错,上面的括号是多余的
     clinic_id =#{clinicId}
     </if>
     <if test="sysId!=null and sysId!='' and sysId != -1">
     or sys_id =#{sysId} )
     </if>

    </where>
</select>

案例二完善案例一

<select id="selectRechargeInfoChainCount" resultType="int">
   select count(*) from t_group_card_recharge_info
<where>
     <if test="cardNo!=null and cardNo!=''">
     and card_no =#{cardNo}
     </if>
      <if test="mobile!=null and mobile!=''">
     and mobile =#{mobile}
     </if>
    <if test="null!=beginDate">
    and back_time <![CDATA[>=]]> #{beginDate}
    </if>
    <if test="null!=endDate">
    and back_time <![CDATA[<=]]> #{endDate}
    </if>
    <if test="clinicId!=null and clinicId!=''">
    and
    <if test="sysId!=null and sysId!='' and sysId != -1">
    (
     </if> //这样不会因为下面不满足而多出括号
     clinic_id =#{clinicId}
     </if>
     <if test="sysId!=null and sysId!='' and sysId != -1">
     or sys_id =#{sysId} )
     </if>

    </where>
</select>

注意颜色一样的标记便于理解

0 0