public  ArrayList<Reservation> ReservationsForDate(String date)
             throws UnauthorizedUserException, BadConnectionException, DoubleEntryException
    {
        /* Variable Section Start */
            /* Database and Query Preperation */
            PreparedStatement statment = null;
            ResultSet results = null;
            String statString = "SELECT * FROM `reservation` WHERE 'Date' = ?";

            /* Return Parameter */
            ArrayList<Reservation> BPArrayList = new ArrayList<Reservation>();
        /* Variable Section Stop */
        
        
        /* TRY BLOCK START */
            
            try
            {
            /* Preparing Statment Section Start */                
                statment = con.prepareStatement(statString);
                statment.setString(1, date);
                //statment.setInt(2, CustID);
            /* Preparing Statment Section Stop */
            /* Query Section Start */
                results = statment.executeQuery();
                
            /* Query Section Stop */
            
            /* Metadata Section Start*/
                //ResultSetMetaData metaData = results.getMetaData();
            /* Metadata Section Start*/
                
            /* ArrayList Prepare Section Start */
                
                
                
                while (results.next())
                {
                    Reservation temp = new Reservation();
                    
                    //results.getBigDecimal("AMOUNT")
                    
                    
                    temp.setAirline(results.getString("Airline"));
                    temp.setComment(results.getString("Comment"));
                    temp.setCustomerID(results.getInt("CustomerID"));
                    temp.setDate(results.getString("Date"));
                    temp.setDropOffTime(results.getDouble("DropOffTime"));
                    temp.setFlightNumber(results.getString("FlightNumber"));
                    temp.setFlightTime(results.getDouble("FlightTime"));
                    temp.setFranchiseNumber(results.getInt("FranchiseNumber"));
                    temp.setPickUpTime(results.getDouble("PickUpTime"));
                    temp.setPrice(results.getDouble("Price"));
                    temp.setReservationNumber(results.getString("ReservationNumber"));
                    temp.setStatus(results.getString("Status"));
                    temp.setVehicleID(results.getInt("VehicleID"));
                    temp.setAltAddress(results.getString("AltAddress"));
                    temp.setAltCity(results.getString("AltCity"));
                    temp.setAltState(results.getString("AltState"));
                    temp.setAltZip(results.getInt("AltZip"));
                    
                    BPArrayList.add(temp);
                }
            /* ArrayList Prepare Section Stop */
            }
            catch(SQLException sqlE)
            {
                if(sqlE.getErrorCode() == 1142)
                    throw(new UnauthorizedUserException("AccessDenied"));
                else if(sqlE.getErrorCode() == 1062)
                    throw(new DoubleEntryException("DoubleEntry"));
                else 
                    throw(new BadConnectionException("BadConnection"));
            }
            finally
            {
                try
                {
                    if (results != null) results.close();
                }
                catch (Exception e) {};
                try
                {
                    if (statment != null) statment.close();
                }
                catch (Exception e) {};

            }
        /* TRY BLOCK STOP*/
        
            
        /* Return to Buisness Section Start */ 
            return BPArrayList;
        /* Return to Buisness Section Start */
    }