cgl.fthpis.datastore.jdbc
Class ServiceContextTable

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

public class ServiceContextTable

extends java.lang.Object

Author:

Mehmet S. Aktas (maktas@indiana.edu)

Field Summary

(package private) static java.lang.String	deleteByServiceKeySQL
(package private) static java.lang.String	deleteSQL
(package private) static java.lang.String	insertSQL
(package private) static java.lang.String	selectByServiceKeySQL
(package private) static java.lang.String	selectSQL
(package private) static java.lang.String	verifyOwnershipSQL

Constructor Summary

ServiceContextTable()

Method Summary

static void	delete(java.lang.String contextKey, java.sql.Connection connection) Delete row from the BUSINESS_CONTEXT table.
static void	deleteByServiceKey(java.lang.String serviceKey, java.sql.Connection connection) Delete multiple rows from the BUSINESS_SERVICE table that are assigned to the BusinessKey specified.
static void	insert(Attribute context, java.sql.Connection connection) Insert new row into the SERVICE_ENTITIES table.
static void	main(java.lang.String[] args)
static Attribute	select(java.lang.String contextKey, java.sql.Connection connection) Select one row from the BUSINESS_SERVICE table.
static java.util.Vector	selectByServiceKey(java.lang.String serviceKey, java.sql.Connection connection) Select all rows from the business_service table for a given BusinessKey.
static void	test(java.sql.Connection connection)

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

selectByServiceKeySQL

static java.lang.String selectByServiceKeySQL

deleteByServiceKeySQL

static java.lang.String deleteByServiceKeySQL

verifyOwnershipSQL

static java.lang.String verifyOwnershipSQL

Constructor Detail

ServiceContextTable

public ServiceContextTable()

Method Detail

insert

public static void insert(Attribute context,
                          java.sql.Connection connection)
                   throws java.sql.SQLException

Insert new row into the SERVICE_ENTITIES table.

Parameters:

connection - JDBC connection

Throws:

java.sql.SQLException

delete

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

Delete row from the BUSINESS_CONTEXT table.

Parameters:

connection - JDBC connection

Throws:

java.sql.SQLException

select

public static Attribute select(java.lang.String contextKey,
                               java.sql.Connection connection)
                        throws java.sql.SQLException

Select one row from the BUSINESS_SERVICE table.

Parameters:

connection - JDBC connection

Throws:

java.sql.SQLException

deleteByServiceKey

public static void deleteByServiceKey(java.lang.String serviceKey,
                                      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

selectByServiceKey

public static java.util.Vector selectByServiceKey(java.lang.String serviceKey,
                                                  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

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