SELECT * FROM uc_demension WHERE CODE_=#{code} AND IS_DELE_!='1' SELECT * FROM uc_demension WHERE IS_DEFAULT_=1 AND IS_DELE_!='1' UPDATE uc_demension SET IS_DEFAULT_= 0 where IS_DEFAULT_= 1 SELECT count(1) FROM uc_demension WHERE CODE_ = #{code}