DELETE FROM TB_DOOR_DOORPERMISSTYPEWHERESN_DOOR =#{SN_DOOR}and PERMISSTYPEID=#{PERMISSTYPEID}and (TIME_PHASE=#{TIME_PHASE,jdbcType=V">

oracle or 函数

来源:这里教程网 时间:2026-03-03 14:27:43 作者:

删除全部包括记录 <delete id="removesingle" parameterType="java.lang.String"> DELETE FROM TB_DOOR_DOORPERMISSTYPE  WHERE SN_DOOR =  #{SN_DOOR}   and      PERMISSTYPEID=#{PERMISSTYPEID} and (TIME_PHASE=#{TIME_PHASE,jdbcType=VARCHAR} or TIME_PHASE is null ) </delete>

相关推荐