Class SetSignatureImage

java.lang.Object

org.deltava.dao.DAO

org.deltava.dao.SetSignatureImage

public class SetSignatureImage
extends DAO

A Data Access Object to write Signature Images.

Since:

1.0

Version:

9.0

Author:

Luke

Field Summary

Fields inherited from class org.deltava.dao.DAO

_queryMax, _queryStart, _queryTimeout, WGS84_SRID

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method	Description
void	delete(int pilotID)	Removes a Signature Image from the database.
void	write(Pilot p, int x, int y, String ext, boolean isApproved)	Writes a Signature Image 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

SetSignatureImage

public SetSignatureImage(Connection c)

Initialize the Data Access Object.

Parameters:

c - the JDBC connection to use

Method Details

write

public void write(Pilot p,
 int x,
 int y,
 String ext,
 boolean isApproved)
           throws DAOException

Writes a Signature Image to the Database. The image data should be contained within the Pilot bean.

Parameters:

p - the Pilot containing the Signature image

x - the Image width in pixels

y - the Image height in pixels

ext - the Image extension

isApproved - whether the signature has been approved by management

Throws:

DAOException - if a JDBC error occurs

See Also:

• Pilot.getHasSignature()

delete

public void delete(int pilotID)
            throws DAOException

Removes a Signature Image from the database.

Parameters:

pilotID - the Pilot ID

Throws:

DAOException - if a JDBC error occurs