<if test="statusFlag != null and statusFlag != '' ">
AND STATUS_FLAG = #{statusFlag,jdbcType=DECIMAL}
</if>
这种写法如果值为0是没办法检测到得
<if test="statusFlag != null and statusFlag != '' ">
AND STATUS_FLAG = #{statusFlag,jdbcType=DECIMAL}
</if>
这种写法如果值为0是没办法检测到得