A C D E F G I N P R S T

A

addStatement(String, String, int) - Method in class com.tsc.util.db.DBBean

Adds a statement that can be selected afterwards with selectStatement.

C

CON_MODE_DIRECT - Static variable in class com.tsc.util.db.DBBean

connectionMode value for a Direct connection.

CON_MODE_DS - Static variable in class com.tsc.util.db.DBBean

connectionMode value for a pooled IBM WAS connection with datasource

CON_MODE_SHARED - Static variable in class com.tsc.util.db.DBBean

connectionMode value for a shared connection connection won't be closed in releaseRessources

closeAllResultSets() - Method in class com.tsc.util.db.DBBean

Closes the resultSet

closeAllStatements() - Method in class com.tsc.util.db.DBBean

Calls closeResultSet() then closes every statements previously created.

closeResultSet() - Method in class com.tsc.util.db.DBBean

Closes the resultSet

com.tsc.util.db - package com.tsc.util.db

commit() - Method in class com.tsc.util.db.DBBean

Calls commit method over the connection.

config - Variable in class com.tsc.util.db.DBBean

Holds statements, their sql and their statementType

connect() - Method in class com.tsc.util.db.DBBean

Connects the object depending on the connectionMode.

connected - Variable in class com.tsc.util.db.DBBean

Tells if this DBBean is currently connected

connection - Variable in class com.tsc.util.db.DBBean

Holds the connection

connectionHolder - Variable in class com.tsc.util.db.DBBean

Tells if the connection has been created by this bean or not.

connectionMode - Variable in class com.tsc.util.db.DBBean

Holds the connection mode

countResultSets() - Method in class com.tsc.util.db.DBBean

D

DBBean - class com.tsc.util.db.DBBean.

Provides functionalities to:
Connect to a database or use an existing connection. Manage sql and coresponding Statement. Clean up usage of those resources

DBBean() - Constructor for class com.tsc.util.db.DBBean

Constructor.

DBBean(String) - Constructor for class com.tsc.util.db.DBBean

Construct using a datasource.

DBBean(String, int) - Constructor for class com.tsc.util.db.DBBean

Construct using a datasource.

DBBean(String, String, String) - Constructor for class com.tsc.util.db.DBBean

Construct using a datasource.

DBBean(String, String, String, int) - Constructor for class com.tsc.util.db.DBBean

Construct using a datasource.

DBBean(String, String, String, String) - Constructor for class com.tsc.util.db.DBBean

Construct using a driver/url pair Sets connection mode to CON_MODE_DIRECT.

DBBean(String, String, String, String, int) - Constructor for class com.tsc.util.db.DBBean

Construct using a driver/url pair Sets connection mode to CON_MODE_DIRECT.

DBBean(Connection) - Constructor for class com.tsc.util.db.DBBean

Construct object using a shared connection.

DBBean(Connection, int) - Constructor for class com.tsc.util.db.DBBean

Construct object using a shared connection.

dbDataSourceName - Variable in class com.tsc.util.db.DBBean

Holds the dataSourcename for connection

dbDriver - Variable in class com.tsc.util.db.DBBean

Holds the driver for connection

dbPassword - Variable in class com.tsc.util.db.DBBean

Holds the password for connection

dbUrl - Variable in class com.tsc.util.db.DBBean

Holds the url for connection

dbUsername - Variable in class com.tsc.util.db.DBBean

Holds the username for connection

disconnect() - Method in class com.tsc.util.db.DBBean

Calls closeResultSet(), closeAllStatements() then closes the connection if it was not using a shared one.

E

executeQuery() - Method in class com.tsc.util.db.DBBean

Executes query on the current statement

executeUpdate() - Method in class com.tsc.util.db.DBBean

Executes update on the current statement

F

finalize() - Method in class com.tsc.util.db.DBBean

Normally called by the garbage collector; calls releaseRessources.

G

getArray(int) - Method in class com.tsc.util.db.DBBean

If stattementType == STMT_TYPE_CALLABLE calls the same method on the statement

getBigDecimal(int) - Method in class com.tsc.util.db.DBBean

If stattementType == STMT_TYPE_CALLABLE calls the same method on the statement

getBlob(int) - Method in class com.tsc.util.db.DBBean

If stattementType == STMT_TYPE_CALLABLE calls the same method on the statement

getBoolean(int) - Method in class com.tsc.util.db.DBBean

If stattementType == STMT_TYPE_CALLABLE calls the same method on the statement

getByte(int) - Method in class com.tsc.util.db.DBBean

If stattementType == STMT_TYPE_CALLABLE calls the same method on the statement

getBytes(int) - Method in class com.tsc.util.db.DBBean

If stattementType == STMT_TYPE_CALLABLE calls the same method on the statement

getCallableStatement() - Method in class com.tsc.util.db.DBBean

Returns the current statement casted as a CallableStatement.

getClob(int) - Method in class com.tsc.util.db.DBBean

If stattementType == STMT_TYPE_CALLABLE calls the same method on the statement

getConnection() - Method in class com.tsc.util.db.DBBean

Returns the connection.

getConnectionMode() - Method in class com.tsc.util.db.DBBean

Returns connectionMode.

getDate(int) - Method in class com.tsc.util.db.DBBean

If stattementType == STMT_TYPE_CALLABLE calls the same method on the statement

getDate(int, Calendar) - Method in class com.tsc.util.db.DBBean

If stattementType == STMT_TYPE_CALLABLE calls the same method on the statement

getDbDataSourceName() - Method in class com.tsc.util.db.DBBean

Returns dataSourceName.

getDbDriver() - Method in class com.tsc.util.db.DBBean

Returns driver name.

getDbPassword() - Method in class com.tsc.util.db.DBBean

Returns password.

getDbUrl() - Method in class com.tsc.util.db.DBBean

Returns db url.

getDbUsername() - Method in class com.tsc.util.db.DBBean

Returns db username.

getDouble(int) - Method in class com.tsc.util.db.DBBean

If stattementType == STMT_TYPE_CALLABLE calls the same method on the statement

getFloat(int) - Method in class com.tsc.util.db.DBBean

If stattementType == STMT_TYPE_CALLABLE calls the same method on the statement

getInt(int) - Method in class com.tsc.util.db.DBBean

If stattementType == STMT_TYPE_CALLABLE calls the same method on the statement

getLong(int) - Method in class com.tsc.util.db.DBBean

If stattementType == STMT_TYPE_CALLABLE calls the same method on the statement

getObject(int) - Method in class com.tsc.util.db.DBBean

If stattementType == STMT_TYPE_CALLABLE calls the same method on the statement

getObject(int, Map) - Method in class com.tsc.util.db.DBBean

If stattementType == STMT_TYPE_CALLABLE calls the same method on the statement

getPreparedStatement() - Method in class com.tsc.util.db.DBBean

Returns the current statement casted as a PreparedStatement.

getRef(int) - Method in class com.tsc.util.db.DBBean

If stattementType == STMT_TYPE_CALLABLE calls the same method on the statement

getResultSet() - Method in class com.tsc.util.db.DBBean

Returns resultSet.

getResultSet(String) - Method in class com.tsc.util.db.DBBean

Returns resultSet.

getShort(int) - Method in class com.tsc.util.db.DBBean

If stattementType == STMT_TYPE_CALLABLE calls the same method on the statement

getStatement() - Method in class com.tsc.util.db.DBBean

Returns the current statement as a java.sql.Statement.

getStatementSql() - Method in class com.tsc.util.db.DBBean

Returns current statement sql.

getString(int) - Method in class com.tsc.util.db.DBBean

If stattementType == STMT_TYPE_CALLABLE calls the same method on the statement

getTime(int) - Method in class com.tsc.util.db.DBBean

If stattementType == STMT_TYPE_CALLABLE calls the same method on the statement

getTime(int, Calendar) - Method in class com.tsc.util.db.DBBean

If stattementType == STMT_TYPE_CALLABLE calls the same method on the statement

getTimestamp(int) - Method in class com.tsc.util.db.DBBean

If stattementType == STMT_TYPE_CALLABLE calls the same method on the statement

getTimestamp(int, Calendar) - Method in class com.tsc.util.db.DBBean

If stattementType == STMT_TYPE_CALLABLE calls the same method on the statement

getTransactMode() - Method in class com.tsc.util.db.DBBean

Returns transactMode.

I

isConnected() - Method in class com.tsc.util.db.DBBean

Insert the method's description here.

N

names - Variable in class com.tsc.util.db.DBBean

Holds statements, their sql and their statementType

P

postConnect() - Method in class com.tsc.util.db.DBBean

This method is empty and should be overridden whenever you must do something right after the connection.

postExecute() - Method in class com.tsc.util.db.DBBean

This method is empty, and should be overridden whenever you need to do something after executeQuery/Update.

preExecute() - Method in class com.tsc.util.db.DBBean

This method is empty, it MUST be overridden in order to select the current statement so that the execution can go on.

printConfig() - Method in class com.tsc.util.db.DBBean

Insert the method's description here.

R

RESULT_MODE_KEEP - Static variable in class com.tsc.util.db.DBBean

resultMode is keep, all results returning from a callable statement will be keeped so that getMoreResults, getUpdateCount, getResultSet can be played with

RESULT_MODE_SKIP - Static variable in class com.tsc.util.db.DBBean

resultMode is skip, all results returning from a callable statement will be skipped so that OUTPUT parameters can be accesed right away

registerOutParameter(int, int) - Method in class com.tsc.util.db.DBBean

If stattementType == STMT_TYPE_CALLABLE calls the same method on the statement

registerOutParameter(int, int, int) - Method in class com.tsc.util.db.DBBean

If stattementType == STMT_TYPE_CALLABLE calls the same method on the statement

registerOutParameter(int, int, String) - Method in class com.tsc.util.db.DBBean

If stattementType == STMT_TYPE_CALLABLE calls the same method on the statement

releaseResources() - Method in class com.tsc.util.db.DBBean

Calls closeResultSet(), removeStatements(), disconnect()

removeAllStatements() - Method in class com.tsc.util.db.DBBean

Calls closeStatements(), and remove statements difinitions previously added with addStatements()

removeStatement(String) - Method in class com.tsc.util.db.DBBean

Removes a statement definition.

resultMode - Variable in class com.tsc.util.db.DBBean

Holds the result mode

resultSet - Variable in class com.tsc.util.db.DBBean

Holds the result after an executeQuery

rollback() - Method in class com.tsc.util.db.DBBean

Calls rollback method on the connection.

rowsAffected - Variable in class com.tsc.util.db.DBBean

Holds the result after an executeUpdate

S

STMT_TYPE_CALLABLE - Static variable in class com.tsc.util.db.DBBean

statement created will be of type java.sql.CallableStatement

STMT_TYPE_PREPARED - Static variable in class com.tsc.util.db.DBBean

statement created will be of type java.sql.PreparedStatement

STMT_TYPE_STATEMENT - Static variable in class com.tsc.util.db.DBBean

statement created will be of type java.sql.Statement

selectStatement(String) - Method in class com.tsc.util.db.DBBean

This method sets the current statement.

selectStatement(String, boolean) - Method in class com.tsc.util.db.DBBean

This method sets the current statement.

setArray(int, Array) - Method in class com.tsc.util.db.DBBean

If stattementType == ( STMT_TYPE_CALLABLE or STMT_TYPE_PREPARED ) calls the same method on the statement

setAsciiStream(int, InputStream, int) - Method in class com.tsc.util.db.DBBean

If stattementType == ( STMT_TYPE_CALLABLE or STMT_TYPE_PREPARED ) calls the same method on the statement

setBigDecimal(int, BigDecimal) - Method in class com.tsc.util.db.DBBean

If stattementType == ( STMT_TYPE_CALLABLE or STMT_TYPE_PREPARED ) calls the same method on the statement

setBinaryStream(int, InputStream, int) - Method in class com.tsc.util.db.DBBean

If stattementType == ( STMT_TYPE_CALLABLE or STMT_TYPE_PREPARED ) calls the same method on the statement

setBlob(int, Blob) - Method in class com.tsc.util.db.DBBean

If stattementType == ( STMT_TYPE_CALLABLE or STMT_TYPE_PREPARED ) calls the same method on the statement

setBoolean(int, boolean) - Method in class com.tsc.util.db.DBBean

If stattementType == ( STMT_TYPE_CALLABLE or STMT_TYPE_PREPARED ) calls the same method on the statement

setByte(int, byte) - Method in class com.tsc.util.db.DBBean

If stattementType == ( STMT_TYPE_CALLABLE or STMT_TYPE_PREPARED ) calls the same method on the statement

setBytes(int, byte[]) - Method in class com.tsc.util.db.DBBean

If stattementType == ( STMT_TYPE_CALLABLE or STMT_TYPE_PREPARED ) calls the same method on the statement

setCharacterStream(int, Reader, int) - Method in class com.tsc.util.db.DBBean

If stattementType == ( STMT_TYPE_CALLABLE or STMT_TYPE_PREPARED ) calls the same method on the statement

setClob(int, Clob) - Method in class com.tsc.util.db.DBBean

If stattementType == ( STMT_TYPE_CALLABLE or STMT_TYPE_PREPARED ) calls the same method on the statement

setConnection(Connection) - Method in class com.tsc.util.db.DBBean

Sets the connection for this bean and automatically set connectionMode to CON_MODE_SHARED

setConnectionMode(int) - Method in class com.tsc.util.db.DBBean

Sets the connection mode

setDate(int, Date) - Method in class com.tsc.util.db.DBBean

If stattementType == ( STMT_TYPE_CALLABLE or STMT_TYPE_PREPARED ) calls the same method on the statement

setDate(int, Date, Calendar) - Method in class com.tsc.util.db.DBBean

If stattementType == ( STMT_TYPE_CALLABLE or STMT_TYPE_PREPARED ) calls the same method on the statement

setDbDataSourceName(String) - Method in class com.tsc.util.db.DBBean

Sets the datasourcename

setDbDriver(String) - Method in class com.tsc.util.db.DBBean

Sets the jdbc sql driver to use for connection

setDbPassword(String) - Method in class com.tsc.util.db.DBBean

Sets db connection password

setDbUrl(String) - Method in class com.tsc.util.db.DBBean

Sets the database connection jdbc url

setDbUsername(String) - Method in class com.tsc.util.db.DBBean

Sets db username to connect

setDouble(int, double) - Method in class com.tsc.util.db.DBBean

If stattementType == ( STMT_TYPE_CALLABLE or STMT_TYPE_PREPARED ) calls the same method on the statement

setFloat(int, float) - Method in class com.tsc.util.db.DBBean

If stattementType == ( STMT_TYPE_CALLABLE or STMT_TYPE_PREPARED ) calls the same method on the statement

setInt(int, int) - Method in class com.tsc.util.db.DBBean

If stattementType == ( STMT_TYPE_CALLABLE or STMT_TYPE_PREPARED ) calls the same method on the statement

setLong(int, long) - Method in class com.tsc.util.db.DBBean

If stattementType == ( STMT_TYPE_CALLABLE or STMT_TYPE_PREPARED ) calls the same method on the statement

setNull(int, int) - Method in class com.tsc.util.db.DBBean

If stattementType == ( STMT_TYPE_CALLABLE or STMT_TYPE_PREPARED ) calls the same method on the statement

setNull(int, int, String) - Method in class com.tsc.util.db.DBBean

If stattementType == ( STMT_TYPE_CALLABLE or STMT_TYPE_PREPARED ) calls the same method on the statement

setObject(int, Object) - Method in class com.tsc.util.db.DBBean

If stattementType == ( STMT_TYPE_CALLABLE or STMT_TYPE_PREPARED ) calls the same method on the statement

setObject(int, Object, int) - Method in class com.tsc.util.db.DBBean

If stattementType == ( STMT_TYPE_CALLABLE or STMT_TYPE_PREPARED ) calls the same method on the statement

setObject(int, Object, int, int) - Method in class com.tsc.util.db.DBBean

If stattementType == ( STMT_TYPE_CALLABLE or STMT_TYPE_PREPARED ) calls the same method on the statement

setRef(int, Ref) - Method in class com.tsc.util.db.DBBean

If stattementType == ( STMT_TYPE_CALLABLE or STMT_TYPE_PREPARED ) calls the same method on the statement

setShort(int, short) - Method in class com.tsc.util.db.DBBean

If stattementType == ( STMT_TYPE_CALLABLE or STMT_TYPE_PREPARED ) calls the same method on the statement

setString(int, String) - Method in class com.tsc.util.db.DBBean

If stattementType == ( STMT_TYPE_CALLABLE or STMT_TYPE_PREPARED ) calls the same method on the statement

setTime(int, Time) - Method in class com.tsc.util.db.DBBean

If stattementType == ( STMT_TYPE_CALLABLE or STMT_TYPE_PREPARED ) calls the same method on the statement

setTime(int, Time, Calendar) - Method in class com.tsc.util.db.DBBean

If stattementType == ( STMT_TYPE_CALLABLE or STMT_TYPE_PREPARED ) calls the same method on the statement

setTimestamp(int, Timestamp) - Method in class com.tsc.util.db.DBBean

If stattementType == ( STMT_TYPE_CALLABLE or STMT_TYPE_PREPARED ) calls the same method on the statement

setTimestamp(int, Timestamp, Calendar) - Method in class com.tsc.util.db.DBBean

If stattementType == ( STMT_TYPE_CALLABLE or STMT_TYPE_PREPARED ) calls the same method on the statement

setTransactMode(int) - Method in class com.tsc.util.db.DBBean

Sets transactional mode

skipResults() - Method in class com.tsc.util.db.DBBean

Executes update on the current statement

statement - Variable in class com.tsc.util.db.DBBean

Holds the currently selected statement

statementName - Variable in class com.tsc.util.db.DBBean

Holds the name of the currently selected statement

statementSql - Variable in class com.tsc.util.db.DBBean

Holds the sql of the currently selected statement

statementType - Variable in class com.tsc.util.db.DBBean

Holds the type of the current statement

T

TRX_MODE_AUTOCOMMIT - Static variable in class com.tsc.util.db.DBBean

transactMode is autocommit, setAutoCommit(true) will be call on the connection

TRX_MODE_TRANSACTIONAL - Static variable in class com.tsc.util.db.DBBean

transactMode is not autocommit, setAutoCommit(false) will be call on the connection

TRX_MODE_UNKNOWN - Static variable in class com.tsc.util.db.DBBean

transactMode is unknown, nothing special happens

transactMode - Variable in class com.tsc.util.db.DBBean

Holds the transactional mode

A C D E F G I N P R S T