Class SetGalleryImage

java.lang.Object

org.deltava.dao.DAO

org.deltava.dao.SetGalleryImage

public class SetGalleryImage
extends DAO

A Data Access Object to write Picture Gallery images.

Since:

1.0

Version:

10.6

Author:

Luke

Field Summary

Fields inherited from class DAO

_queryMax, _queryStart, _queryTimeout, WGS84_SRID

Constructor Summary

Constructors

Constructor	Description
SetGalleryImage(Connection c)	Initialize the Data Access Object.

Method Summary

Modifier and Type	Method	Description
void	delete(int id)	Deletes a Gallery Image from the database.
void	delete(int imgID, int pilotID)	Deletes an Image Vote from the database.
void	like(int userID, int imgID)	Writes a new Image Like to the database.
void	update(Image img)	Updates a Gallery Image's name and description.
void	write(Image img)	Writes a new Image to the database.

Methods inherited from class 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 Object

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

Constructor Details

SetGalleryImage

public SetGalleryImage(Connection c)

Initialize the Data Access Object.

Parameters:

c - the JDBC connection to use

Method Details

write

public void write(Image img)
           throws DAOException

Writes a new Image to the database.

Parameters:

img - the Image object, with its image buffer populated

Throws:

DAOException - if a JDBC error occurs

IllegalArgumentException - if the buffer is empty

update

public void update(Image img)
            throws DAOException

Updates a Gallery Image's name and description.

Parameters:

img - the Image bean

Throws:

DAOException - if a JDBC error occurs

like

public void like(int userID,
 int imgID)
          throws DAOException

Writes a new Image Like to the database.

Parameters:

userID - the database ID of the Person liking the Image

imgID - the image database ID

Throws:

DAOException - if a JDBC error occurs

delete

public void delete(int id)
            throws DAOException

Deletes a Gallery Image from the database. This will automatically remove links from Water Cooler threads.

Parameters:

id - the Image Database ID

Throws:

DAOException - if a JDBC error occurs

delete

public void delete(int imgID,
 int pilotID)
            throws DAOException

Deletes an Image Vote from the database.

Parameters:

imgID - the Image Database ID

pilotID - the voting Pilot's Database ID

Throws:

DAOException - if a JDBC error occurs