unidue.ub.statistics.alephConnector

Class JournalPriceGetter

java.lang.Object

unidue.ub.statistics.alephConnector.JournalPriceGetter

public class JournalPriceGetter
extends java.lang.Object

Retrieves the prices for journals or journal collections from the Aleph database.

Version:

1

Author:

Jutta Kleinfeld, Eike Spielberg

Constructor Summary

Constructors

Constructor and Description
JournalPriceGetter(AlephConnection connection) uses a given connection to Aleph database to prepare the statements

Method Summary

Modifier and Type	Method and Description
java.util.Hashtable<java.lang.Integer,java.lang.Double>	getCollectionPrice(JournalCollection collection) when queried with a single journal collection, the prices from the Aleph database are retrieved and a list of journal collections for each year is returned.
java.util.Hashtable<java.lang.Integer,java.lang.Double>	getJournalPrice(java.lang.String issn) when queried with a single journal title, the prices from the Aleph database are retrieved and a list of journal titles for each year is returned.

Methods inherited from class java.lang.Object

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

Constructor Detail

JournalPriceGetter

public JournalPriceGetter(AlephConnection connection)
                   throws java.sql.SQLException

uses a given connection to Aleph database to prepare the statements

Parameters:

connection - an AlephConnection-object

Throws:

java.sql.SQLException - exception querying the Aleph database

Method Detail

getCollectionPrice

public java.util.Hashtable<java.lang.Integer,java.lang.Double> getCollectionPrice(JournalCollection collection)
                                                                           throws java.sql.SQLException

when queried with a single journal collection, the prices from the Aleph database are retrieved and a list of journal collections for each year is returned. The price is set within each journal collection.

Parameters:

collection - an journal collection

Returns:

a list of journal collections, each containing the price for a specific year

Throws:

java.sql.SQLException - exception querying the Aleph database

getJournalPrice

public java.util.Hashtable<java.lang.Integer,java.lang.Double> getJournalPrice(java.lang.String issn)
                                                                        throws java.sql.SQLException

when queried with a single journal title, the prices from the Aleph database are retrieved and a list of journal titles for each year is returned. The price is set within each journal title.

Parameters:

issn - the ISSN of an journal title

Returns:

a list of journal title, each containing the price for a specific year

Throws:

java.sql.SQLException - exception querying the Aleph database