org.ecoinformatics.seek.dataquery

Class DBTableExistenceChecker

java.lang.Object

org.ecoinformatics.seek.dataquery.DBTableExistenceChecker

public class DBTableExistenceChecker
extends java.lang.Object

This class will check if a given table name already existed in db. This class has tigh relationship to hsql. If we use different sql engine This class need to re-implemented.

Author:

Jing Tao

Constructor Summary

Constructors

Constructor and Description
DBTableExistenceChecker()

Method Summary

Modifier and Type	Method and Description
void	deleteRecord(java.lang.String tableName, java.lang.String url)
java.lang.String	getTableName(java.lang.String url) This method will return a tableName for a given URL in the storing table
boolean	isTableNameExisted(java.lang.String tableName) Check if a given table name existed
boolean	isURLExisted(java.lang.String url) Check if a given url existed.
void	storeTableRecord(java.lang.String tableName, java.lang.String url) Method will store a gnerated table info (table name and url) into a persistant table

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DBTableExistenceChecker

public DBTableExistenceChecker()

Method Detail

isURLExisted

public boolean isURLExisted(java.lang.String url)
                     throws java.sql.SQLException,
                            java.lang.ClassNotFoundException

Check if a given url existed. Url is a key for table

Parameters:

url - String

Returns:

boolean

Throws:

java.sql.SQLException

java.lang.ClassNotFoundException

isTableNameExisted

public boolean isTableNameExisted(java.lang.String tableName)
                           throws java.sql.SQLException,
                                  java.lang.ClassNotFoundException

Check if a given table name existed

Parameters:

tableName - String

Returns:

boolean

Throws:

java.sql.SQLException

java.lang.ClassNotFoundException

storeTableRecord

public void storeTableRecord(java.lang.String tableName,
                             java.lang.String url)
                      throws java.sql.SQLException,
                             java.lang.ClassNotFoundException

Method will store a gnerated table info (table name and url) into a persistant table

Parameters:

tableName - String

url - String

Throws:

java.sql.SQLException

java.lang.ClassNotFoundException

deleteRecord

public void deleteRecord(java.lang.String tableName,
                         java.lang.String url)
                  throws java.sql.SQLException,
                         java.lang.ClassNotFoundException

Throws:

java.sql.SQLException

java.lang.ClassNotFoundException

getTableName

public java.lang.String getTableName(java.lang.String url)
                              throws java.sql.SQLException,
                                     java.lang.ClassNotFoundException

This method will return a tableName for a given URL in the storing table

Parameters:

url - String

Returns:

String

Throws:

java.sql.SQLException

java.lang.ClassNotFoundException