org.sourceforge.vlibrary.user.dao

Class AuthorDAOSpringJDBCImpl

java.lang.Object

org.sourceforge.vlibrary.user.dao.AuthorDAOSpringJDBCImpl

All Implemented Interfaces:

AuthorDAO

public class AuthorDAOSpringJDBCImpl
extends Object
implements AuthorDAO

Implementation of author data access interface.

Version:

$Revision$ $Date$

Constructor Summary

Constructors

Constructor and Description
AuthorDAOSpringJDBCImpl()

Method Summary

Modifier and Type	Method and Description
Long	findAuthorByFirstLastName(Author author) Finds the id of the given Author object in the database, using the firstName and lastName properties to lookup the record.
void	insert(Author author) Inserts the given author into the database.
void	insertNewAuthor(Author author) Insert a new Author into the DB.
void	setAuthorIds(ArrayList authors) Walks input ArrayList, looking up and setting ID properties for each Author in the list.
void	setInsertAuthorByFirstlastNameSQL(String insertAuthorByFirstlastNameSQL) 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	setSelectAuthorByFirstLastNameSQL(String selectAuthorByFirstLastNameSQL) Used for Spring Dependency Injection

Methods inherited from class java.lang.Object

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

Constructor Detail

AuthorDAOSpringJDBCImpl

public AuthorDAOSpringJDBCImpl()

Method Detail

setSelectAuthorByFirstLastNameSQL

public void setSelectAuthorByFirstLastNameSQL(String selectAuthorByFirstLastNameSQL)

Used for Spring Dependency Injection

setInsertAuthorByFirstlastNameSQL

public void setInsertAuthorByFirstlastNameSQL(String insertAuthorByFirstlastNameSQL)

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.

setResourceBundleMessageSource

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

Used for Spring Dependency Injection

insert

public void insert(Author author)
            throws LibraryException

Description copied from interface: AuthorDAO

Inserts the given author into the database. Has the side effect of setting the id field of author to the sequentially generated ID of the new record.

First checks to see if an author with the same firstName and lastName as author exists. If so, no insert is performed; but author.id is updated to the id of the previously existing record.

Specified by:

insert in interface AuthorDAO

Throws:

LibraryException - if a data access error occurs

findAuthorByFirstLastName

public Long findAuthorByFirstLastName(Author author)
                               throws LibraryException

Description copied from interface: AuthorDAO

Finds the id of the given Author object in the database, using the firstName and lastName properties to lookup the record.

Specified by:

findAuthorByFirstLastName in interface AuthorDAO

Parameters:

author - Author to lookup by name

Returns:

Long id of the Author

Throws:

LibraryException

insertNewAuthor

public void insertNewAuthor(Author author)
                     throws LibraryException

Insert a new Author into the DB.

Parameters:

author - author To be inserted in the DB

Throws:

LibraryException

setAuthorIds

public void setAuthorIds(ArrayList authors)
                  throws LibraryException

Description copied from interface: AuthorDAO

Walks input ArrayList, looking up and setting ID properties for each Author in the list. Lookup is based on first name + last name. If an Author 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:

setAuthorIds in interface AuthorDAO

Parameters:

authors - = ArrayList of Authors

Throws:

LibraryException