Class GetACARSData

java.lang.Object
org.deltava.dao.DAO
org.deltava.dao.GetACARSData
Direct Known Subclasses:
GetACARSLog, GetACARSPositions, GetACARSPurge, GetDispatchCalendar
public class GetACARSData extends DAO
A Data Access Object to load ACARS information.
Since:
1.0
Version:
11.6
Author:
Luke

  • Constructor Details

    • GetACARSData

      public GetACARSData(Connection c)
      Initializes the Data Access Object.
      Parameters:
      c - the JDBC connection to use

  • Method Details

    • getArchiveInfo

      public ArchiveMetadata getArchiveInfo(int flightID) throws DAOException
      Retrieves position archive metadata about a flight.
      Parameters:
      flightID - the flight ID
      Returns:
      an ArchiveMetadata bean, or null if not found
      Throws:
      DAOException - if a JDBC error occurs

    • getTakeoffLanding

      public List<ACARSRouteEntry> getTakeoffLanding(int flightID) throws DAOException
      Retrieves the takeoff and landing coordinates for a particular flight. More than two results may be returned, if the aircraft bounced on takeoff and/or landing.
      Parameters:
      flightID - the flight ID
      Returns:
      a List of RouteEntry beans, ordered by time
      Throws:
      DAOException - if a JDBC error occurs

    • getLandingRunway

      public RunwayDistance getLandingRunway(int flightID) throws DAOException
      Returns landing runway distance for a particular flight.
      Parameters:
      flightID - the ACARS flight ID
      Returns:
      a RunwayDistance bean, or null if not found
      Throws:
      DAOException - if a JDBC error occurs

    • getRoute

      public String getRoute(int flightID) throws DAOException
      Returns the filed route for a particular ACARS flight.
      Parameters:
      flightID - the ACARS flight ID
      Returns:
      the filed route
      Throws:
      DAOException - if a JDBC error occurs

    • getInfo

      public FlightInfo getInfo(int flightID) throws DAOException
      Returns information about a particular ACARS flight.
      Parameters:
      flightID - the ACARS flight ID
      Returns:
      the Flight Information, nor null if not found
      Throws:
      DAOException - if a JDBC error occurs

    • getConnection

      public ConnectionEntry getConnection(long conID) throws DAOException
      Returns information about a particular ACARS connection.
      Parameters:
      conID - the ACARS connection ID
      Returns:
      the Connection information, or null if not found
      Throws:
      DAOException - if a JDBC error occurs

    • getTerminalRoutes

      protected Map<TerminalRoute.Type, TerminalRoute> getTerminalRoutes(int id) throws DAOException
      Loads the Terminal Routes used on a particular ACARS flight.
      Parameters:
      id - the ACARS flight ID
      Returns:
      a Map of TerminalRoutes, keyed by route type
      Throws:
      DAOException - if a JDBC error occurs

    • executeFlightInfo

      protected static List<FlightInfo> executeFlightInfo(PreparedStatement ps) throws SQLException
      Helper method to parse Flight Info result sets.
      Parameters:
      ps - a PreparedStatement
      Returns:
      a List of FlightInfo beans
      Throws:
      SQLException - if an error occurs

    • executeConnectionInfo

      protected static List<ConnectionEntry> executeConnectionInfo(PreparedStatement ps) throws SQLException
      Helper method to parse Connection result sets.
      Parameters:
      ps - a PreparedStatement
      Returns:
      a List of ConnectionEntry beans
      Throws:
      SQLException - if an error occurs