Class GetGallery

java.lang.Object
org.deltava.dao.DAO
org.deltava.dao.GetGallery
public class GetGallery extends DAO
A Data Access Object to load Image Gallery data.
Since:
1.0
Version:
10.6
Author:
Luke

  • Constructor Details

    • GetGallery

      public GetGallery(Connection c)
      Initializes the DAO with a given JDBC connection.
      Parameters:
      c - the JDBC Connection

  • Method Details

    • getImageData

      public Image getImageData(int id, String dbName) throws DAOException
      Returns the metadata associated with a particular Gallery image.
      Parameters:
      id - the Image id
      dbName - the database name
      Returns:
      an Image, or null if the id was not found
      Throws:
      DAOException - if a JDBC error occurs

    • getFleetGallery

      public List<Image> getFleetGallery() throws DAOException
      Returns all the image metadata associated with the Fleet Gallery. No vote data is returned .
      Returns:
      a List of Images in the Fleet Gallery
      Throws:
      DAOException - if a JDBC error occurs

    • getPictureGallery

      public List<Image> getPictureGallery(Instant dt) throws DAOException
      Returns Images in the Image Gallery created on a specific date.
      Parameters:
      dt - the date the image was posted
      Returns:
      a List of Image beans
      Throws:
      DAOException - if a JDBC error occurs

    • getUserGallyer

      public List<Image> getUserGallyer(int pilotID) throws DAOException
      Returns Images created by a particular Pilot.
      Parameters:
      pilotID - the Pilot's database ID
      Returns:
      a List of Image beans
      Throws:
      DAOException - if a JDBC error occurs

    • getPictureGallery

      public List<Image> getPictureGallery(String orderBy, String month) throws DAOException
      Returns Images in the Image Gallery. This can optionally select a month's worth of Images.
      Parameters:
      orderBy - the SQL ORDER BY clause
      month - the optional month name, in "MMMM YYYY" format
      Returns:
      a Collection of Image beans
      Throws:
      DAOException - if a JDBC error occurs

    • getMonths

      public Collection<String> getMonths() throws DAOException
      Loads the Months with Images in the Gallery.
      Returns:
      a Collection of Month/Year values
      Throws:
      DAOException - if a JDBC error occurs