Class GetExamStatistics

java.lang.Object

org.deltava.dao.DAO

org.deltava.dao.GetExamStatistics

public class GetExamStatistics
extends DAO

A Data Access Object to load Examination and Check Ride statistics.

Since:

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

Method Summary

Modifier and Type	Method	Description
Collection<Integer>	getCheckRideScorerIDs()	Returns the datbase IDs of all individuals in the current airline who scored an check ride.
Collection<ExamStatsEntry>	getCheckrideStatistics(String label, String subLabel, boolean academyOnly)	Returns check ride statistics.
Collection<ExamStatsEntry>	getCheckrideStatistics(String label, String subLabel, boolean academyOnly, int scorerID, String eqProgram)	Returns check ride statistics.
Collection<Integer>	getExamScorerIDs()	Returns the datbase IDs of all individuals in the current airline who scored an examination.
Collection<ExamStatsEntry>	getExamStatistics(String label, String subLabel)	Returns pilot examination statistics.
Collection<ExamStatsEntry>	getExamStatistics(String label, String subLabel, int scorerID)	Returns pilot examination statistics.

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

GetExamStatistics

public GetExamStatistics(Connection c)

Initializes the Data Access Object.

Parameters:

c - the JDBC connection to use

Method Details

getCheckRideScorerIDs

public Collection<Integer> getCheckRideScorerIDs()
                                          throws DAOException

Returns the datbase IDs of all individuals in the current airline who scored an check ride.

Returns:

a Collection of database IDs

Throws:

DAOException - if a JDBC error occurs

getExamScorerIDs

public Collection<Integer> getExamScorerIDs()
                                     throws DAOException

Returns the datbase IDs of all individuals in the current airline who scored an examination.

Returns:

a Collection of database IDs

Throws:

DAOException - if a JDBC error occurs

getExamStatistics

public Collection<ExamStatsEntry> getExamStatistics(String label,
 String subLabel)
                                             throws DAOException

Returns pilot examination statistics.

Parameters:

label - the label SQL

subLabel - the sub-label SQL

Returns:

a Collection of ExamStatsEntry beans

Throws:

DAOException - if a JDBC error occurs

getExamStatistics

public Collection<ExamStatsEntry> getExamStatistics(String label,
 String subLabel,
 int scorerID)
                                             throws DAOException

Returns pilot examination statistics.

Parameters:

label - the label SQL

subLabel - the sub-label SQL

scorerID - the examination scorer's database ID, or zero

Returns:

a Collection of ExamStatsEntry beans

Throws:

DAOException - if a JDBC error occurs

getCheckrideStatistics

public Collection<ExamStatsEntry> getCheckrideStatistics(String label,
 String subLabel,
 boolean academyOnly)
                                                  throws DAOException

Returns check ride statistics.

Parameters:

label - the label SQL

subLabel - the sub-label SQL

academyOnly - TRUE if only Flight Academy check rides are included, otherwise FALSE

Returns:

a Collection of ExamStatsEntry beans

Throws:

DAOException - if a JDBC error occurs

getCheckrideStatistics

public Collection<ExamStatsEntry> getCheckrideStatistics(String label,
 String subLabel,
 boolean academyOnly,
 int scorerID,
 String eqProgram)
                                                  throws DAOException

Returns check ride statistics.

Parameters:

label - the label SQL

subLabel - the sub-label SQL

academyOnly - TRUE if only Flight Academy check rides are included, otherwise FALSE

scorerID - the check ride scorer's database ID, or zero

eqProgram - an Equipment Type program, or null for all

Returns:

a Collection of ExamStatsEntry beans

Throws:

DAOException - if a JDBC error occurs