org.deltava.dao
Class GetPilotBoard

java.lang.Object
  org.deltava.dao.DAO
      org.deltava.dao.GetPilotBoard

public class GetPilotBoard
extends DAO

A Data Access Object to display pilot locations.

Since:

2.5

Version:

2.5

Author:

Luke

Field Summary

Fields inherited from class org.deltava.dao.DAO

_ps, _queryMax, _queryStart, _queryTimeout

Constructor Summary

GetPilotBoard(Connection c)
Initializes the Data Access Object.

Method Summary

Map<Integer,GeoLocation>	getAll() Returns the locations of pilots who have signed up for the Pilot location board.
Map<Integer,GeoLocation>	getByID(Collection<Integer> ids) Returns the location of Pilots who have signed up for the Pilot location board.
GeoLocation	getLocation(int pilotID) Returns the location of the specified Pilot.

Methods inherited from class org.deltava.dao.DAO

commitTransaction, createTimestamp, executeUpdate, expandDate, formatDBName, getNewID, getQueryCount, prepareStatement, prepareStatementWithoutLimits, rollbackTransaction, setManualCommit, setQueryMax, setQueryStart, setQueryTimeout, startTransaction

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

GetPilotBoard

public GetPilotBoard(Connection c)

Initializes the Data Access Object.

Parameters:

c - the JDBC connection to use

Method Detail

getLocation

public GeoLocation getLocation(int pilotID)
                        throws DAOException

Returns the location of the specified Pilot.

Parameters:

pilotID - the Pilot's database ID

Returns:

a GeoLocation with the pilot's location, or null if none specified

Throws:

DAOException

getAll

public Map<Integer,GeoLocation> getAll()
                                throws DAOException

Returns the locations of pilots who have signed up for the Pilot location board.

Returns:

a Map of GeoLocation objects, keyed by database ID

Throws:

DAOException - if a JDBC error occurs

getByID

public Map<Integer,GeoLocation> getByID(Collection<Integer> ids)
                                 throws DAOException

Returns the location of Pilots who have signed up for the Pilot location board.

Parameters:

ids - a Collection of Pilot database IDs

Returns:

a Map of GeoLocation objects, keyed by database ID

Throws:

DAOException - if a JDBC error occurs