cgl.narada.service.storage.db
Class DataAccessObject

java.lang.Object
  cgl.narada.service.storage.db.DataAccessObject

public class DataAccessObject
extends Object

Constructor Summary

DataAccessObject()
default constructor to initilize a connection required methods should be called sequentially as follows 1-) setDriver(parameter) 2-) setConnnectionInfo(parameters) 3-) setUserParameters(parameters) optional 4-) initilizeConnection();

Method Summary

ResultSet	executePreparedQuery(String pSqlQuery)
int	executeUpdate(String sqlQuery) to insert, delete query to execute in DB
Connection	getConnection()
String	getConnectionInfo()
PreparedStatement	getPreparedStatement(String pSqlQuery)
void	initilizeConnection() initialize the database connection
static void	main(String[] args)
void	setConnectionParameters(String provider, String host, String db) sets connection parameters
void	setConnectionParameters(String provider, String host, String port, String db) sets connection parameters
void	setConnnectionInfo(String cinfo) sets connection info without setting parameters
void	setConnnectionInfo(String provider, String host, String db) compose connection information from provided parameters
void	setConnnectionInfo(String provider, String host, String port, String db) compose connection information from provided parameters
void	setDriver(String driver) sets database driver
void	setUserParameters(String uname, String password) sets user name and passwords

Methods inherited from class java.lang.Object

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

Constructor Detail

DataAccessObject

public DataAccessObject()
                 throws ServiceException

default constructor to initilize a connection required methods should be called sequentially as follows 1-) setDriver(parameter) 2-) setConnnectionInfo(parameters) 3-) setUserParameters(parameters) optional 4-) initilizeConnection();

Throws:

ServiceException

Method Detail

setDriver

public void setDriver(String driver)

sets database driver

Parameters:

driver -

setConnectionParameters

public void setConnectionParameters(String provider,
                                    String host,
                                    String db)

sets connection parameters

Parameters:

provider -

host -

db -

setConnectionParameters

public void setConnectionParameters(String provider,
                                    String host,
                                    String port,
                                    String db)

sets connection parameters

Parameters:

provider -

host -

port -

db -

setConnnectionInfo

public void setConnnectionInfo(String cinfo)

sets connection info without setting parameters

Parameters:

cinfo - connection information

setConnnectionInfo

public void setConnnectionInfo(String provider,
                               String host,
                               String db)

compose connection information from provided parameters

Parameters:

provider -

host -

db -

setConnnectionInfo

public void setConnnectionInfo(String provider,
                               String host,
                               String port,
                               String db)

compose connection information from provided parameters

Parameters:

provider -

host -

port -

db -

getConnectionInfo

public String getConnectionInfo()

Returns:

connection information to connect database

setUserParameters

public void setUserParameters(String uname,
                              String password)

sets user name and passwords

Parameters:

uname - database user name

password - database user password

getConnection

public Connection getConnection()

initilizeConnection

public void initilizeConnection()
                         throws ServiceException

initialize the database connection

Throws:

ServiceException

executePreparedQuery

public ResultSet executePreparedQuery(String pSqlQuery)
                               throws ServiceException

Throws:

ServiceException

getPreparedStatement

public PreparedStatement getPreparedStatement(String pSqlQuery)
                                       throws ServiceException

Throws:

ServiceException

executeUpdate

public int executeUpdate(String sqlQuery)
                  throws ServiceException

to insert, delete query to execute in DB

Parameters:

sqlQuery -

Throws:

ServiceException

main

public static void main(String[] args)