Class GetSimBriefPackages

java.lang.Object

org.deltava.dao.DAO

org.deltava.dao.GetSimBriefPackages

public class GetSimBriefPackages
extends DAO

A Data Access Object to load SimBrief briefing package data.

Since:

10.4

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
GetSimBriefPackages(Connection c)	Initializes the Data Access Object.

Method Summary

Modifier and Type	Method	Description
List<Airframe>	getAirframes(String eqType, Airline a, int pilotID)	Returns all aircraft tail codes used for flights in a given Equipment Type and Airline.
BriefingPackage	getSimBrief(int id, String db)	Loads a SimBrief briefing package for a Flight Report.

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

GetSimBriefPackages

public GetSimBriefPackages(Connection c)

Initializes the Data Access Object.

Parameters:

c - the JDBC connectiont o use

Method Details

getSimBrief

public BriefingPackage getSimBrief(int id,
 String db)
                            throws DAOException

Loads a SimBrief briefing package for a Flight Report.

Parameters:

id - the Flight Report database ID

db - the database name

Returns:

a SimBrief package, or null if not found

Throws:

DAOException - if a JDBC error occurs

getAirframes

public List<Airframe> getAirframes(String eqType,
 Airline a,
 int pilotID)
                            throws DAOException

Returns all aircraft tail codes used for flights in a given Equipment Type and Airline.

Parameters:

eqType - the Equipment Type

a - the Airline

pilotID - the Pilot database ID, or zero for all Pilots

Returns:

a List of Airframes, order by descending popularity

Throws:

DAOException - if a JDBC error occurs