[Java] mybatis的动态sql之if test的使用说明

<select id="getMaxDepartId" parameterType="java.lang.String" resultType="java.lang.String">
  SELECT MAX(DEPART_ID) FROM T_P_DEPART 
  <where>
    <if test="_parameter!=null and _parameter!=''"> 
    AND DEPART_PID = #{departId,jdbcType=VARCHAR} 
    </if>
    <if test="_parameter==null or _parameter==''"> 
    AND DEPART_PID IS NULL
    </if>
  </where>
  </select>

<select id="findShopByName" parameterType="ShopVo" resultType="ShopCustomer">
  select * from shop 
  <where>
    <if test="shopCustomer.shopname!=null and shopCustomer.shopname!=''">
    shop.shopname like '%${shopCustomer.shopname}%'
    </if>
    <if test="shopCustomer.shopname==null or shopCustomer.shopname==''"> 
    AND shop.shopname is null
    </if>
  </where>
</select>

<if test="title != null">
  AND title like #{title}
</if>

<if test="title != null and title != ''" >
  AND title like #{title}
</if>

<update id="updateObject" parameterType="*.*.Object" >
update table
 <set>
  <if test="Object.fullName == null or Object.fullName ==''">
  full_name = null,
  </if>
  <if test="Object.fullName != null and Object.fullName !=''">
  full_name = #{companyOrg.fullName},
  </if>
  <if test="Object.level == null or Object.level ==''">
  level = null,
  </if>
  <if test="Object.level == 0 ">
  level = null,
  </if>
  <if test="Object.level != null and Object.level !='' and Object.level != 0 ">
  level = #{companyOrg.level},
  </if>
 
 </set>
 where 1=1 and id =#{companyOrg.id}
</update>