cgl.fthpis.datastore.jdbc
Class ContextPublisherTable

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

public class ContextPublisherTable

extends java.lang.Object

Author:

Mehmet S. Aktas (maktas@indiana.edu)

Field Summary

(package private) static java.lang.String	deleteByContextKeyAndPublisherIDSQL
(package private) static java.lang.String	deleteByContextKeySQL
(package private) static java.lang.String	deleteSQL
(package private) static java.lang.String	insertSQL
(package private) static java.lang.String	selectByContextKeySQL
(package private) static java.lang.String	selectBySessionKeySQL
(package private) static java.lang.String	selectPublishersBySessionKeySQL
(package private) static java.lang.String	selectSQL
(package private) static java.lang.String	verifyOwnershipSQL

Constructor Summary

ContextPublisherTable()

Method Summary

static void	delete(java.lang.String publisherID, java.sql.Connection connection) Delete row from the SESSION_PUBLISHER table.
static void	deleteByContextKey(java.lang.String contextKey, java.sql.Connection connection) Delete multiple rows from the BUSINESS_SERVICE table that are assigned to the BusinessKey specified.
static void	insert(java.lang.String contextKey, java.util.Vector publisherIDVector, java.sql.Connection connection) Insert new row into the SESSION_ENTITIES table.
static void	main(java.lang.String[] args)
static java.util.Vector	select(java.lang.String publisherID, java.sql.Connection connection) Select one row from the BUSINESS_SERVICE table.
static java.util.Vector	selectByContextKey(java.lang.String contextKey, java.sql.Connection connection) Select all rows from the business_service table for a given BusinessKey.
static void	test(java.sql.Connection connection)
static boolean	verifyOwnership(java.lang.String contextKey, java.lang.String publisherID, java.sql.Connection connection) Verify that 'authorizedName' has the authority to update or delete BusinessService identified by the serviceKey parameter

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

deleteSQL

static java.lang.String deleteSQL

selectSQL

static java.lang.String selectSQL

selectByContextKeySQL

static java.lang.String selectByContextKeySQL

selectBySessionKeySQL

static java.lang.String selectBySessionKeySQL

deleteByContextKeySQL

static java.lang.String deleteByContextKeySQL

deleteByContextKeyAndPublisherIDSQL

static java.lang.String deleteByContextKeyAndPublisherIDSQL

selectPublishersBySessionKeySQL

static java.lang.String selectPublishersBySessionKeySQL

verifyOwnershipSQL

static java.lang.String verifyOwnershipSQL

Constructor Detail

ContextPublisherTable

public ContextPublisherTable()

Method Detail

insert

public static void insert(java.lang.String contextKey,
                          java.util.Vector publisherIDVector,
                          java.sql.Connection connection)
                   throws java.sql.SQLException

Insert new row into the SESSION_ENTITIES table.

Parameters:

connection - JDBC connection

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 SESSION_PUBLISHER table.

Parameters:

connection - JDBC connection

Throws:

java.sql.SQLException

select

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

Select one row from the BUSINESS_SERVICE table.

Parameters:

connection - JDBC connection

Throws:

java.sql.SQLException

deleteByContextKey

public static void deleteByContextKey(java.lang.String contextKey,
                                      java.sql.Connection connection)
                               throws java.sql.SQLException

Delete multiple rows from the BUSINESS_SERVICE table that are assigned to the BusinessKey specified.

Parameters:

connection - JDBC connection

Throws:

java.sql.SQLException

selectByContextKey

public static java.util.Vector selectByContextKey(java.lang.String contextKey,
                                                  java.sql.Connection connection)
                                           throws java.sql.SQLException

Select all rows from the business_service table for a given BusinessKey.

Parameters:

connection - JDBC connection

Throws:

java.sql.SQLException

verifyOwnership

public static boolean verifyOwnership(java.lang.String contextKey,
                                      java.lang.String publisherID,
                                      java.sql.Connection connection)
                               throws java.sql.SQLException

Verify that 'authorizedName' has the authority to update or delete BusinessService identified by the serviceKey parameter

Parameters:

publisherID -

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