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

Fields

Modifier and Type	Field and Description
static java.lang.String	COPYRIGHT IBM copyright notice field.
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

Constructors

Constructor and Description
DBConnection() Construct a DBConnection object.

Method Summary

Modifier and Type	Method and Description
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

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

Field Detail

COPYRIGHT

public static final java.lang.String COPYRIGHT

IBM copyright notice field.

See Also:

Constant Field Values

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 DB390.

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.

See Also:

Constant Field Values

DB2_URL_PFX

public static final java.lang.String DB2_URL_PFX

DB2 URL prefix. Set to jdbc:db2: .

See Also:

Constant Field Values

DB400_DRIVER

public static final java.lang.String DB400_DRIVER

DB2 JDBC driver. Set to com.ibm.db2.jdbc.app.DB2Driver.

See Also:

Constant Field Values

ORACLE_DRIVER

public static final java.lang.String ORACLE_DRIVER

Oracle JDBC driver. Set to oracle.jdbc.driver.OracleDriver.

See Also:

Constant Field Values

ORACLE_URL_PFX

public static final java.lang.String ORACLE_URL_PFX

Oracle URL prefix. Set to jdbc:oracle:thin:@.

See Also:

Constant Field Values

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.

disconnectTo

public boolean disconnectTo()

Disconnects from the database.

Returns:

true if successful ; false otherwise.

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.