Class SetAccomplishment

java.lang.Object

org.deltava.dao.DAO

org.deltava.dao.SetAccomplishment

public class SetAccomplishment
extends DAO

A Data Access Object to save Accomplishment profiles.

Since:

3.2

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
SetAccomplishment(Connection c)	Initializes the Data Access Object.

Method Summary

Modifier and Type	Method	Description
void	achieve(int pilotID, Accomplishment a, Instant dt)	Records a Pilot accomplishment.
void	clearAchievement(int pilotID, Accomplishment a)	Deletes a Pilot Accomplishment record from the database.
void	delete(int id)	Deletes an Accomplishment profile from the database.
void	write(Accomplishment a)	Writes an Accomplishment to the database.

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

SetAccomplishment

public SetAccomplishment(Connection c)

Initializes the Data Access Object.

Parameters:

c - the JDBC connection to use

Method Details

write

public void write(Accomplishment a)
           throws DAOException

Writes an Accomplishment to the database.

Parameters:

a - the Accomplishment bean

Throws:

DAOException - if a JDBC error occurs

achieve

public void achieve(int pilotID,
 Accomplishment a,
 Instant dt)
             throws DAOException

Records a Pilot accomplishment.

Parameters:

pilotID - the Pilot's database ID

a - the Accomplishment

dt - the date/time of the accomplishment

Throws:

DAOException - if a JDBC error occurs

clearAchievement

public void clearAchievement(int pilotID,
 Accomplishment a)
                      throws DAOException

Deletes a Pilot Accomplishment record from the database.

Parameters:

pilotID - the Pilot's datbaase ID

a - the Accomplishment

Throws:

DAOException - if a JDBC error occurs

delete

public void delete(int id)
            throws DAOException

Deletes an Accomplishment profile from the database.

Parameters:

id - the Accomplishment database ID

Throws:

DAOException - if a JDBC error occurs