org.apache.oodt.commons.util

Class JDBC_DB

java.lang.Object

org.apache.oodt.commons.util.JDBC_DB

public class JDBC_DB
extends Object

This class is a wrapper for JDBC.

Version:

$Revision: 1.3 $

Author:

D. Crichton

Constructor Summary

Constructors

Constructor and Description
JDBC_DB(Properties sys_props) JDBC_DB Constructor method will create class instance and load the Oracle DB driver
JDBC_DB(Properties sys_props, Connection srv_connect)

Method Summary

Modifier and Type	Method and Description
void	closeConnection() closeConnection Close a connection to the database.
void	commit() commit
ResultSet	executeQuery(String cmd) executeQuery Send an SQL query to the DBMS to be executed.
void	executeSQLCommand(String cmd) executeSQLCommand Send an SQL command to the DBMS to be executed.
protected void	finalize()
Connection	getConnection()
int	getCount(String cmd) getCount Will return a count when user passes sting select count(*) from ...
void	openConnection() openConnection Open a connection to the database.
void	openConnection(String username, String password, String database)
void	rollback() rollback
void	setAutoCommitMode(boolean autoCommitMode)
String	toDateStr(Date inDate) Convert Date to string in format for Oracle TO_DATE processing - DD-MM-YY HH24:MI:SS

Methods inherited from class java.lang.Object

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

Constructor Detail

JDBC_DB

public JDBC_DB(Properties sys_props)

JDBC_DB Constructor method will create class instance and load the Oracle DB driver

JDBC_DB

public JDBC_DB(Properties sys_props,
               Connection srv_connect)

Method Detail

setAutoCommitMode

public void setAutoCommitMode(boolean autoCommitMode)

openConnection

public void openConnection()
                    throws SQLException

openConnection Open a connection to the database.

Throws:

SQLException

openConnection

public void openConnection(String username,
                           String password,
                           String database)
                    throws SQLException

Throws:

SQLException

closeConnection

public void closeConnection()

closeConnection Close a connection to the database.

executeSQLCommand

public void executeSQLCommand(String cmd)
                       throws SQLException

executeSQLCommand Send an SQL command to the DBMS to be executed.

Throws:

SQLException

executeQuery

public ResultSet executeQuery(String cmd)
                       throws SQLException

executeQuery Send an SQL query to the DBMS to be executed.

Throws:

SQLException

getCount

public int getCount(String cmd)
             throws SQLException

getCount Will return a count when user passes sting select count(*) from ...

Throws:

SQLException

commit

public void commit()
            throws SQLException

commit

Throws:

SQLException

rollback

public void rollback()

rollback

finalize

protected void finalize()
                 throws Throwable

Overrides:

finalize in class Object

Throws:

Throwable

toDateStr

public String toDateStr(Date inDate)

Convert Date to string in format for Oracle TO_DATE processing - DD-MM-YY HH24:MI:SS

getConnection

public Connection getConnection()
                         throws SQLException

Throws:

SQLException