ID_,ORG_ID_,CODE_,VALUE_,UPDATE_TIME_,IS_DELE_,VERSION_ SELECT FROM uc_org_params WHERE ORG_ID_=#{orgId} AND IS_DELE_!='1' SELECT FROM uc_org_params where IS_DELE_!='1' and ORG_ID_ = #{orgId} and CODE_ = #{alias} DELETE FROM uc_org_params WHERE IS_DELE_='1' DELETE FROM uc_org_params WHERE ORG_ID_=#{orgId} UPDATE uc_org_params SET IS_DELE_='1',UPDATE_TIME_ = #{updateTime,jdbcType=TIMESTAMP} WHERE CODE_=#{alias}