@Override
	public void changeOfferStatus(String username, String status, String servicename) {
		ResultSet rs;

		try {
			PreparedStatement statement = connection.prepareStatement(
					"SELECT * FROM ServicesBuyers " + "WHERE username = ?" +
					" AND service = ?",
					ResultSet.TYPE_SCROLL_INSENSITIVE,
					ResultSet.CONCUR_UPDATABLE);

			statement.setString(1, username);
			statement.setString(2, servicename);

			rs = statement.executeQuery();

			while (rs.next()) {
				//update status for the services in the list
				rs.updateString("launch_offer", status);
				rs.updateRow();
			}

			rs.close();

		} catch (SQLException e) {
			e.printStackTrace();
		}

	}