Class GetSystemInfo

java.lang.Object

org.deltava.dao.DAO

org.deltava.dao.GetSystemInfo

public class GetSystemInfo
extends DAO

A Data Access Object to retrieve ACARS System Information data.

Since:

1.0

Version:

9.0

Author:

Luke

Field Summary

Fields inherited from class org.deltava.dao.DAO

_queryMax, _queryStart, _queryTimeout, WGS84_SRID

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method	Description
SystemInformation	get(int id)	Returns system configuration data for a particular Pilot.
SystemInformation	get(int id, Simulator sim, Instant dt)	Returns system configuration data for a particular Pilot.
List<SystemStatistics<Integer>>	getStatistics(String groupBy, boolean sortLabel)	Returns Fleet Installer statistics for a particular database field.
int	getTotals()	Returns the total number of statistics entries for totals calculation.

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

GetSystemInfo

public GetSystemInfo(Connection c)

Initializes the Data Access Object.

Parameters:

c - the JDBC connection to use

Method Details

getTotals

public int getTotals()
              throws DAOException

Returns the total number of statistics entries for totals calculation.

Returns:

the total number of entries

Throws:

DAOException - if a JDBC error occurs

get

public SystemInformation get(int id)
                      throws DAOException

Returns system configuration data for a particular Pilot.

Parameters:

id - the user's database ID

Returns:

a SystemInformation bean, or null if not found

Throws:

DAOException - if a JDBC error occurs

get

public SystemInformation get(int id,
 Simulator sim,
 Instant dt)
                      throws DAOException

Returns system configuration data for a particular Pilot.

Parameters:

id - the user's database ID

sim - an optional Simulator bean

dt - the date/time of the configuration recording

Returns:

a SystemInformation bean, or null if not found

Throws:

DAOException - if a JDBC error occurs

getStatistics

public List<SystemStatistics<Integer>> getStatistics(String groupBy,
 boolean sortLabel)
                                              throws DAOException

Returns Fleet Installer statistics for a particular database field.

Parameters:

groupBy - the database field to group by

sortLabel - TRUE if sorted by label, FALSE if sorted by total

Returns:

a List of InstallerStatistics beans

Throws:

DAOException - if a JDBC error occurs