org.sourceforge.vlibrary.user.dao

Class SubjectDAOSpringJDBCImpl

java.lang.Object

org.sourceforge.vlibrary.user.dao.SubjectDAOSpringJDBCImpl

All Implemented Interfaces:

SubjectDAO

public class SubjectDAOSpringJDBCImpl
extends Object
implements SubjectDAO

Version:

$Revision$ $Date$

Constructor Summary

Constructors

Constructor and Description
SubjectDAOSpringJDBCImpl()

Method Summary

Modifier and Type	Method and Description
Long	getSubjectIdByDescription(Subject subject) Looks up a subject in the database by its description.
ArrayList	getSubjects() Retrieves all subjects from the database
Subject	insert(Subject subject) Inserts a subject into the database and updates the ID of the input subject parameter.
void	insertNewSubjectRecord(Subject subject) Inserts a new subject record into the database, using description field in subject input parameter.
void	setInsertSubjectSQL(String insertSubjectSQL) Used for Spring Dependency Injection
void	setJdbcTemplate(org.springframework.jdbc.core.JdbcTemplate jdbcTemplate) Used for Spring Dependency Injection
void	setResourceBundleMessageSource(org.springframework.context.support.ResourceBundleMessageSource resourceBundleMessageSource) Used for Spring Dependency Injection
void	setSelectAllSubjectsSQL(String selectAllSubjectsSQL) Used for Spring Dependency Injection
void	setSelectSubjectOnDescriptionSQL(String selectSubjectOnDescriptionSQL) Used for Spring Dependency Injection
void	setSubjectIds(ArrayList subjects) Walks input ArrayList, looking up and setting ID properties for each Subject in the list.

Methods inherited from class java.lang.Object

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

Constructor Detail

SubjectDAOSpringJDBCImpl

public SubjectDAOSpringJDBCImpl()

Method Detail

setResourceBundleMessageSource

public void setResourceBundleMessageSource(org.springframework.context.support.ResourceBundleMessageSource resourceBundleMessageSource)

Used for Spring Dependency Injection

setInsertSubjectSQL

public void setInsertSubjectSQL(String insertSubjectSQL)

Used for Spring Dependency Injection

setSelectAllSubjectsSQL

public void setSelectAllSubjectsSQL(String selectAllSubjectsSQL)

Used for Spring Dependency Injection

setSelectSubjectOnDescriptionSQL

public void setSelectSubjectOnDescriptionSQL(String selectSubjectOnDescriptionSQL)

Used for Spring Dependency Injection

setJdbcTemplate

public void setJdbcTemplate(org.springframework.jdbc.core.JdbcTemplate jdbcTemplate)

Used for Spring Dependency Injection

Parameters:

jdbcTemplate - The jdbcTemplate to set.

getSubjectIdByDescription

public Long getSubjectIdByDescription(Subject subject)
                               throws LibraryException

Looks up a subject in the database by its description. Returned Long instance wraps the subject ID. Returns null if there is no subject with the given description.

Specified by:

getSubjectIdByDescription in interface SubjectDAO

Parameters:

subject - Subject instance whose (trimmed) description field is used as the key in the lookup

Returns:

Long object wrapping the subject id, if found; null otherwise

Throws:

LibraryException - if subject is null or has null description

insertNewSubjectRecord

public void insertNewSubjectRecord(Subject subject)
                            throws LibraryException

Inserts a new subject record into the database, using description field in subject input parameter. ID will be generated by the database engine and is not updated on the input parameter.

Parameters:

subject - The new Subject to insert

Throws:

LibraryException - if required fields are missing or an SQL error occurs

insert

public Subject insert(Subject subject)
               throws LibraryException

Inserts a subject into the database and updates the ID of the input subject parameter. First checks to see if a subject with same description exists. If so, no insert is performed, but id is updated to the id of the previously existing record. If the subject is new, a record with the given description is inserted and the ID of the input subject instance is updated to the ID of the newly inserted record.

Specified by:

insert in interface SubjectDAO

Parameters:

subject - The Subject to insert

Returns:

subject fully populated Subject object, incl subject id

Throws:

LibraryException - if subject is null or has null description or a database access error occurs

getSubjects

public ArrayList getSubjects()
                      throws LibraryException

Retrieves all subjects from the database

Specified by:

getSubjects in interface SubjectDAO

Returns:

ArrayList of Subject instances, if none found returns an empty ArrayList

Throws:

LibraryException

setSubjectIds

public void setSubjectIds(ArrayList subjects)
                   throws LibraryException

Walks input ArrayList, looking up and setting ID properties for each Subject in the list. Lookup is based on description property. If a Subject is not found, a new entry is inserted into the database and the ID of the newly created record is assigned to the instance.

Specified by:

setSubjectIds in interface SubjectDAO

Parameters:

subjects - = ArrayList of Subjects

Throws:

LibraryException