Class GetAcademyCertifications

java.lang.Object
org.deltava.dao.DAO
org.deltava.dao.GetAcademyCertifications
public class GetAcademyCertifications extends DAO
A Data Access Object to load Flight Academy Certifications and Check Ride scripts.
Since:
1.0
Version:
10.1
Author:
Luke

  • Constructor Details

    • GetAcademyCertifications

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

  • Method Details

    • get

      public Certification get(String name) throws DAOException
      Loads a Flight Academy Certification profile.
      Parameters:
      name - the Certification name
      Returns:
      a Certification bean, or null if not found
      Throws:
      DAOException - if a JDBC error occurs

    • getActive

      public Collection<Certification> getActive() throws DAOException
      Loads all active Flight Academy Certification profiles.
      Returns:
      a Collection of Certification beans
      Throws:
      DAOException - if a JDBC error occurs

    • getAll

      public Collection<Certification> getAll() throws DAOException
      Loads all Flight Academy Certification profiles.
      Returns:
      a Collection of Certification beans
      Throws:
      DAOException - if a JDBC error occurs

    • getWithGraduates

      public Collection<Certification> getWithGraduates(boolean visibleOnly) throws DAOException
      Loads all Flight Academy Certification profiles with at least one Graduate.
      Parameters:
      visibleOnly - TRUE to only list visible Certifications, otherwise FALSE
      Returns:
      a Collection of Certification beans
      Throws:
      DAOException - if a JDBC error occurs

    • getScript

      public AcademyRideScript getScript(AcademyRideID id) throws DAOException
      Loads a specific Flight Academy Check Ride script from the datbaase.
      Parameters:
      id - the Check Ride ID
      Returns:
      an AcademyRideScript bean, or null if none
      Throws:
      DAOException - if a JDBC error occurs

    • getScripts

      public Collection<AcademyRideScript> getScripts() throws DAOException
      Loads all Flight Academy Check Ride scripts from the database.
      Returns:
      a Collection of AcademyRideScript beans
      Throws:
      DAOException - if a JDBC error occurs