spo.src.SPDB.Util
Class DBUtil

java.lang.Object
  |
  +--spo.src.SPDB.Util.DBUtil

public class DBUtil

extends java.lang.Object

A utility class for query/update spo database

Constructor Summary

DBUtil(java.sql.Connection conn)
Initialize an instance of the utility class

Method Summary

void	close() Close the db connection
void	commit() Send the commit command to DB
protected void	finalize()
int	flush() Send a flush command to DB
static void	main(java.lang.String[] args) main routine used for testing.
java.util.Hashtable	queryCONS(java.lang.String queryString) Send a query which sets SPO contexts and conditionals
boolean	queryReturnBoolean(java.lang.String queryString) Send a query which returns only a boolean
float	queryReturnFloat(java.lang.String queryString) Send a query which returns only a float
void	queryReturnIDList(java.lang.String queryString, java.util.ArrayList[] IDList) Send a query which returns only a Vector
void	queryReturnIDList(java.lang.String queryString, java.util.Hashtable PathHash, java.util.ArrayList[] IDList)
int	queryReturnInt(java.lang.String queryString) Send a query which returns only an integer
java.lang.String	queryReturnName(java.lang.String queryString) Send a query which returns only a Vector
java.util.Vector	queryReturnNameList(java.lang.String queryString) Send a query which returns only a Vector
java.util.Hashtable	queryReturnVarList(java.lang.String queryString) Send a query which returns only a Hashtable
java.util.Hashtable	queryTable(java.lang.String queryString) Send a query which sets SPO probability tables
void	rollback() Send the rollback command to DB
void	setAutoCommit(boolean yes) Set the commit mode
int	update(java.lang.String updateString) Send a update command to DB
int	updateID(java.lang.String updateString) Send a update command to DB

Methods inherited from class java.lang.Object

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

Constructor Detail

DBUtil

public DBUtil(java.sql.Connection conn)

Initialize an instance of the utility class

Parameters:

conn - the connection through which to access the DB

Method Detail

main

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

main routine used for testing. Usage: java DBUtil

queryReturnInt

public int queryReturnInt(java.lang.String queryString)

Send a query which returns only an integer

Parameters:

queryString - the query string

queryReturnFloat

public float queryReturnFloat(java.lang.String queryString)

Send a query which returns only a float

Parameters:

queryString - the query string

queryReturnBoolean

public boolean queryReturnBoolean(java.lang.String queryString)

Send a query which returns only a boolean

Parameters:

queryString - the query string

queryReturnIDList

public void queryReturnIDList(java.lang.String queryString,
                              java.util.ArrayList[] IDList)

Send a query which returns only a Vector

Parameters:

queryString - the query string

queryReturnIDList

public void queryReturnIDList(java.lang.String queryString,
                              java.util.Hashtable PathHash,
                              java.util.ArrayList[] IDList)

queryReturnNameList

public java.util.Vector queryReturnNameList(java.lang.String queryString)

Send a query which returns only a Vector

Parameters:

queryString - the query string

queryReturnName

public java.lang.String queryReturnName(java.lang.String queryString)

Send a query which returns only a Vector

Parameters:

queryString - the query string

queryReturnVarList

public java.util.Hashtable queryReturnVarList(java.lang.String queryString)

Send a query which returns only a Hashtable

Parameters:

queryString - the query string

queryCONS

public java.util.Hashtable queryCONS(java.lang.String queryString)

Send a query which sets SPO contexts and conditionals

Parameters:

queryString - the query string

queryTable

public java.util.Hashtable queryTable(java.lang.String queryString)

Send a query which sets SPO probability tables

Parameters:

queryString - the query string

updateID

public int updateID(java.lang.String updateString)

Send a update command to DB

Parameters:

updateString - the update string

update

public int update(java.lang.String updateString)

Send a update command to DB

Parameters:

updateString - the update string

flush

public int flush()

Send a flush command to DB

setAutoCommit

public void setAutoCommit(boolean yes)

Set the commit mode

Parameters:

yes - Set the mode of autocommit. true is autocommit.

commit

public void commit()

Send the commit command to DB

rollback

public void rollback()

Send the rollback command to DB

close

public void close()

Close the db connection

finalize

protected void finalize()
                 throws java.lang.Throwable

Overrides:

finalize in class java.lang.Object

java.lang.Throwable