Class GetStatusUpdate

java.lang.Object
org.deltava.dao.DAO
org.deltava.dao.GetStatusUpdate
public class GetStatusUpdate extends DAO
A Data Access Object to read Status Update log entries.
Since:
1.0
Version:
9.0
Author:
Luke

  • Constructor Details

    • GetStatusUpdate

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

  • Method Details

    • getByUser

      public List<StatusUpdate> getByUser(int id, String dbName) throws DAOException
      Retrieves all Status Updates for a particular Pilot. The firstName and lastName properties will be populated by the Status Update's author name, not the pilot name.
      Parameters:
      id - the Pilot ID
      dbName - the database name
      Returns:
      a List of StatusUpdate beans, sorted by descending date
      Throws:
      DAOException - if a JDBC error occurs

    • isSeniorCaptain

      public boolean isSeniorCaptain(int id) throws DAOException
      Returns if a particular Pilot has been promoted to Senior Captain.
      Parameters:
      id - the Pilot's database ID
      Returns:
      TRUE if the Pilot has a StatusUpdate entry promoting to Senior Captain, otherwise FALSE
      Throws:
      DAOException - if a JDBC error occurs
      See Also:

    • getByType

      public List<StatusUpdate> getByType(UpdateType updateType) throws DAOException
      Returns all Status Updates with a given type.
      Parameters:
      updateType - the Status Update type
      Returns:
      a List of StatusUpdate beans
      Throws:
      DAOException - if a JDBC error occurs

    • getByType

      public List<StatusUpdate> getByType(UpdateType updateType, int maxHours) throws DAOException
      Returns all Status Updates with a given type and time period.
      Parameters:
      updateType - the Status Update type
      maxHours - the maximum elapsed time in hours, or zero for all
      Returns:
      a List of StatusUpdate beans
      Throws:
      DAOException - if a JDBC error occurs