Class GetVideos

java.lang.Object

org.deltava.dao.DAO

org.deltava.dao.GetLibrary

org.deltava.dao.GetVideos

public class GetVideos
extends GetLibrary

A Data Access Object to load Videos.

Since:

1.0

Version:

10.2

Author:

Luke

Field Summary

Fields inherited from class org.deltava.dao.DAO

_queryMax, _queryStart, _queryTimeout, WGS84_SRID

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method	Description
Collection<String>	getCertifications(String fName)	Retrieves all Flight Academy certifications associated with a particular video.
Collection<Video>	getVideos()	Returns the contents of the Video Library.
Collection<Video>	getVideos(String certName)	Returns the contents of the Video Library in the current database.

Methods inherited from class org.deltava.dao.GetLibrary

getFile, getFiles, getFleet, getInstaller, getInstallerByCode, getVideo, loadDownloadCount

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

GetVideos

public GetVideos(Connection c)

Initializes the Data Access Object.

Parameters:

c - the JDBC connection to use

Method Details

getVideos

public Collection<Video> getVideos()
                            throws DAOException

Returns the contents of the Video Library.

Returns:

a List of TrainingVideo beans

Throws:

DAOException - if a JDBC error occurs

getVideos

public Collection<Video> getVideos(String certName)
                            throws DAOException

Returns the contents of the Video Library in the current database.

Parameters:

certName - the Certification name, or null if not associated with any Academy certification

Returns:

a List of TrainingVideo beans

Throws:

DAOException - if a JDBC error occurs

getCertifications

public Collection<String> getCertifications(String fName)
                                     throws DAOException

Retrieves all Flight Academy certifications associated with a particular video.

Parameters:

fName - the video file name

Returns:

a Collection of certification names

Throws:

DAOException - if a JDBC error occurs