public class Table_Service
extends java.lang.Object
Constructor and Description |
---|
Table_Service()
constructor
|
Modifier and Type | Method and Description |
---|---|
void |
close()
close current result set, discarding all items in result set and local tuple variables
precondition:
successful call to fetchTuple()
|
void |
deleteTuple(CommanderConnection conn,
int id)
delete tuple given by its (unique) id
precondition:
JDBC connection opened
|
void |
fetchAllTuples(CommanderConnection conn)
fetch all tuples from table, store result locally as a JDBC ResultList
precondition:
JDBC connection opened
|
void |
fetchTupleById(CommanderConnection conn,
int id)
fetch one tuple by its (unique) id, keep in local result set
precondition:
JDBC connection opened
|
java.lang.String |
getAbstract() |
java.lang.String |
getAccessConstraints() |
java.lang.String |
getAddress() |
java.lang.String |
getAddressType() |
int |
getAvailability() |
java.lang.String |
getBaseLayerName() |
int |
getCard(CommanderConnection conn)
determine number of services stored in database
|
java.lang.String |
getCity() |
java.lang.String |
getContactElectronicMailAddress() |
java.lang.String |
getContactFacsimileTelephone() |
java.lang.String |
getContactOrganization() |
java.lang.String |
getContactPerson() |
java.lang.String |
getContactVoiceTelephone() |
java.lang.String |
getCountry() |
java.lang.String |
getFees() |
java.lang.String |
getFormats() |
java.lang.String |
getHostName() |
int |
getId()
getter methods for attributes.
|
java.lang.String |
getKeywords() |
java.lang.String |
getName() |
java.lang.String |
getPath() |
int |
getPort() |
java.lang.String |
getPostCode() |
java.lang.String |
getStateOrProvince() |
java.lang.String |
getTitle() |
java.lang.String |
getUpdateSequence() |
java.lang.String |
getVendorCapabilities() |
int |
insertTuple(CommanderConnection conn,
java.lang.String updateSequence,
int availability,
java.lang.String name,
java.lang.String title,
java.lang.String abstractText,
java.lang.String keywords,
java.lang.String fees,
java.lang.String accessConstraints,
java.lang.String hostName,
int port,
java.lang.String path,
java.lang.String formats,
java.lang.String baseLayerName,
java.lang.String vendorCapabilities,
java.lang.String contactPerson,
java.lang.String contactOrganization,
java.lang.String addressType,
java.lang.String address,
java.lang.String city,
java.lang.String stateOrProvince,
java.lang.String postCode,
java.lang.String country,
java.lang.String contactVoiceTelephone,
java.lang.String contactFacsimileTelephone,
java.lang.String contactElectronicMailAddress)
insert one tuple; instance's local attribute set is not modified.
|
boolean |
isTupleValid()
is current tuple valid, ie, has there been a fetch before?
precondition:
successful call to fetchTuple()
|
static void |
main(java.lang.String[] args)
component test for this class
requires:
DatabaseConnection
|
boolean |
next()
cursor over result set of previous fetchAllTuples()
if successful, the tuple variables are set with the current fetch values
|
java.lang.String |
toString()
Method toString
|
void |
updateAvailability(CommanderConnection conn,
int id,
int availability)
update service availability
FIXME: generalize updateTuple to only address non-null parameters, then this method is obsolete
precondition:
JDBC connection opened
tuple with id exists
|
void |
updateTuple(CommanderConnection conn,
int id,
java.lang.String updateSequence,
int availability,
java.lang.String name,
java.lang.String title,
java.lang.String abstractText,
java.lang.String keywords,
java.lang.String fees,
java.lang.String accessConstraints,
java.lang.String hostName,
int port,
java.lang.String path,
java.lang.String formats,
java.lang.String baseLayerName,
java.lang.String vendorCapabilities,
java.lang.String contactPerson,
java.lang.String contactOrganization,
java.lang.String addressType,
java.lang.String address,
java.lang.String city,
java.lang.String stateOrProvince,
java.lang.String postCode,
java.lang.String country,
java.lang.String contactVoiceTelephone,
java.lang.String contactFacsimileTelephone,
java.lang.String contactElectronicMailAddress)
update tuple from all parameters passed.
|
public int insertTuple(CommanderConnection conn, java.lang.String updateSequence, int availability, java.lang.String name, java.lang.String title, java.lang.String abstractText, java.lang.String keywords, java.lang.String fees, java.lang.String accessConstraints, java.lang.String hostName, int port, java.lang.String path, java.lang.String formats, java.lang.String baseLayerName, java.lang.String vendorCapabilities, java.lang.String contactPerson, java.lang.String contactOrganization, java.lang.String addressType, java.lang.String address, java.lang.String city, java.lang.String stateOrProvince, java.lang.String postCode, java.lang.String country, java.lang.String contactVoiceTelephone, java.lang.String contactFacsimileTelephone, java.lang.String contactElectronicMailAddress) throws java.sql.SQLException, ConnectionFailedException, InvalidInputException
conn
- JDBC connectionid
- service tuple idjava.sql.SQLException
ConnectionFailedException
InvalidInputException
public void updateTuple(CommanderConnection conn, int id, java.lang.String updateSequence, int availability, java.lang.String name, java.lang.String title, java.lang.String abstractText, java.lang.String keywords, java.lang.String fees, java.lang.String accessConstraints, java.lang.String hostName, int port, java.lang.String path, java.lang.String formats, java.lang.String baseLayerName, java.lang.String vendorCapabilities, java.lang.String contactPerson, java.lang.String contactOrganization, java.lang.String addressType, java.lang.String address, java.lang.String city, java.lang.String stateOrProvince, java.lang.String postCode, java.lang.String country, java.lang.String contactVoiceTelephone, java.lang.String contactFacsimileTelephone, java.lang.String contactElectronicMailAddress) throws java.sql.SQLException, ConnectionFailedException
conn
- JDBC connectionid
- service tuple idjava.sql.SQLException
ConnectionFailedException
public void updateAvailability(CommanderConnection conn, int id, int availability) throws java.sql.SQLException, ConnectionFailedException
conn
- JDBC connectionid
- service tuple idjava.sql.SQLException
ConnectionFailedException
public void deleteTuple(CommanderConnection conn, int id) throws java.sql.SQLException, ConnectionFailedException
conn
- JDBC connectionid
- service tuple idjava.sql.SQLException
ConnectionFailedException
public void fetchTupleById(CommanderConnection conn, int id) throws java.sql.SQLException
conn
- JDBC connectionid
- service tuple idjava.sql.SQLException
public void fetchAllTuples(CommanderConnection conn) throws java.sql.SQLException
conn
- JDBC connectionjava.sql.SQLException
public boolean next() throws java.sql.SQLException
java.sql.SQLException
public void close() throws java.sql.SQLException
java.sql.SQLException
public int getCard(CommanderConnection conn) throws java.sql.SQLException
java.sql.SQLException
public boolean isTupleValid()
public int getId()
public java.lang.String getUpdateSequence()
public int getAvailability()
public java.lang.String getName()
public java.lang.String getTitle()
public java.lang.String getAbstract()
public java.lang.String getKeywords()
public java.lang.String getFees()
public java.lang.String getAccessConstraints()
public java.lang.String getHostName()
public int getPort()
public java.lang.String getPath()
public java.lang.String getFormats()
public java.lang.String getBaseLayerName()
public java.lang.String getVendorCapabilities()
public java.lang.String getContactPerson()
public java.lang.String getContactOrganization()
public java.lang.String getAddressType()
public java.lang.String getAddress()
public java.lang.String getCity()
public java.lang.String getStateOrProvince()
public java.lang.String getPostCode()
public java.lang.String getCountry()
public java.lang.String getContactVoiceTelephone()
public java.lang.String getContactFacsimileTelephone()
public java.lang.String getContactElectronicMailAddress()
public java.lang.String toString()
toString
in class java.lang.Object
public static void main(java.lang.String[] args)