dbStorage
Class DataAccess

java.lang.Object
  dbStorage.DataAccess

public class DataAccess
extends java.lang.Object

Field Summary

private static DataAccess	daInstance
private static java.lang.String	dbPassword
private static java.lang.String	dbUName
static java.lang.String	hostName
static org.apache.log4j.Category	log
private java.sql.Connection	oConnection
private java.sql.Driver	oDriver

Constructor Summary

private

DataAccess()

Method Summary

java.lang.String	formatDate(java.util.Date d)
java.sql.ResultSet	genericQuery(java.lang.String[] columns, java.lang.String table, java.lang.String where)
java.sql.ResultSet	genericQuery(java.lang.String[] columns, java.lang.String table, java.lang.String where, boolean distinct)
java.sql.ResultSet	genericQuery(java.lang.String[] columns, java.lang.String table, java.lang.String where, boolean distinct, java.lang.String[] orderby)
java.sql.ResultSet	genericQuery(java.lang.String[] columns, java.lang.String table, java.lang.String where, java.lang.String[] orderby)
java.sql.Connection	getConnection()
java.sql.ResultSet	getDataResultSet(java.lang.String StoredProcedure, java.lang.String[] parameters) Generic Function for call stored procedure and returning a ResultSet from it
java.sql.ResultSet	getDataResultSet(java.lang.String StoredProcedure, java.lang.String[] parameters, boolean scrollable) Generic Function for call stored procedure and returning a ResultSet from it
java.util.Date	getDate(java.lang.String d)
java.util.Date	getDate2(java.lang.String d)
java.util.Date	getDate3(java.lang.String d) getDate3 This method converts a string into a java date--it is assumed that the format of the incoming string is yyyy-MM-dd HH:mm:ss
static DataAccess	getInstance()
java.lang.String	getPassword()
java.lang.String	getUserName()
java.util.HashMap	ResultSetToHashMap(java.sql.ResultSet oResultSet) Converts 2 column recordset to a HashMap
int	runStoredProcedure(java.lang.String StoredProcedure, java.lang.String[] parameters) Generic Function for call stored procedure and returning an integer from it
void	runStoredProcedureNoReturn(java.lang.String StoredProcedure, java.lang.String[] parameters) Generic Function for call stored procedure with no return
void	runStoredProcedureNoReturnWithBLOB(java.lang.String StoredProcedure, java.lang.String[] parameters, byte[] BLOB) Generic Function for call stored procedure with no return + BINARY INPUT

Methods inherited from class java.lang.Object

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

Field Detail

daInstance

private static DataAccess daInstance

dbUName

private static java.lang.String dbUName

dbPassword

private static java.lang.String dbPassword

oDriver

private java.sql.Driver oDriver

oConnection

private java.sql.Connection oConnection

hostName

public static java.lang.String hostName

log

public static org.apache.log4j.Category log

Constructor Detail

DataAccess

private DataAccess()
            throws dbDirectException

Throws:

dbDirectException

Method Detail

getInstance

public static DataAccess getInstance()

formatDate

public java.lang.String formatDate(java.util.Date d)

genericQuery

public java.sql.ResultSet genericQuery(java.lang.String[] columns,
                                       java.lang.String table,
                                       java.lang.String where)

genericQuery

public java.sql.ResultSet genericQuery(java.lang.String[] columns,
                                       java.lang.String table,
                                       java.lang.String where,
                                       boolean distinct)

genericQuery

public java.sql.ResultSet genericQuery(java.lang.String[] columns,
                                       java.lang.String table,
                                       java.lang.String where,
                                       boolean distinct,
                                       java.lang.String[] orderby)

genericQuery

public java.sql.ResultSet genericQuery(java.lang.String[] columns,
                                       java.lang.String table,
                                       java.lang.String where,
                                       java.lang.String[] orderby)

getConnection

public java.sql.Connection getConnection()

getDataResultSet

public java.sql.ResultSet getDataResultSet(java.lang.String StoredProcedure,
                                           java.lang.String[] parameters)
                                    throws dbDirectException

Generic Function for call stored procedure and returning a ResultSet from it

Parameters:

StoredProcedure - String

parameters - String[]

Returns:

ResultSet

Throws:

java.sql.SQLException

dbDirectException

getDataResultSet

public java.sql.ResultSet getDataResultSet(java.lang.String StoredProcedure,
                                           java.lang.String[] parameters,
                                           boolean scrollable)
                                    throws dbDirectException

Generic Function for call stored procedure and returning a ResultSet from it

Parameters:

StoredProcedure - String

parameters - String[]

Returns:

ResultSet

Throws:

java.sql.SQLException

dbDirectException

getDate

public java.util.Date getDate(java.lang.String d)
                       throws dbDirectException

Throws:

dbDirectException

getDate2

public java.util.Date getDate2(java.lang.String d)
                        throws dbDirectException

Throws:

dbDirectException

getDate3

public java.util.Date getDate3(java.lang.String d)
                        throws dbDirectException

getDate3 This method converts a string into a java date--it is assumed that the format of the incoming string is yyyy-MM-dd HH:mm:ss

Parameters:

d - String

Returns:

Date

Throws:

dbDirectException

getPassword

public java.lang.String getPassword()

getUserName

public java.lang.String getUserName()

ResultSetToHashMap

public java.util.HashMap ResultSetToHashMap(java.sql.ResultSet oResultSet)
                                     throws dbDirectException

Converts 2 column recordset to a HashMap

Parameters:

oResultSet - ResultSet

Returns:

ResultSet

Throws:

dbDirectException

runStoredProcedure

public int runStoredProcedure(java.lang.String StoredProcedure,
                              java.lang.String[] parameters)
                       throws dbDirectException

Generic Function for call stored procedure and returning an integer from it

Parameters:

StoredProcedure - String

parameters - String[]

Returns:

int

Throws:

java.sql.SQLException

dbDirectException

runStoredProcedureNoReturn

public void runStoredProcedureNoReturn(java.lang.String StoredProcedure,
                                       java.lang.String[] parameters)
                                throws dbDirectException

Generic Function for call stored procedure with no return

Parameters:

StoredProcedure - String

parameters - String[]

Throws:

java.sql.SQLException

dbDirectException

runStoredProcedureNoReturnWithBLOB

public void runStoredProcedureNoReturnWithBLOB(java.lang.String StoredProcedure,
                                               java.lang.String[] parameters,
                                               byte[] BLOB)
                                        throws dbDirectException

Generic Function for call stored procedure with no return + BINARY INPUT

Parameters:

StoredProcedure - String

parameters - String[]

BLOB - byte[]

Throws:

java.sql.SQLException

dbDirectException