Class GetResources

java.lang.Object

org.deltava.dao.DAO

org.deltava.dao.GetResources

public class GetResources
extends DAO

A Data Access Object to load Web Resource data.

Since:

1.0

Version:

10.4

Author:

Luke

Field Summary

Fields inherited from class org.deltava.dao.DAO

_queryMax, _queryStart, _queryTimeout, WGS84_SRID

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method	Description
Resource	get(int id)	Returns a Web Resource.
Collection<Resource>	getAll(String catName, int id, String orderBy)	Returns Web Resources available to a particular user.
Collection<Resource>	getAll(String catName, String orderBy)	Returns all Web Resources.
Collection<Resource>	getByCertification(String dbName, String certName)	Returns all Resources associated with a particular Flight Academy certification.

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

GetResources

public GetResources(Connection c)

Initializes the Data Access Object.

Parameters:

c - the JDBC connection to use

Method Details

get

public Resource get(int id)
             throws DAOException

Returns a Web Resource.

Parameters:

id - the database ID

Returns:

the Resource bean, or null if not found

Throws:

DAOException - if a JDBC error occurs

getAll

public Collection<Resource> getAll(String catName,
 String orderBy)
                            throws DAOException

Returns all Web Resources.

Parameters:

catName - the category name, or null

orderBy - the sorting SQL fragment

Returns:

a Collection of Resource beans

Throws:

DAOException - if a JDBC error occurs

getAll

public Collection<Resource> getAll(String catName,
 int id,
 String orderBy)
                            throws DAOException

Returns Web Resources available to a particular user.

Parameters:

catName - the category name, or null

id - the user's database ID

orderBy - the sorting SQL fragment

Returns:

a Collection of Resource beans

Throws:

DAOException - if a JDBC error occurs

getByCertification

public Collection<Resource> getByCertification(String dbName,
 String certName)
                                        throws DAOException

Returns all Resources associated with a particular Flight Academy certification.

Parameters:

dbName - the database name

certName - the Certification name

Returns:

a Collection of Resource beans

Throws:

DAOException - if a JDBC error occurs