cgl.fthpis.datastore.jdbc
Class PublisherTable

java.lang.Object
  cgl.fthpis.datastore.jdbc.PublisherTable

public class PublisherTable

extends java.lang.Object

Author:

Mehmet S. Aktas (maktas@indiana.edu)

Field Summary

(package private) static java.lang.String	deleteSQL
(package private) static java.lang.String	insertSQL
(package private) static java.lang.String	selectSQL
(package private) static java.lang.String	updateSQL
(package private) static java.lang.String	verifyAdminSQL

Constructor Summary

PublisherTable()

Method Summary

static void	delete(java.lang.String publisherID, java.sql.Connection connection) Delete row from the PUBLISHER table.
static void	insert(Publisher publisher, java.sql.Connection connection) Insert new row into the PUBLISHER table.
static void	main(java.lang.String[] args)
static Publisher	select(java.lang.String publisherID, java.sql.Connection connection) Select one row from the PUBLISHER table.
static void	test(java.sql.Connection connection)
static void	update(Publisher publisher, java.sql.Connection connection) Update the PUBLISHER table for a particular PublisherID.

Methods inherited from class java.lang.Object

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

Field Detail

insertSQL

static java.lang.String insertSQL

selectSQL

static java.lang.String selectSQL

deleteSQL

static java.lang.String deleteSQL

updateSQL

static java.lang.String updateSQL

verifyAdminSQL

static java.lang.String verifyAdminSQL

Constructor Detail

PublisherTable

public PublisherTable()

Method Detail

insert

public static void insert(Publisher publisher,
                          java.sql.Connection connection)
                   throws java.sql.SQLException

Insert new row into the PUBLISHER table.

Parameters:

publisher -

connection - JDBC connection

Throws:

java.sql.SQLException

select

public static Publisher select(java.lang.String publisherID,
                               java.sql.Connection connection)
                        throws java.sql.SQLException

Select one row from the PUBLISHER table.

Parameters:

publisherID -

connection - JDBC connection

Returns:

Publisher

Throws:

java.sql.SQLException

delete

public static void delete(java.lang.String publisherID,
                          java.sql.Connection connection)
                   throws java.sql.SQLException

Delete row from the PUBLISHER table.

Parameters:

publisherID -

connection -

Throws:

java.sql.SQLException

update

public static void update(Publisher publisher,
                          java.sql.Connection connection)
                   throws java.sql.SQLException

Update the PUBLISHER table for a particular PublisherID.

Parameters:

publisher -

connection - JDBC connection

Throws:

java.sql.SQLException

main

public static void main(java.lang.String[] args)
                 throws java.lang.Exception

Throws:

java.lang.Exception

test

public static void test(java.sql.Connection connection)
                 throws java.lang.Exception

Throws:

java.lang.Exception