org.sourceforge.vlibrary.user.dao

Class LibraryTransactionDAO

java.lang.Object

org.sourceforge.vlibrary.user.dao.LibraryTransactionDAO

public class LibraryTransactionDAO
extends Object

Version:

$Revision$ $Date$

Constructor Summary

Constructors

Constructor and Description
LibraryTransactionDAO()

Method Summary

Modifier and Type	Method and Description
void	cancelRequest(long reader, String isbn) Cancels a pending request by a reader for a book
long[]	getCopies(String isbn, long location) Returns a list of ids of copies of the book with the given isbn whose last known location is the given location.
long	getLastLocation(long book) Queries the transaction table to determine the last location where a book was checked in or out.
long	getPossessor(long book) Queries the transaction table to determine the whereabouts of a book.
List<Long>	getRequestors(String isbn, long location) Retrieves a List of requesters for a book (identified by isbn) in a given location.
List	getTransactions(long book) Gets the entire transaction history for a book and returns a List of LibraryTransaction objects or empty if none found
void	processCheckin(long reader, long book, long location) Records a book checkin in the transaction table.
void	processCheckout(long reader, long book, String isbn, long location) Records a book checkout in the transaction table.
void	processRequest(long reader, long book, long location) Records book request transaction.
boolean	requestPending(long reader, long book) Returns whether a reader has a pending request for a particular book (id)
LibraryTransaction	retrieve(long id) Retrieves a LibraryTransaction using its transaction id.
void	setDeleteReaderBookRequestActionTransactionSQL(String deleteReaderBookRequestActionTransactionSQL) Used for Spring Dependency Injection
void	setGetCopiesSQL(String getCopiesSQL)
void	setGetLastLocationSQL(String getLastLocationSQL)
void	setInsertReaderBookActionTransactionSQL(String insertReaderBookActionTransactionSQL) 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	setSelectAllBookTransactionByBookIdSQL(String selectAllBookTransactionByBookIdSQL) Used for Spring Dependency Injection
void	setSelectReaderByBookIdActionIdSQL(String selectReaderByBookIdActionIdSQL) Used for Spring Dependency Injection
void	setSelectReaderISBNActionIdLocationIdSQL(String selectReaderISBNActionIdLocationIdSQL)
void	setSelectTransactionBookIdActionIdLocationIdSQL(String selectTransactionBookIdActionIdLocationIdSQL) Used for Spring Dependency Injection
void	setSelectTransactionBookIdNotActionIdSQL(String selectTransactionBookIdNotActionIdSQL) Used for Spring Dependency Injection
void	setSelectTransactionBytransactionIdReaderIdBookIdSQL(String selectTransactionBytransactionIdReaderIdBookIdSQL) 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

LibraryTransactionDAO

public LibraryTransactionDAO()

Method Detail

setSelectAllBookTransactionByBookIdSQL

public void setSelectAllBookTransactionByBookIdSQL(String selectAllBookTransactionByBookIdSQL)

Used for Spring Dependency Injection

setSelectReaderByBookIdActionIdSQL

public void setSelectReaderByBookIdActionIdSQL(String selectReaderByBookIdActionIdSQL)

Used for Spring Dependency Injection

setSelectTransactionBookIdActionIdLocationIdSQL

public void setSelectTransactionBookIdActionIdLocationIdSQL(String selectTransactionBookIdActionIdLocationIdSQL)

Used for Spring Dependency Injection

setSelectTransactionBookIdNotActionIdSQL

public void setSelectTransactionBookIdNotActionIdSQL(String selectTransactionBookIdNotActionIdSQL)

Used for Spring Dependency Injection

setDeleteReaderBookRequestActionTransactionSQL

public void setDeleteReaderBookRequestActionTransactionSQL(String deleteReaderBookRequestActionTransactionSQL)

Used for Spring Dependency Injection

setSelectTransactionBytransactionIdReaderIdBookIdSQL

public void setSelectTransactionBytransactionIdReaderIdBookIdSQL(String selectTransactionBytransactionIdReaderIdBookIdSQL)

Used for Spring Dependency Injection

setInsertReaderBookActionTransactionSQL

public void setInsertReaderBookActionTransactionSQL(String insertReaderBookActionTransactionSQL)

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.

setGetLastLocationSQL

public void setGetLastLocationSQL(String getLastLocationSQL)

Parameters:

getLastLocationSQL - the getLastLocationSQL to set

setGetCopiesSQL

public void setGetCopiesSQL(String getCopiesSQL)

Parameters:

getCopiesSQL - the getCopiesSQL to set

setResourceBundleMessageSource

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

Used for Spring Dependency Injection

setSelectReaderISBNActionIdLocationIdSQL

public void setSelectReaderISBNActionIdLocationIdSQL(String selectReaderISBNActionIdLocationIdSQL)

Parameters:

selectReaderISBNActionIdLocationIdSQL - the selectReaderISBNActionIdLocationIdSQL to set

retrieve

public LibraryTransaction retrieve(long id)
                            throws LibraryException

Retrieves a LibraryTransaction using its transaction id. Fills in reader, book data by joining with reader, book tables.

Parameters:

id - the ID of the transaction to look up

Throws:

LibraryException - if there is a problem looking up the transaction or the transaction does not exist

processCheckin

public void processCheckin(long reader,
                           long book,
                           long location)
                    throws LibraryException

Records a book checkin in the transaction table. Does not send notifications.

Parameters:

book - the id of the book being checked in

reader - the id of the reader checking in the book

location - the id of the location of the transaction

Throws:

LibraryException - if an error occurs updating the transaction table

processCheckout

public void processCheckout(long reader,
                            long book,
                            String isbn,
                            long location)
                     throws LibraryException

Records a book checkout in the transaction table. Inserts a checkout transaction and removes the pending request. Does not send notifications.

If the book is not checked in, throws LibraryException.

Parameters:

book - the id of the book being checked out

reader - the id of the reader checking out the book

location - the id of the location of the transaction

isbn - of the book

Throws:

LibraryException - if the book is not checked in, or an error occurs recording the transaction

getPossessor

public long getPossessor(long book)
                  throws LibraryException

Queries the transaction table to determine the whereabouts of a book.

Returns the id of the reader who is currently holding the book. If the book is "checked in", returns CHECKED_IN. If there are no transactions associated with the book, returns NO_TRANSACTIONS.

Parameters:

book - the id of the book being sought

Throws:

LibraryException - if the book does not exist or an SQL processing error occurs

processRequest

public void processRequest(long reader,
                           long book,
                           long location)
                    throws LibraryException

Records book request transaction.

Parameters:

book - = the id of the book being requested

reader - = the id of the reader making the request

Throws:

LibraryException - if an error occurs updating the database

getRequestors

public List<Long> getRequestors(String isbn,
                                long location)
                         throws LibraryException

Retrieves a List of requesters for a book (identified by isbn) in a given location. Returns an empty list if there are no pending requests for the book in the given location.

Parameters:

isbn - the isbn of the book being requested

location - the id of the location

Throws:

LibraryException - if an error occurs accessing the database

requestPending

public boolean requestPending(long reader,
                              long book)
                       throws LibraryException

Returns whether a reader has a pending request for a particular book (id)

Parameters:

book - = the id of the book

reader - = the id of the reader

Returns:

true if reader has a pending request for book; false otherwise

Throws:

LibraryException

cancelRequest

public void cancelRequest(long reader,
                          String isbn)
                   throws LibraryException

Cancels a pending request by a reader for a book

Parameters:

isbn - = the isbn of the book being requested

reader - = the id of the reader making the request

Throws:

LibraryException

getTransactions

public List getTransactions(long book)
                     throws LibraryException

Gets the entire transaction history for a book and returns a List of LibraryTransaction objects or empty if none found

Parameters:

book - = id of the book to retrieve transactions for

Throws:

LibraryException

getLastLocation

public long getLastLocation(long book)
                     throws LibraryException

Queries the transaction table to determine the last location where a book was checked in or out. Returns the id of the location or a negative value (Constants.UNKNOWN_LOCATION) if the book has never been checked in or out.

Parameters:

book -

Returns:

location id of last known location of the book

Throws:

LibraryException

getCopies

public long[] getCopies(String isbn,
                        long location)
                 throws LibraryException

Returns a list of ids of copies of the book with the given isbn whose last known location is the given location. Returns an empty array if there are no such books.

Parameters:

isbn - ISBN of the book being sought

Returns:

array of book IDs

Throws:

LibraryException