com.ibm.commerce.marketingcenter.events.util
Class DBConnection

java.lang.Object
  |
  +--com.ibm.commerce.marketingcenter.events.util.DBConnection

public class DBConnection
extends java.lang.Object

This class is used to establish a connection with a database.


Field Summary
static java.lang.String COPYRIGHT
           
static java.lang.String DB_400
          String to identify the DB2 database on the AS/400 platform.
static java.lang.String DB_DB2
          String to identify DB2 database.
static java.lang.String DB_DB2_390
          String to identify the database DB2 on the 390 platform.
static java.lang.String DB_ORACLE
          String to identify Oracle database.
static java.lang.String DB2_DRIVER
          DB2 JDBC driver.
static java.lang.String DB2_URL_PFX
          DB2 URL prefix.
static java.lang.String DB400_DRIVER
          DB2 JDBC driver.
static java.lang.String ORACLE_DRIVER
          Oracle JDBC driver.
static java.lang.String ORACLE_URL_PFX
          Oracle URL prefix.
 
Constructor Summary
DBConnection()
          Construct a DBConnection object.
 
Method Summary
 boolean connectTo(java.lang.String url, java.lang.String id, java.lang.String pw)
          Connects to a database.
 boolean disconnectTo()
          Disconnects from the database.
 java.sql.Connection getCon()
          Getter for the database connection.
 java.lang.String getDatabase()
          Getter for the database name.
 java.lang.String getDBType()
          Getter for the database type.
 java.lang.String getPasswd()
          Getter for the user's password.
 java.lang.String getUser()
          Getter for the user.
 void setCon(java.sql.Connection newCon)
          Setter for database connection.
 void setDatabase(java.lang.String newDatabase)
          Setter for the database name.
 void setDBType(java.lang.String newDBType)
          Setter for the database type.
 void setPasswd(java.lang.String newPasswd)
          Setter for the user's password.
 void setUser(java.lang.String newUser)
          Setter for the user.
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

COPYRIGHT

public static final java.lang.String COPYRIGHT

DB_400

public static final java.lang.String DB_400
String to identify the DB2 database on the AS/400 platform. Set to DB400.

DB_DB2

public static final java.lang.String DB_DB2
String to identify DB2 database. Set to DB2.

DB_DB2_390

public static final java.lang.String DB_DB2_390
String to identify the database DB2 on the 390 platform. Set to DB2/390.

DB_ORACLE

public static final java.lang.String DB_ORACLE
String to identify Oracle database. Set to ORACLE.

DB2_DRIVER

public static final java.lang.String DB2_DRIVER
DB2 JDBC driver. Set to COM.ibm.db2.jdbc.app.DB2Driver.

DB2_URL_PFX

public static final java.lang.String DB2_URL_PFX
DB2 URL prefix. Set to jdbc:db2: .

DB400_DRIVER

public static final java.lang.String DB400_DRIVER
DB2 JDBC driver. Set to com.ibm.db2.jdbc.app.DB2Driver.

ORACLE_DRIVER

public static final java.lang.String ORACLE_DRIVER
Oracle JDBC driver. Set to oracle.jdbc.driver.OracleDriver.

ORACLE_URL_PFX

public static final java.lang.String ORACLE_URL_PFX
Oracle URL prefix. Set to jdbc:oracle:thin:@.
Constructor Detail

DBConnection

public DBConnection()
Construct a DBConnection object.
Method Detail

connectTo

public boolean connectTo(java.lang.String url,
                         java.lang.String id,
                         java.lang.String pw)
Connects to a database.
Parameters:
url - The database name.
id - The user ID for the database.
pw - The password used by the user.
Returns:
true if successful ; false otherwise.
Throws:
SQLException. -  
ClassNotFoundException. -  

disconnectTo

public boolean disconnectTo()
Disconnects from the database.
Returns:
true if successful ; false otherwise.
Throws:
SQLException. -  

getCon

public java.sql.Connection getCon()
Getter for the database connection.
Returns:
The database connection.

getDatabase

public java.lang.String getDatabase()
Getter for the database name.
Returns:
The database name.

getDBType

public java.lang.String getDBType()
Getter for the database type.
Returns:
The database type.

getPasswd

public java.lang.String getPasswd()
Getter for the user's password.
Returns:
The user's password.

getUser

public java.lang.String getUser()
Getter for the user.
Returns:
The user.

setCon

public void setCon(java.sql.Connection newCon)
Setter for database connection.
Parameters:
newCon - The database connection.

setDatabase

public void setDatabase(java.lang.String newDatabase)
Setter for the database name.
Parameters:
newDatabase - The database name.

setDBType

public void setDBType(java.lang.String newDBType)
Setter for the database type.
Parameters:
newDBType - The database type.

setPasswd

public void setPasswd(java.lang.String newPasswd)
Setter for the user's password.
Parameters:
newPasswd - The user's password.

setUser

public void setUser(java.lang.String newUser)
Setter for the user.
Parameters:
newUser - The user.