ID_,USER_ID_,CODE_,VALUE_,UPDATE_TIME_,IS_DELE_,VERSION_ SELECT FROM uc_user_params WHERE USER_ID_=#{id} AND IS_DELE_!='1' SELECT FROM uc_user_params where IS_DELE_!='1' and USER_ID_ = #{userId} and CODE_ = #{code} DELETE FROM uc_user_params WHERE IS_DELE_='1' UPDATE uc_user_params SET IS_DELE_='1',UPDATE_TIME_ = #{updateTime,jdbcType=TIMESTAMP} WHERE USER_ID_=#{userId} UPDATE uc_user_params SET IS_DELE_='1',UPDATE_TIME_ = #{updateTime,jdbcType=TIMESTAMP} WHERE CODE_=#{alias}