mybatis <where> <set>标签的作用

在查询时使用<where>标签会去除查询条件中多余的AND

使用

 <where>       <if test="enterpriseId != null" >        ENTERPRISE_ID = #{enterpriseId,jdbcType=VARCHAR}      </if>      <if test="enterpriseName != null" >        AND ENTERPRISE_NAME = #{enterpriseName,jdbcType=VARCHAR}      </if>      <if test="departmentId != null" >        AND DEPARTMENT_ID = #{departmentId,jdbcType=VARCHAR}      </if></where>

在更新时使用<set>标签 会去除多余的逗号

使用

 <set >      <if test="enterpriseId != null" >        ENTERPRISE_ID = #{enterpriseId,jdbcType=VARCHAR},      </if>      <if test="enterpriseName != null" >        ENTERPRISE_NAME = #{enterpriseName,jdbcType=VARCHAR},      </if>      <if test="departmentId != null" >        DEPARTMENT_ID = #{departmentId,jdbcType=VARCHAR},      </if></set>