在查询时使用<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>