org.aitools.programd.util.sql
Class DbAccess

java.lang.Object
  org.aitools.programd.util.sql.DbAccess

public class DbAccess
extends Object

Represents all connection details to a DBMS and allows for getting the input/output streams.

Uses JDBC so as to support any DBMS with a JDBS driver. For use with another DBMS one should change the classname for the Java Driver and the specific URL.

Sample:

 
  
   
    
      driver class name : "oracle.jdbc.dnlddriver.OracleDriver"
      specific URL : "dbc:oracle:dnldthin:@ora.doxa.ro:1526:ORCL".
      
    
   
  
 

Author:

Cristian Mircioiu

Field Summary

protected Connection	connection The Connection used by this object.
protected String	driver The name of the driver used by this object.
protected String	password The password used by this object.
protected Statement	statement The statement used by this object.
protected String	url The URL string used by this object.
protected String	user The user name used by this object.

Constructor Summary

DbAccess(Connection connectionToUse)
Constructs a DbAccess object given a Connection object.

DbAccess(String driverToUse, String urlToUse, String userToUse, String passwordToUse)
Constructs a DbAccess object given a driver, url, user name and password.

Method Summary

void	connect() Connects to the database using the values of the fields already set in this object.
ResultSet	executeQuery(String query) Returns the ResultSet from executing a given query.
int	executeUpdate(String update) Returns the ResultSet from executing a given update.
Connection	getConnection() Returns the Connection object used by this object.
String	getDriver() Returns the name of the driver used by this object.
String	getPassword() Returns the password used by this object.
Statement	getStatement() Returns the Statement object used by this object.
String	getUrl() Returns the URL string used by this object.
String	getUser() Returns the user name used by this object.
void	setConnection(Connection connectionToSet) Sets the Connection object used by this object.
void	setDriver(String driverToSet) Sets the name of the driver to be used by this object.
void	setPassword(String passwordToSet) Sets the password to be used by this object.
void	setUrl(String urlToSet) Sets the URL string to be used by this object.
void	setUser(String userToSet) Sets the user name to be used by this object.

Methods inherited from class java.lang.Object

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

Field Detail

connection

protected Connection connection

The Connection used by this object.

statement

protected Statement statement

The statement used by this object.

driver

protected String driver

The name of the driver used by this object.

url

protected String url

The URL string used by this object.

user

protected String user

The user name used by this object.

password

protected String password

The password used by this object.

Constructor Detail

DbAccess

public DbAccess(String driverToUse,
                String urlToUse,
                String userToUse,
                String passwordToUse)

Constructs a DbAccess object given a driver, url, user name and password.

Parameters:

driverToUse - name of the class representing the Driver to be used by the Driver manager

urlToUse - location of a data source name (dsn)

userToUse - user name

passwordToUse - password for user

DbAccess

public DbAccess(Connection connectionToUse)

Constructs a DbAccess object given a Connection object.

Parameters:

connectionToUse - the Connection object from which to construct the DbAccess object

Method Detail

connect

public void connect()

Connects to the database using the values of the fields already set in this object.

executeQuery

public ResultSet executeQuery(String query)

Returns the ResultSet from executing a given query.

Parameters:

query - the query to execute

Returns:

the ResultSet from executing a given query

executeUpdate

public int executeUpdate(String update)

Returns the ResultSet from executing a given update.

Parameters:

update - the update to execute

Returns:

the row count resulting from executing a given update

getConnection

public Connection getConnection()

Returns the Connection object used by this object.

Returns:

the Connection object used by this object.

getDriver

public String getDriver()

Returns the name of the driver used by this object.

Returns:

the name of the driver used by this object.

getPassword

public String getPassword()

Returns the password used by this object.

Returns:

the password used by this object.

getStatement

public Statement getStatement()

Returns the Statement object used by this object.

Returns:

the Statement object used by this object.

getUrl

public String getUrl()

Returns the URL string used by this object.

Returns:

the URL string used by this object.

getUser

public String getUser()

Returns the user name used by this object.

Returns:

the user name used by this object.

setConnection

public void setConnection(Connection connectionToSet)

Sets the Connection object used by this object.

Parameters:

connectionToSet - the Connection object to be used

setDriver

public void setDriver(String driverToSet)

Sets the name of the driver to be used by this object.

Parameters:

driverToSet - the name of the driver to be used

setPassword

public void setPassword(String passwordToSet)

Sets the password to be used by this object.

Parameters:

passwordToSet - the password to be used

setUrl

public void setUrl(String urlToSet)

Sets the URL string to be used by this object.

Parameters:

urlToSet - the URL string to be used

setUser

public void setUser(String userToSet)

Sets the user name to be used by this object.

Parameters:

userToSet - the user name to be used