RunDB

java.lang.Object
- com.sdb.dbwork.RunDB

```
public class RunDB
extends java.lang.Object
```
RunDB is the class that performs basic database operations. It is prepared for direct use or used by ExecuteTable.
Example;
runDB = new RunDB(connType);
runDB.setDB(jndiName);
queryString[0] = "select linked_page, theme from vt_jbc_page_link where link_name='"+linkName+"'";
if(!runDB.runQuery(queryString, 0, RunDB.QUERY)) errorString = runDB.errorString;
else resultSet = runDB.getResultSet();

Field Summary

Fields
Modifier and Type	Field and Description
`static int`	`BATCH` This integer represent of sql execution type.
`protected int`	`batchBegan`
`protected java.lang.String`	`CFN_DB2` This integer represent of string for Class.forName(driver) usage.
`protected java.lang.String`	`CFN_HANA` This integer represent of string for Class.forName(driver) usage.
`protected java.lang.String`	`CFN_MARIADB` This integer represent of string for Class.forName(driver) usage.
`protected java.lang.String`	`CFN_MYSQL` This integer represent of string for Class.forName(driver) usage.
`protected java.lang.String`	`CFN_ORACLE` This integer represent of string for Class.forName(driver) usage.
`protected java.lang.String`	`CFN_POSTGRESQL` This integer represent of string for Class.forName(driver) usage.
`protected java.lang.String`	`CFN_SQLSERVER` This integer represent of string for Class.forName(driver) usage.
`protected java.sql.Connection`	`connection`
`protected java.lang.String`	`connString` Database connection string.
`protected int`	`connType`
`protected javax.sql.DataSource`	`dataSource` DataSource object instance for data source connection.
`static int`	`DATASOURCE` This integer represent of DB connection type.
`static int`	`DATE` This integer represent of data type.
`static int`	`DB2` This integer represent of DB2 RDBMS type.
`protected int`	`dbSystem` Database system selection integer representation.
`protected java.lang.String`	`defErrStr`
`protected java.lang.String`	`defMsgScr`
`protected java.lang.String`	`defResMsg`
`static int`	`DRIVERMANAGER` This integer represent of DB connection type.
`protected java.lang.String`	`errorString` String for error messages.
`protected int`	`execCount`
`static int`	`EXECUTE` This integer represent of sql execution type.
`static int`	`HANA` This integer represent of HANA RDBMS type.
`static int`	`INTEGER` This integer represent of data type.
`protected java.lang.String`	`jndiName` jndiName string for data source connection.
`static int`	`MARIADB` This integer represent of MARIADB RDBMS type.
`protected int`	`maxRecord`
`protected java.lang.String`	`messageScript` String for general messages.
`static int`	`MYSQL` This integer represent of MySQL RDBMS type.
`static int`	`NUMBER` This integer represent of data type.
`static int`	`ORACLE` This integer represent of Oracle RDBMS type.
`protected java.lang.String`	`password`
`static int`	`POSTGRESQL` This integer represent of Postgresql RDBMS type.
`static int`	`QUERY` This integer represent of sql execution type.
`protected int`	`recordNumber`
`protected java.lang.String`	`resultMessage` String for DB process results.
`protected java.sql.ResultSet`	`resultSet`
`static int`	`SQLSERVER` This integer represent of SQL Server RDBMS type.
`protected java.sql.Statement`	`statement`
`static int`	`STRING` This integer represent of data type.
`static int`	`UPDATE` This integer represent of sql execution type.
`protected java.lang.String`	`url`
`protected java.lang.String`	`user`

Constructor Summary

Constructors
Constructor and Description
`RunDB()` The constructor retrieves no parameter.
`RunDB(int connType)` The constructor retrieves database connection type.
`RunDB(int dbSystem, int connType)` The constructor retrieves database RDBMS type and database connection type.

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`void`	`closeAll()` This method is useful for closing connection, statement, resultSet object instances.
`boolean`	`connectDB()` Database connection method.
`int[]`	`getBatchReturn()` For getting batch return.
`java.lang.String`	`getCFN_DB2()` For getting class for name DB2
`java.lang.String`	`getCFN_HANA()` For getting class for name HANA
`java.lang.String`	`getCFN_MARIADB()` For getting class for name MARIADB
`java.lang.String`	`getCFN_MYSQL()` For getting class for name MYSQL.
`java.lang.String`	`getCFN_ORACLE()` For getting class for name ORACLE.
`java.lang.String`	`getCFN_POSTGRESQL()` For getting class for name POSTGRESQL.
`java.lang.String`	`getCFN_SQLSERVER()` For getting class for name SQLSERVER.
`java.sql.Connection`	`getConnection()` For getting connection.
`java.lang.String`	`getConnString()` For getting connection string.
`int`	`getConnType()` For getting connType
`java.lang.Object[][]`	`getData(int dataType, int rowCount, int fieldCount)` The number of records that have been executed before, the type of data, and retrieves the data according to the number of fields to be drawn from the table (or view).
`java.sql.Date[][]`	`getDateData()` For getting date data.
`int`	`getDbSystem()` For getting dbSystem
`java.lang.Double[][]`	`getDoubleData()` For getting double data.
`java.lang.String`	`getErrorString()` For getting error string.
`int`	`getExecCount()` For getting execCount
`java.lang.Integer[][]`	`getIntegerData()` For getting integer data.
`int`	`getMaxRecord()` For getting max record number
`java.lang.String`	`getMessageScript()` For getting messageScript
`java.lang.Object[]`	`getRefData(int dataType, int fieldCount)` Retrieves data based on the previously executed reference data query, data type, and the number of fields to be taken from the table (or views).
`java.lang.String`	`getResultMessage()` For getting resultMessage
`java.sql.ResultSet`	`getResultSet()` For getting resultSet
`int`	`getRowCount()` After the query is created to calculate the number of records, the number of records returned from the query result.
`java.lang.String[][]`	`getStringData()` For getting string data.
`void`	`initRunDB()` For initializing default values.
`boolean`	`isExec()` For getting is exec
`boolean`	`isLocale()` For getting isLocale
`boolean`	`isUpdate()` For getting isUpdate
`boolean`	`runQuery(java.lang.String[] queryString, int arrayNo, int queryType)` Runs the query based on the query type and the order in the query array.
`void`	`setBatchBegan(int batchBegan)` For setting batch began number
`void`	`setCFN_DB2(java.lang.String CFN_DB2)` For setting class for name DB2.
`void`	`setCFN_HANA(java.lang.String cFN_HANA)` For setting class for name HANA.
`void`	`setCFN_MARIADB(java.lang.String cFN_MARIADB)` For setting class for name MARIADB.
`void`	`setCFN_MYSQL(java.lang.String CFN_MYSQL)` For setting class for name MYSQL
`void`	`setCFN_ORACLE(java.lang.String CFN_ORACLE)` For setting class for name ORACLE.
`void`	`setCFN_POSTGRESQL(java.lang.String CFN_POSTGRESQL)` For setting class for name POSTGRESQL.
`void`	`setCFN_SQLSERVER(java.lang.String CFN_SQLSERVER)` For setting class for name SQLSERVER
`boolean`	`setConnection()` Database connection method. if connType is DATASOURCE, Connects to the database by using the jndiName.
`void`	`setConnection(java.sql.Connection connection)` For setting connection.
`void`	`setConnString(java.lang.String connString)` For setting connection string.
`void`	`setConnType(int connType)` For setting connType
`void`	`setDB(int dbSystem, java.lang.String connString)` This method set DB connection info for DRIVERMANAGER type.
`void`	`setDB(int dbSystem, java.lang.String url, java.lang.String user, java.lang.String password)` This method set DB connection info for DRIVERMANAGER type.
`void`	`setDB(java.lang.String jndiName)` This method set DB connection info for DATASOURCE type.
`void`	`setDbSystem(int dbSystem)` For setting dbSystem
`void`	`setDefErrStr(java.lang.String defErrStr)` For setting defErrStr
`void`	`setDefMsgScr(java.lang.String defMsgScr)` For setting defMsgScr
`void`	`setDefResMsg(java.lang.String defResMsg)` For setting defResMsg
`void`	`setLocale(boolean isLocale)` For setting isLocale
`void`	`setMaxRecord(int maxRecord)` For setting max record number.
`void`	`setMessageBean(boolean isLocale)` For initializing default messages.
`void`	`setUpdate(boolean isUpdate)` For setting isUpdate

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Field Detail
  - MYSQL
```
public static final int MYSQL
```
    This integer represent of MySQL RDBMS type.
    
    See Also:
    
    Constant Field Values
  - SQLSERVER
```
public static final int SQLSERVER
```
    This integer represent of SQL Server RDBMS type.
    
    See Also:
    
    Constant Field Values
  - ORACLE
```
public static final int ORACLE
```
    This integer represent of Oracle RDBMS type.
    
    See Also:
    
    Constant Field Values
  - POSTGRESQL
```
public static final int POSTGRESQL
```
    This integer represent of Postgresql RDBMS type.
    
    See Also:
    
    Constant Field Values
  - DB2
```
public static final int DB2
```
    This integer represent of DB2 RDBMS type.
    
    See Also:
    
    Constant Field Values
  - HANA
```
public static final int HANA
```
    This integer represent of HANA RDBMS type.
    
    See Also:
    
    Constant Field Values
  - MARIADB
```
public static final int MARIADB
```
    This integer represent of MARIADB RDBMS type.
    
    See Also:
    
    Constant Field Values
  - EXECUTE
```
public static final int EXECUTE
```
    This integer represent of sql execution type.
    
    See Also:
    
    Constant Field Values
  - QUERY
```
public static final int QUERY
```
    This integer represent of sql execution type.
    
    See Also:
    
    Constant Field Values
  - UPDATE
```
public static final int UPDATE
```
    This integer represent of sql execution type.
    
    See Also:
    
    Constant Field Values
  - BATCH
```
public static final int BATCH
```
    This integer represent of sql execution type.
    
    See Also:
    
    Constant Field Values
  - DATASOURCE
```
public static final int DATASOURCE
```
    This integer represent of DB connection type.
    
    See Also:
    
    Constant Field Values
  - DRIVERMANAGER
```
public static final int DRIVERMANAGER
```
    This integer represent of DB connection type.
    
    See Also:
    
    Constant Field Values
  - STRING
```
public static final int STRING
```
    This integer represent of data type.
    
    See Also:
    
    Constant Field Values
  - INTEGER
```
public static final int INTEGER
```
    This integer represent of data type.
    
    See Also:
    
    Constant Field Values
  - DATE
```
public static final int DATE
```
    This integer represent of data type.
    
    See Also:
    
    Constant Field Values
  - NUMBER
```
public static final int NUMBER
```
    This integer represent of data type.
    
    See Also:
    
    Constant Field Values
  - CFN_MYSQL
```
protected java.lang.String CFN_MYSQL
```
    This integer represent of string for Class.forName(driver) usage.
  - CFN_SQLSERVER
```
protected java.lang.String CFN_SQLSERVER
```
    This integer represent of string for Class.forName(driver) usage.
  - CFN_POSTGRESQL
```
protected java.lang.String CFN_POSTGRESQL
```
    This integer represent of string for Class.forName(driver) usage.
  - CFN_ORACLE
```
protected java.lang.String CFN_ORACLE
```
    This integer represent of string for Class.forName(driver) usage.
  - CFN_DB2
```
protected java.lang.String CFN_DB2
```
    This integer represent of string for Class.forName(driver) usage.
  - CFN_HANA
```
protected java.lang.String CFN_HANA
```
    This integer represent of string for Class.forName(driver) usage.
  - CFN_MARIADB
```
protected java.lang.String CFN_MARIADB
```
    This integer represent of string for Class.forName(driver) usage.
  - connString
```
protected java.lang.String connString
```
    Database connection string.
  - url
```
protected java.lang.String url
```
  - user
```
protected java.lang.String user
```
  - password
```
protected java.lang.String password
```
  - dbSystem
```
protected int dbSystem
```
    Database system selection integer representation.
  - defErrStr
```
protected java.lang.String defErrStr
```
  - defMsgScr
```
protected java.lang.String defMsgScr
```
  - defResMsg
```
protected java.lang.String defResMsg
```
  - errorString
```
protected java.lang.String errorString
```
    String for error messages.
  - messageScript
```
protected java.lang.String messageScript
```
    String for general messages.
  - resultMessage
```
protected java.lang.String resultMessage
```
    String for DB process results.
  - connection
```
protected java.sql.Connection connection
```
  - statement
```
protected java.sql.Statement statement
```
  - resultSet
```
protected java.sql.ResultSet resultSet
```
  - dataSource
```
protected javax.sql.DataSource dataSource
```
    DataSource object instance for data source connection.
  - jndiName
```
protected java.lang.String jndiName
```
    jndiName string for data source connection.
  - recordNumber
```
protected int recordNumber
```
  - connType
```
protected int connType
```
  - execCount
```
protected int execCount
```
  - maxRecord
```
protected int maxRecord
```
  - batchBegan
```
protected int batchBegan
```
- Constructor Detail
  - RunDB
```
public RunDB()
```
    The constructor retrieves no parameter. By default, DB system is MySQL and Connection type is datasource.
  - RunDB
```
public RunDB(int connType)
```
    The constructor retrieves database connection type. By default, DB system is MySQL.
    
    Parameters:
    
    connType - The database connection type.
  - RunDB
```
public RunDB(int dbSystem,
             int connType)
```
    The constructor retrieves database RDBMS type and database connection type.
    
    Parameters:
    
    dbSystem - The database RDBMS type.
    
    connType - The database connection type.
- Method Detail
  - initRunDB
```
public void initRunDB()
```
    For initializing default values. By default, messages is locale messages.
  - setMessageBean
```
public void setMessageBean(boolean isLocale)
```
    For initializing default messages.
    
    Parameters:
    
    isLocale - If true is locale messages else English messages.
  - setDB
```
public void setDB(int dbSystem,
                  java.lang.String connString)
```
    This method set DB connection info for DRIVERMANAGER type.
    
    Parameters:
    
    dbSystem - is Database management system specifier.
    
    connString - is The database connection object string.
  - setDB
```
public void setDB(java.lang.String jndiName)
```
    This method set DB connection info for DATASOURCE type.
    
    Parameters:
    
    jndiName - is The database jndi name.
  - setDB
```
public void setDB(int dbSystem,
                  java.lang.String url,
                  java.lang.String user,
                  java.lang.String password)
```
    This method set DB connection info for DRIVERMANAGER type.
    
    Parameters:
    
    dbSystem - is Database management system specifier.
    
    url - is The database connection url.
    
    user - is The database connection user.
    
    password - is The database connection password.
  - setConnection
```
public boolean setConnection()
```
    Database connection method. if connType is DATASOURCE, Connects to the database by using the jndiName. Else (DRIVERMANAGER), call connectDB method for connecting to the database by using the connString and dbName. An error message (errorString) will occur if False is returning.
    
    Returns:
    
    Returns true if the connection is provided, and false if it is not.
  - connectDB
```
public boolean connectDB()
                  throws java.sql.SQLException
```
    Database connection method. Connects to the database by using the connString or url, user, password parameters of the RunDB class. An error message (errorString) will occur if False is returning.
    
    Returns:
    
    Returns true if the connection is provided and false if it is not.
    
    Throws:
    
    java.sql.SQLException - The error message (errorString) will occur if the SQL error occurs.
  - runQuery
```
public boolean runQuery(java.lang.String[] queryString,
                        int arrayNo,
                        int queryType)
                 throws java.sql.SQLException
```
    Runs the query based on the query type and the order in the query array. An error message (errorString) will occur if False is returning.
    
    Parameters:
    
    queryString - A set of query clauses.
    
    arrayNo - The order of the query to be executed in the array. The sequence number starts at 0.
    
    queryType - Query type.
    
    Returns:
    
    Returns true if the query ran and returns false if it didn't run.
    
    Throws:
    
    java.sql.SQLException - The error message (errorString) will occur if the SQL error occurs.
  - getData
```
public java.lang.Object[][] getData(int dataType,
                                    int rowCount,
                                    int fieldCount)
                             throws java.sql.SQLException
```
    The number of records that have been executed before, the type of data, and retrieves the data according to the number of fields to be drawn from the table (or view). Data as a set of standard data types derived from the base object type will return. Returns the array. An error message (errorString) will occur if there is no data return.
    
    Parameters:
    
    dataType - The type of data you want to retrieve.
    
    rowCount - The specified number of data to retrieve.
    
    fieldCount - Number of fields to withdraw from tables (or views).
    
    Returns:
    
    According to data type and [number of records] data object in [field count] format
    
    Throws:
    
    java.sql.SQLException - The error message (errorString) will occur if the SQL error occurs.
  - getRefData
```
public java.lang.Object[] getRefData(int dataType,
                                     int fieldCount)
                              throws java.sql.SQLException
```
    Retrieves data based on the previously executed reference data query, data type, and the number of fields to be taken from the table (or views). Error message (errorString) will occur if there is no data return.
    
    Parameters:
    
    dataType - The type of data you want to retrieve.
    
    fieldCount - Number of fields to withdraw from tables (or views).
    
    Returns:
    
    Returns the data object array according to the data type and in the [field count] format.
    
    Throws:
    
    java.sql.SQLException - The error message (errorString) will occur if the SQL error occurs.
  - getRowCount
```
public int getRowCount()
                throws java.sql.SQLException
```
    After the query is created to calculate the number of records, the number of records returned from the query result.
    
    Returns:
    
    Returns the number of records in integer type. An error message will be written to errorString if an error occurs.
    
    Throws:
    
    java.sql.SQLException - The error message (errorString) will occur if the SQL error occurs.
  - closeAll
```
public void closeAll()
```
    This method is useful for closing connection, statement, resultSet object instances.
  - getConnection
```
public java.sql.Connection getConnection()
```
    For getting connection.
    
    Returns:
    
    connection
  - setConnection
```
public void setConnection(java.sql.Connection connection)
```
    For setting connection.
    
    Parameters:
    
    connection -
  - getCFN_MYSQL
```
public java.lang.String getCFN_MYSQL()
```
    For getting class for name MYSQL.
    
    Returns:
    
    CFN_MYSQL
  - setCFN_MYSQL
```
public void setCFN_MYSQL(java.lang.String CFN_MYSQL)
```
    For setting class for name MYSQL
    
    Parameters:
    
    CFN_MYSQL -
  - getCFN_SQLSERVER
```
public java.lang.String getCFN_SQLSERVER()
```
    For getting class for name SQLSERVER.
    
    Returns:
    
    CFN_SQLSERVER
  - setCFN_SQLSERVER
```
public void setCFN_SQLSERVER(java.lang.String CFN_SQLSERVER)
```
    For setting class for name SQLSERVER
    
    Parameters:
    
    CFN_SQLSERVER -
  - getCFN_POSTGRESQL
```
public java.lang.String getCFN_POSTGRESQL()
```
    For getting class for name POSTGRESQL.
    
    Returns:
    
    CFN_POSTGRESQL
  - setCFN_POSTGRESQL
```
public void setCFN_POSTGRESQL(java.lang.String CFN_POSTGRESQL)
```
    For setting class for name POSTGRESQL.
    
    Parameters:
    
    CFN_POSTGRESQL -
  - getCFN_ORACLE
```
public java.lang.String getCFN_ORACLE()
```
    For getting class for name ORACLE.
    
    Returns:
    
    CFN_ORACLE
  - setCFN_ORACLE
```
public void setCFN_ORACLE(java.lang.String CFN_ORACLE)
```
    For setting class for name ORACLE.
    
    Parameters:
    
    CFN_ORACLE -
  - getCFN_DB2
```
public java.lang.String getCFN_DB2()
```
    For getting class for name DB2
    
    Returns:
    
    CFN_DB2
  - setCFN_DB2
```
public void setCFN_DB2(java.lang.String CFN_DB2)
```
    For setting class for name DB2.
    
    Parameters:
    
    CFN_DB2 -
  - getCFN_HANA
```
public java.lang.String getCFN_HANA()
```
    For getting class for name HANA
    
    Returns:
    
    CFN_HANA
  - setCFN_HANA
```
public void setCFN_HANA(java.lang.String cFN_HANA)
```
    For setting class for name HANA.
    
    Parameters:
    
    CFN_HANA -
  - getCFN_MARIADB
```
public java.lang.String getCFN_MARIADB()
```
    For getting class for name MARIADB
    
    Returns:
    
    CFN_MARIADB
  - setCFN_MARIADB
```
public void setCFN_MARIADB(java.lang.String cFN_MARIADB)
```
    For setting class for name MARIADB.
    
    Parameters:
    
    CFN_MARIADB -
  - getErrorString
```
public java.lang.String getErrorString()
```
    For getting error string.
    
    Returns:
    
    errorString
  - getConnString
```
public java.lang.String getConnString()
```
    For getting connection string.
    
    Returns:
    
    connString
  - setConnString
```
public void setConnString(java.lang.String connString)
```
    For setting connection string.
    
    Parameters:
    
    connString -
  - getBatchReturn
```
public int[] getBatchReturn()
```
    For getting batch return.
    
    Returns:
    
    v
  - getStringData
```
public java.lang.String[][] getStringData()
```
    For getting string data.
    
    Returns:
    
    stringData
  - getIntegerData
```
public java.lang.Integer[][] getIntegerData()
```
    For getting integer data.
    
    Returns:
    
    integerData
  - getDateData
```
public java.sql.Date[][] getDateData()
```
    For getting date data.
    
    Returns:
    
    dateData
  - getDoubleData
```
public java.lang.Double[][] getDoubleData()
```
    For getting double data.
    
    Returns:
    
    doubleData
  - getMaxRecord
```
public int getMaxRecord()
```
    For getting max record number
    
    Returns:
    
    maxRecord
  - setMaxRecord
```
public void setMaxRecord(int maxRecord)
```
    For setting max record number. Default is 100000.
    
    Parameters:
    
    maxRecord -
  - getResultSet
```
public java.sql.ResultSet getResultSet()
```
    For getting resultSet
    
    Returns:
    
    resultSet
  - getExecCount
```
public int getExecCount()
```
    For getting execCount
    
    Returns:
    
    execCount
  - isExec
```
public boolean isExec()
```
    For getting is exec
    
    Returns:
    
    isExec
  - getMessageScript
```
public java.lang.String getMessageScript()
```
    For getting messageScript
    
    Returns:
    
    messageScript
  - getResultMessage
```
public java.lang.String getResultMessage()
```
    For getting resultMessage
    
    Returns:
    
    resultMessage
  - setDefErrStr
```
public void setDefErrStr(java.lang.String defErrStr)
```
    For setting defErrStr
    
    Parameters:
    
    defErrStr -
  - setDefMsgScr
```
public void setDefMsgScr(java.lang.String defMsgScr)
```
    For setting defMsgScr
    
    Parameters:
    
    defMsgScr -
  - setDefResMsg
```
public void setDefResMsg(java.lang.String defResMsg)
```
    For setting defResMsg
    
    Parameters:
    
    defResMsg -
  - setBatchBegan
```
public void setBatchBegan(int batchBegan)
```
    For setting batch began number
    
    Parameters:
    
    batchBegan -
  - getDbSystem
```
public int getDbSystem()
```
    For getting dbSystem
    
    Returns:
    
    dbSystem
  - setDbSystem
```
public void setDbSystem(int dbSystem)
```
    For setting dbSystem
    
    Parameters:
    
    dbSystem -
  - getConnType
```
public int getConnType()
```
    For getting connType
    
    Returns:
    
    connType
  - setConnType
```
public void setConnType(int connType)
```
    For setting connType
    
    Parameters:
    
    connType -
  - isUpdate
```
public boolean isUpdate()
```
    For getting isUpdate
    
    Returns:
    
    isUpdate
  - setUpdate
```
public void setUpdate(boolean isUpdate)
```
    For setting isUpdate
    
    Parameters:
    
    isUpdate -
  - isLocale
```
public boolean isLocale()
```
    For getting isLocale
    
    Returns:
    
    isLocale
  - setLocale
```
public void setLocale(boolean isLocale)
```
    For setting isLocale
    
    Parameters:
    
    isLocale -

Class RunDB

Field Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

MYSQL

SQLSERVER

ORACLE

POSTGRESQL

DB2

HANA

MARIADB

EXECUTE

QUERY

UPDATE

BATCH

DATASOURCE

DRIVERMANAGER

STRING

INTEGER

DATE

NUMBER

CFN_MYSQL

CFN_SQLSERVER

CFN_POSTGRESQL

CFN_ORACLE

CFN_DB2

CFN_HANA

CFN_MARIADB

connString

url

user

password

dbSystem

defErrStr

defMsgScr

defResMsg

errorString

messageScript

resultMessage

connection

statement

resultSet

dataSource

jndiName

recordNumber

connType

execCount

maxRecord

batchBegan

Constructor Detail

RunDB

RunDB

RunDB

Method Detail

initRunDB

setMessageBean

setDB

setDB

setDB

setConnection

connectDB

runQuery

getData

getRefData

getRowCount

closeAll

getConnection

setConnection

getCFN_MYSQL

setCFN_MYSQL

getCFN_SQLSERVER

setCFN_SQLSERVER

getCFN_POSTGRESQL

setCFN_POSTGRESQL

getCFN_ORACLE

setCFN_ORACLE

getCFN_DB2

setCFN_DB2