Class SetJobs

java.lang.Object

org.deltava.dao.DAO

org.deltava.dao.SetJobs

public class SetJobs
extends DAO

A Data Access Object to write Job Postings and Applications to the database.

Since:

3.4

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

Method Summary

Modifier and Type	Method	Description
void	deleteApplication(int id)	Deletes a job application from the database.
void	deleteJob(int id)	Deletes a job posting from the database.
void	deleteProfile(int id)	Deletes an applicant profile from the database.
void	write(Application a)	Writes a Job Application to the database.
void	write(Comment c)	Writes a Job Posting comment to the database.
void	write(JobPosting jp)	Writes a job posting to the daatabase.
void	write(Profile p)	Writes an applicant profile 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

SetJobs

public SetJobs(Connection c)

Initializes the Data Access Object.

Parameters:

c - the JDBC connection to use

Method Details

write

public void write(JobPosting jp)
           throws DAOException

Writes a job posting to the daatabase. This can handle INSERTs and UPDATEs.

Parameters:

jp - the JobPosting bean

Throws:

DAOException - if a JDBC error occurs

write

public void write(Application a)
           throws DAOException

Writes a Job Application to the database.

Parameters:

a - an Application bean

Throws:

DAOException - if a JDBC error occurs

write

public void write(Profile p)
           throws DAOException

Writes an applicant profile to the database.

Parameters:

p - the Profile bean

Throws:

DAOException - if a JDBC error occurs

write

public void write(Comment c)
           throws DAOException

Writes a Job Posting comment to the database.

Parameters:

c - the Comment bean

Throws:

DAOException - if a JDBC error occurs

deleteJob

public void deleteJob(int id)
               throws DAOException

Deletes a job posting from the database.

Parameters:

id - the database ID

Throws:

DAOException - if a JDBC error occurs

deleteApplication

public void deleteApplication(int id)
                       throws DAOException

Deletes a job application from the database.

Parameters:

id - the application author database ID

Throws:

DAOException - if a JDBC error occurs

deleteProfile

public void deleteProfile(int id)
                   throws DAOException

Deletes an applicant profile from the database.

Parameters:

id - the profile database ID

Throws:

DAOException - if a JDBC error occurs