cgl.juddi.datastore.jdbc
Class LeaseTable

java.lang.Object
  |
  +--cgl.juddi.datastore.jdbc.LeaseTable

public class LeaseTable

extends java.lang.Object

Author:

Mehmet S. Aktas (maktas@indiana.edu)

Field Summary

(package private) static java.lang.String	deleteAttributeLeaseSQL
(package private) static java.lang.String	deleteServiceLeaseSQL
(package private) static java.lang.String	insertAttributeLeaseSQL
(package private) static java.lang.String	insertServiceLeaseSQL
(package private) static java.lang.String	selectAttributeLeaseSQL
(package private) static java.lang.String	selectServiceLeaseSQL

Constructor Summary

LeaseTable()

Method Summary

static void	deleteAttributeLease(java.lang.String attribute_key, java.sql.Connection connection) Delete multiple rows from the LEASE table that are assigned to the uddiKey specified.
static void	deleteServiceLease(java.lang.String service_key, java.sql.Connection connection) Delete multiple rows from the LEASE table that are assigned to the uddiKey specified.
static void	insertAttributeLease(Lease lease, java.sql.Connection connection) Insert new row into the LEASE table.
static void	insertServiceLease(Lease lease, java.sql.Connection connection)
static void	main(java.lang.String[] args)
static java.util.Vector	selectAttributeLease(java.lang.String attribute_key, java.sql.Connection connection) Select all rows from the CONTACT table for a given BusinessKey.
static java.util.Vector	selectServiceLease(java.lang.String service_key, java.sql.Connection connection) Select all rows from the CONTACT 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

insertAttributeLeaseSQL

static java.lang.String insertAttributeLeaseSQL

insertServiceLeaseSQL

static java.lang.String insertServiceLeaseSQL

selectServiceLeaseSQL

static java.lang.String selectServiceLeaseSQL

selectAttributeLeaseSQL

static java.lang.String selectAttributeLeaseSQL

deleteServiceLeaseSQL

static java.lang.String deleteServiceLeaseSQL

deleteAttributeLeaseSQL

static java.lang.String deleteAttributeLeaseSQL

Constructor Detail

LeaseTable

public LeaseTable()

Method Detail

insertAttributeLease

public static void insertAttributeLease(Lease lease,
                                        java.sql.Connection connection)
                                 throws java.sql.SQLException

Insert new row into the LEASE table.

Parameters:

connection - JDBC connection

Throws:

java.sql.SQLException

insertServiceLease

public static void insertServiceLease(Lease lease,
                                      java.sql.Connection connection)
                               throws java.sql.SQLException

java.sql.SQLException

selectServiceLease

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

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

Parameters:

connection - JDBC connection

Throws:

java.sql.SQLException

selectAttributeLease

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

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

Parameters:

connection - JDBC connection

Throws:

java.sql.SQLException

deleteServiceLease

public static void deleteServiceLease(java.lang.String service_key,
                                      java.sql.Connection connection)
                               throws java.sql.SQLException

Delete multiple rows from the LEASE table that are assigned to the uddiKey specified.

Parameters:

connection - JDBC connection

Throws:

java.sql.SQLException

deleteAttributeLease

public static void deleteAttributeLease(java.lang.String attribute_key,
                                        java.sql.Connection connection)
                                 throws java.sql.SQLException

Delete multiple rows from the LEASE table that are assigned to the uddiKey specified.

Parameters:

connection - JDBC connection

Throws:

java.sql.SQLException

main

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

java.lang.Exception

test

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

java.lang.Exception