public void updateShown() throws Exception{
		 //update order in DB to "served"
		this.Shown = "Yes";
        Statement state = DBConnection.OpenConnection();
		String commandstring = "UPDATE Reservations SET Shown = 'Yes' WHERE Name = '" + this.Name + "' AND Size = " + this.Size + " AND DateTime = '" + new java.sql.Timestamp(this.getDate().getTime()) + "' AND Shown = 'No';";
		
		if(state != null){
			try {
				state.execute(commandstring);
			} catch (SQLException e) {
				System.out.println(e.getMessage());
				throw new Exception("Error in SQL Execution");
				}
		}
		else
			System.err.println("Statement was null.  No connection?");
		
		state.close();
	}