Class GetChart
java.lang.Object
org.deltava.dao.DAO
org.deltava.dao.GetChart
A Data Access Object for Approach Charts.
- Since:
- 1.0
- Version:
- 10.6
- Author:
- Luke
-
Field Summary
Fields inherited from class org.deltava.dao.DAO
_queryMax, _queryStart, _queryTimeout, WGS84_SRID
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionget
(int id) Returns a Chart based on its Database ID.Returns all Airports with available charts.getByIDs
(Collection<Integer> IDs) Retrieves Charts based on a group of database IDs.getChartIDs
(Collection<String> externalIDs) Returns the database IDs for a set of external Chart IDs.Returns all Chart metadata for a particular Airport.getChartsByEvent
(int eventID) Returns all Charts for a particular Event.Returns the average age of charts.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
-
Constructor Details
-
GetChart
Creates the DAO with a JDBC connection.- Parameters:
c
- the JDBC connection to use
-
-
Method Details
-
getAirports
Returns all Airports with available charts.- Returns:
- a List of Airports
- Throws:
DAOException
- if a JDBC error occurs
-
getMaxAges
Returns the average age of charts.- Returns:
- a Map of maximum ages in days, keyed by Airport
- Throws:
DAOException
- if a JDBC error occurs
-
getCharts
Returns all Chart metadata for a particular Airport.- Parameters:
a
- the Airport bean- Returns:
- a List of Chart objects
- Throws:
DAOException
- if a JDBC error occurs
-
getChartsByEvent
Returns all Charts for a particular Event.- Parameters:
eventID
- the event Database ID- Returns:
- a List of Chart objects
- Throws:
DAOException
- if a JDBC error occurs
-
get
Returns a Chart based on its Database ID.- Parameters:
id
- the database id- Returns:
- the Chart
- Throws:
DAOException
- if a JDBC error occurs
-
getByIDs
Retrieves Charts based on a group of database IDs.- Parameters:
IDs
- a Collection of database IDs as Integers- Returns:
- a Collection of Charts
- Throws:
DAOException
- if a JDBC error occurs
-
getChartIDs
Returns the database IDs for a set of external Chart IDs.- Parameters:
externalIDs
- a Collection of external chart IDs- Returns:
- a Map of database IDs, keyed by external ID
- Throws:
DAOException
- See Also:
-