public  ArrayList<Vehicle> GetOneVehicle(int VID)
             throws UnauthorizedUserException, BadConnectionException, DoubleEntryException
    {
        /* Variable Section Start */
            /* Database and Query Preperation */
            PreparedStatement statment = null;
            ResultSet results = null;
            String statString = "SELECT * FROM 'Vehicle' WHERE 'VehicleID' = ?";

            /* Return Parameter */
            ArrayList<Vehicle> BPList = new ArrayList<Vehicle>();
        /* Variable Section Stop */
        
        
        /* TRY BLOCK START */
            
            try
            {
            /* Preparing Statment Section Start */                
                statment = con.prepareStatement(statString);
                statment.setInt(1, VID);
            /* Preparing Statment Section Stop */
            /* Query Section Start */
                results = statment.executeQuery();
            /* Query Section Stop */
            
            /* Metadata Section Start*/
                //ResultSetMetaData metaData = results.getMetaData();
            /* Metadata Section Start*/
                
            /* List Prepare Section Start */
                
                
                
                while (results.next())
                {
                    Vehicle temp = new Vehicle();
                    
                    //rs.getBigDecimal("AMOUNT")
                    
                    temp.setCapacity(results.getInt("Capacity")); 
                    temp.setCondition(results.getString("VCondition")); 
                    temp.setFranchiseNumber(results.getInt("FranchiseNumber"));
                    temp.setMake(results.getString("Make")); 
                    temp.setMileage(results.getString("Mileage")); 
                    temp.setModel(results.getString("Model")); 
                    temp.setRate(results.getDouble("RentalPrice")); 
                    temp.setTablet(results.getString("Tablet"));
                    temp.setVehicleID(results.getInt("VehicleID"));
                    temp.setVin(results.getString("VIN"));
                    temp.setYear(results.getInt("Year"));
                    temp.setvIndex(results.getString("VIndex"));
                    
                    BPList.add(temp);
                }
            /* List 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) {};
            }
        
            
        /* Return to Buisness Section Start */ 
           
            
            
            return BPList;
        /* Return to Buisness Section Start */
        
        
        
    }