Class GetACARSTaxiTimes

java.lang.Object

org.deltava.dao.DAO

org.deltava.dao.GetACARSTaxiTimes

public class GetACARSTaxiTimes
extends DAO

A Data Access Object to calculate average taxi times.

Since:

8.6

Version:

11.2

Author:

Luke

Field Summary

Fields inherited from class org.deltava.dao.DAO

_queryMax, _queryStart, _queryTimeout, WGS84_SRID

Constructor Summary

Constructors

Constructor	Description
GetACARSTaxiTimes(Connection c)	Initializes the Data Access Object.

Method Summary

Modifier and Type	Method	Description
TaxiTime	getTaxiTime(int flightID)	Retrieves the taxi times for a flight.
TaxiTime	getTaxiTime(Airport a)	Retrieves the average taxi time for an Airport.
TaxiTime	getTaxiTime(Airport a, int year)	Retrieves the average taxi time for an Airport in a given year.
boolean	hasTimes(int id)	Returns whether a given ACARS flight has logged taxi times.

Methods inherited from class org.deltava.dao.DAO

commitTransaction, createTimestamp, executeIDs, executeUpdate, executeUpdate, expandDate, formatDBName, formatLocation, getNewID, getQueryCount, prepare, prepareWithoutLimits, rollbackTransaction, setQueryMax, setQueryStart, setQueryTimeout, startTransaction, toID, toID, toInstant

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

GetACARSTaxiTimes

public GetACARSTaxiTimes(Connection c)

Initializes the Data Access Object.

Parameters:

c - the JDBC Connection to use

Method Details

getTaxiTime

public TaxiTime getTaxiTime(Airport a,
 int year)
                     throws DAOException

Retrieves the average taxi time for an Airport in a given year.

Parameters:

a - the Airport

year - the year

Returns:

a TaxiTime

Throws:

DAOException - if a JDBC error occurs

getTaxiTime

public TaxiTime getTaxiTime(Airport a)
                     throws DAOException

Retrieves the average taxi time for an Airport.

Parameters:

a - the Airport

Returns:

a TaxiTime

Throws:

DAOException - if a JDBC error occurs

getTaxiTime

public TaxiTime getTaxiTime(int flightID)
                     throws DAOException

Retrieves the taxi times for a flight.

Parameters:

flightID - the ACARS Flight ID

Returns:

a TaxiTime

Throws:

DAOException - if a JDBC error occurs

hasTimes

public boolean hasTimes(int id)
                 throws DAOException

Returns whether a given ACARS flight has logged taxi times.

Parameters:

id - the ACARS Flight ID

Returns:

TRUE if taxi times have been logged, otherwise FALSE

Throws:

DAOException - if a JDBC error occurs