cgl.fthpis.datastore.jdbc
Class AttributeTable

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

public class AttributeTable

extends java.lang.Object

Author:

Mehmet S. Aktas (maktas@indiana.edu)

Field Summary

(package private) static java.lang.String	deleteByAttributeKeySQL
(package private) static java.lang.String	insertSQL1
(package private) static java.lang.String	insertSQL2
(package private) static java.lang.String	insertSQL3
(package private) static java.lang.String	selectSQL
(package private) static java.lang.String	verifyOwnershipSQL

Constructor Summary

AttributeTable()

Method Summary

static void	deleteByAttributeKey(java.lang.String attributeKey, java.sql.Connection connection) Delete multiple rows from the BINDING_TEMPLATE table that are assigned to the BusinessKey specified.
static void	insert(Attribute attribute, java.sql.Connection connection) Insert new row into the BINDING_TEMPLATE table.
static void	main(java.lang.String[] args)
static Attribute	select(java.lang.String attributeKey, java.sql.Connection connection) Select one row from the BUSINESS_SERVICE table.
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

insertSQL1

static java.lang.String insertSQL1

insertSQL2

static java.lang.String insertSQL2

insertSQL3

static java.lang.String insertSQL3

selectSQL

static java.lang.String selectSQL

deleteByAttributeKeySQL

static java.lang.String deleteByAttributeKeySQL

verifyOwnershipSQL

static java.lang.String verifyOwnershipSQL

Constructor Detail

AttributeTable

public AttributeTable()

Method Detail

insert

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

Insert new row into the BINDING_TEMPLATE table.

Parameters:

connection - JDBC connection

Throws:

java.sql.SQLException

deleteByAttributeKey

public static void deleteByAttributeKey(java.lang.String attributeKey,
                                        java.sql.Connection connection)
                                 throws java.sql.SQLException

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

Parameters:

connection - JDBC connection

Throws:

java.sql.SQLException

select

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

Select one row from the BUSINESS_SERVICE table.

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