org.sourceforge.vlibrary.user.dao

Class ReaderDAOSpringJDBCImpl

java.lang.Object

org.sourceforge.vlibrary.user.dao.ReaderDAOSpringJDBCImpl

All Implemented Interfaces:

ReaderDAO

public class ReaderDAOSpringJDBCImpl
extends Object
implements ReaderDAO

Version:

$Revision$ $Date$

Constructor Summary

Constructors

Constructor and Description
ReaderDAOSpringJDBCImpl()

Method Summary

Modifier and Type	Method and Description
boolean	deskPhoneExists(String deskphone) Checks to see if a Reader with a specified deskphone exists in the database
long	getReaderID(String firstName, String lastName) Looks up the ID of a reader from first and last name.
ArrayList	getReaders() Retrive all Readers from the database
void	insert(Reader reader) Inserts Reader into the database.
boolean	readerExists(long id) Checks to see if a Reader id exists in the database
boolean	readerExists(String deskphone) Checks to see if a Reader with a specified deskphone exists in the database
boolean	readerExists(String firstName, String lastName) Checks to see if a reader with the given first and last name is registered in the database.
void	resetPassword(String user, String newPwd) Resets user's password
Reader	retrieve(Reader rd) Retrieve Reader from the database
Reader	retrieveByFirstLastName(String firstName, String lastName) Retrieve Reader by first and last name from the database
Reader	retrieveByGenericCriteria(String sqlString, Object[] criteria) Retrieve Reader using a parameterized query.
Reader	retrieveById(long id) Retrieve Reader by id from the database
Reader	retrieveByPhone(String deskphone) Retrieve Reader by deskphone from the database
Reader	retrieveByUid(String uid) Retrieve Reader by uid from the database
void	setCrypto(Crypto crypto) Used for Spring Dependency Injection
void	setDeleteReaderAdminRoleSQL(String deleteReaderAdminRoleSQL) Used for Spring Dependency Injection
void	setInsertReaderAdminRoleSQL(String insertReaderAdminRoleSQL) Used for Spring Dependency Injection
void	setInsertReaderSQL(String insertReaderSQL) Used for Spring Dependency Injection
void	setInsertUserRoleSQL(String insertUserRoleSQL) 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	setSelectAllReadersSQL(String selectAllReadersSQL) Used for Spring Dependency Injection
void	setSelectReaderAdminRoleSQL(String selectReaderAdminRoleSQL) Used for Spring Dependency Injection
void	setSelectReaderByDeskPhoneSQL(String selectReaderByDeskPhoneSQL) Used for Spring Dependency Injection
void	setSelectReaderByFirstLastNameSQL(String selectReaderByFirstLastNameSQL) Used for Spring Dependency Injection
void	setSelectReaderByIdSQL(String selectReaderByIdSQL) Used for Spring Dependency Injection
void	setSelectReaderIdByUidSQL(String selectReaderIdByUidSQL) Used for Spring Dependency Injection
void	setUpdateReaderPasswordSQL(String updateReaderPasswordSQL) Used for Spring Dependency Injection
void	setUpdateReaderSQL(String updateReaderSQL) Used for Spring Dependency Injection
boolean	uidExists(String uid) Checks to see if a Reader uid exists in the database
void	update(Reader reader) Update Reader in the database, using the UID of the Reader to locate the database record.

Methods inherited from class java.lang.Object

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

Constructor Detail

ReaderDAOSpringJDBCImpl

public ReaderDAOSpringJDBCImpl()

Method Detail

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

setUpdateReaderPasswordSQL

public void setUpdateReaderPasswordSQL(String updateReaderPasswordSQL)

Used for Spring Dependency Injection

setSelectReaderByFirstLastNameSQL

public void setSelectReaderByFirstLastNameSQL(String selectReaderByFirstLastNameSQL)

Used for Spring Dependency Injection

setSelectAllReadersSQL

public void setSelectAllReadersSQL(String selectAllReadersSQL)

Used for Spring Dependency Injection

setInsertReaderSQL

public void setInsertReaderSQL(String insertReaderSQL)

Used for Spring Dependency Injection

setInsertUserRoleSQL

public void setInsertUserRoleSQL(String insertUserRoleSQL)

Used for Spring Dependency Injection

setSelectReaderIdByUidSQL

public void setSelectReaderIdByUidSQL(String selectReaderIdByUidSQL)

Used for Spring Dependency Injection

setSelectReaderByIdSQL

public void setSelectReaderByIdSQL(String selectReaderByIdSQL)

Used for Spring Dependency Injection

setSelectReaderByDeskPhoneSQL

public void setSelectReaderByDeskPhoneSQL(String selectReaderByDeskPhoneSQL)

Used for Spring Dependency Injection

setUpdateReaderSQL

public void setUpdateReaderSQL(String updateReaderSQL)

Used for Spring Dependency Injection

setDeleteReaderAdminRoleSQL

public void setDeleteReaderAdminRoleSQL(String deleteReaderAdminRoleSQL)

Used for Spring Dependency Injection

setInsertReaderAdminRoleSQL

public void setInsertReaderAdminRoleSQL(String insertReaderAdminRoleSQL)

Used for Spring Dependency Injection

setSelectReaderAdminRoleSQL

public void setSelectReaderAdminRoleSQL(String selectReaderAdminRoleSQL)

Used for Spring Dependency Injection

setCrypto

public void setCrypto(Crypto crypto)

Used for Spring Dependency Injection

insert

public void insert(Reader reader)
            throws LibraryException

Inserts Reader into the database. Has the side effect of setting Reader object's id to the sequentially generated id of the new record. Also adds "reader" role for this reader to the user_x_role table.

Specified by:

insert in interface ReaderDAO

Throws:

LibraryException

update

public void update(Reader reader)
            throws LibraryException

Update Reader in the database, using the UID of the Reader to locate the database record.

Specified by:

update in interface ReaderDAO

Throws:

LibraryException - if reader is null or contains insufficient data

retrieve

public Reader retrieve(Reader rd)
                throws LibraryException

Retrieve Reader from the database

Specified by:

retrieve in interface ReaderDAO

Returns:

Reader - Fully populated Reader object, or NULL if a record matching criteria could not be located in the DB

Throws:

LibraryException

retrieveById

public Reader retrieveById(long id)
                    throws LibraryException

Retrieve Reader by id from the database

Specified by:

retrieveById in interface ReaderDAO

Returns:

Reader - Fully populated Reader object, or NULL if a record matching criteria could not be located in the DB

Throws:

LibraryException

retrieveByUid

public Reader retrieveByUid(String uid)
                     throws LibraryException

Retrieve Reader by uid from the database

Specified by:

retrieveByUid in interface ReaderDAO

Returns:

Reader - Fully populated Reader object, or NULL if a record matching criteria could not be located in the DB

Throws:

LibraryException

retrieveByPhone

public Reader retrieveByPhone(String deskphone)
                       throws LibraryException

Retrieve Reader by deskphone from the database

Specified by:

retrieveByPhone in interface ReaderDAO

Returns:

Reader - Fully populated Reader object, or NULL if a record matching criteria could not be located in the DB

Throws:

LibraryException

retrieveByFirstLastName

public Reader retrieveByFirstLastName(String firstName,
                                      String lastName)
                               throws LibraryException

Retrieve Reader by first and last name from the database

Returns:

Reader - Fully populated Reader object, or NULL if a record matching criteria could not be located in the DB

Throws:

LibraryException

retrieveByGenericCriteria

public Reader retrieveByGenericCriteria(String sqlString,
                                        Object[] criteria)
                                 throws LibraryException

Retrieve Reader using a parameterized query.

Parameters:

sqlString - - Parameterized SQL query

criteria - - Query parameters

Returns:

Reader - Fully populated Reader object, or NULL if a record matching criteria could not be located in the DB

Throws:

LibraryException - if an error occurs retrieving the reader

uidExists

public boolean uidExists(String uid)
                  throws LibraryException

Checks to see if a Reader uid exists in the database

Specified by:

uidExists in interface ReaderDAO

Parameters:

uid - = uid to look for

Throws:

LibraryException

readerExists

public boolean readerExists(long id)
                     throws LibraryException

Checks to see if a Reader id exists in the database

Specified by:

readerExists in interface ReaderDAO

Parameters:

id - = id to look for

Throws:

LibraryException

readerExists

public boolean readerExists(String deskphone)
                     throws LibraryException

Checks to see if a Reader with a specified deskphone exists in the database

Parameters:

deskphone - = deskphone to look for

Throws:

LibraryException

deskPhoneExists

public boolean deskPhoneExists(String deskphone)
                        throws LibraryException

Checks to see if a Reader with a specified deskphone exists in the database

Specified by:

deskPhoneExists in interface ReaderDAO

Parameters:

deskphone - = deskphone to look for

Throws:

LibraryException

readerExists

public boolean readerExists(String firstName,
                            String lastName)
                     throws LibraryException

Checks to see if a reader with the given first and last name is registered in the database.

Specified by:

readerExists in interface ReaderDAO

Parameters:

firstName - = reader's first name

lastName - = reader's last name

Throws:

LibraryException

getReaders

public ArrayList getReaders()
                     throws LibraryException

Retrive all Readers from the database

Specified by:

getReaders in interface ReaderDAO

Returns:

ArrayList of Readers - Fully populated Reader objects, or empty if no readers could be located in the DB

Throws:

LibraryException

getReaderID

public long getReaderID(String firstName,
                        String lastName)
                 throws LibraryException

Looks up the ID of a reader from first and last name. Does not check for uniqueness -- returns the first one

Specified by:

getReaderID in interface ReaderDAO

Parameters:

firstName - = first name of the reader

lastName - = last name of the reader

Throws:

LibraryException - if there is no such reader

resetPassword

public void resetPassword(String user,
                          String newPwd)
                   throws LibraryException

Resets user's password

Specified by:

resetPassword in interface ReaderDAO

Parameters:

user - = uid

newPwd - = new password

Throws:

LibraryException - - mostly for DB access, HOWEVER it will not throw any error if the user does not exist in the DB!