public static Vector<Order> getPaidOrders() throws Exception{
		Vector<Order> OrderVector = new Vector<Order>();
		Statement state = DBConnection.OpenConnection();
		String commandstring = "SELECT * FROM Orders WHERE Status = 'paid' ORDER BY ID DESC;";
		int ID = 0;
		int E_PIN = 0;
		int Table_No = 0;
		String Items = "";
		String Status = "";
		double Total = 0.0;
		double Deposit = 0.0;

		if(state != null){
			try {
				ResultSet rs = state.executeQuery(commandstring);
				while(rs.next()) {
					ID = rs.getInt("ID");
					E_PIN = rs.getInt("E_PIN");
					Table_No = rs.getInt("Table_No");
					Items = rs.getString("Items");
					Status = rs.getString("Status");
					Total = rs.getDouble("Total");
					Deposit = rs.getDouble("Deposit");
					Order new_order = new Order(ID, E_PIN, Table_No, Items, Status, Total, Deposit);
					OrderVector.add(new_order);
				}
				if(OrderVector.size() == 0) {
					throw new Exception("No Completed Orders");
				}
			} 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();
		return OrderVector;
	}