cgl.fthpis.datastore.jdbc
Class ServiceDescTable

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

public class ServiceDescTable

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

Constructor Summary

ServiceDescTable()

Method Summary

static void	delete(java.lang.String serviceKey, java.sql.Connection connection) Delete multiple rows from the SERVICE_DESCR table that are assigned to the BusinessKey specified.
static void	insert(java.lang.String serviceKey, java.util.Vector descList, java.sql.Connection connection) Insert new row into the SERVICE_DESCR table.
static void	main(java.lang.String[] args)
static java.util.Vector	select(java.lang.String serviceKey, java.sql.Connection connection) Select all rows from the SERVICE_DESCR 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

selectSQL

static java.lang.String selectSQL

deleteSQL

static java.lang.String deleteSQL

Constructor Detail

ServiceDescTable

public ServiceDescTable()

Method Detail

insert

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

Insert new row into the SERVICE_DESCR table.

Parameters:

serviceKey - String to the BusinessEntity object that owns the Description to be inserted

descList - Vector of Description objects holding values to be inserted

connection - JDBC connection

Throws:

java.sql.SQLException

select

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

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

Parameters:

serviceKey - String

connection - JDBC connection

Throws:

java.sql.SQLException

delete

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

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

Parameters:

serviceKey - String

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