com.dpslink.base.jdbc

Class JDBCGenericObjectController

java.lang.Object

com.dpslink.base.obj.MappedAttributesObject

com.dpslink.base.jdbc.JDBCObjectController<JDBCGenericObject>

com.dpslink.base.jdbc.JDBCGenericObjectController

All Implemented Interfaces:

java.io.Serializable

Direct Known Subclasses:

CopyDatabase.CopyObjectController

public class JDBCGenericObjectController
extends JDBCObjectController<JDBCGenericObject>

A generic implementation of the JDBCObjectController abstract class. This is the controller for the JDBCGenericObject class. Provides methods for retrieving and persisting generic table records in the database.

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field and Description
private static long	serialVersionUID The class' serialization version id.

Fields inherited from class com.dpslink.base.jdbc.JDBCObjectController

ivDBObjCls, ivFieldCount, ivFieldKeyAlt, ivFieldKeyPri, ivFieldResPfx, ivSyncLast, ivSyncType, ivTableName

Fields inherited from class com.dpslink.base.obj.MappedAttributesObject

ivHashCode, ivHashFlds, ivObjAttrs

Constructor Summary

Constructors

Constructor and Description
JDBCGenericObjectController(JDBCConnectionInfo cninf, java.lang.String tblname) The constructor for the controller.

Method Summary

Modifier and Type	Method and Description
boolean	add(java.sql.ResultSet rs) Adds all records in the given result set to the table associated with this controller.
java.lang.String[]	getFieldNames() Returns an array of field names for the table associated with the controller.
protected java.lang.String[]	getFieldNamesForKey() Returns an array of primary key field names for the table associated with the controller.
protected boolean[]	getFieldNulls() Returns an array of field nullable flags for the table associated with the controller.
protected int[]	getFieldTypes() Returns an array of field types (java.sql.Types) for the table associated with the controller.
protected java.lang.String	getStatementKey(java.lang.String stmtsfx) Returns the full SQL statement resource key for a given statement resource key suffix.

Methods inherited from class com.dpslink.base.jdbc.JDBCObjectController

add, add, add, arrayToMap, arrayToMap, countAll, delete, delete, deleteAll, dispose, equals, getAll, getConnection, getConnectionInfo, getController, getFieldNamesForUpdate, getFieldNullsForKey, getFieldNullsForUpdate, getFieldsForOrderBy, getFieldsForWhere, getFieldSize, getFieldTypesForKey, getFieldTypesForUpdate, getStatementForDelete, getStatementForGet, getStatementForGetAll, getStatementForInsert, getStatementForUpdate, getStatementString, getTableName, hasFieldNamesForKey, hasFieldNamesForUpdate, isDuplicate, resultSetToArray, resultSetToMap, resultSetToMap, resultSetToObject, setConnectionInfo, setPSDeleteValues, setPSExistsValues, setPSInsertValues, setPSUpdateValues, setPSValue, update, update, valuesToObject

Methods inherited from class com.dpslink.base.obj.MappedAttributesObject

cloneMapAttributes, formatValue, formatValue, getHashFields, getMapArrayList, getMapAttributes, getMapBigDecimal, getMapBoolean, getMapDate, getMapDouble, getMapInteger, getMapLong, getMapMapped, getMapObject, getMapShort, getMapString, getMapString, getMapStringBuffer, getMapStringBuilder, getMapTime, getMapTimestamp, getMapVector, hashCode, setHashFields, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMap, setMapAttributes, setMapObject, setMapTime, setMapTimestamp, toStringArray

Methods inherited from class java.lang.Object

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

Field Detail

serialVersionUID

private static final long serialVersionUID

The class' serialization version id.

See Also:

Constant Field Values

Constructor Detail

JDBCGenericObjectController

public JDBCGenericObjectController(JDBCConnectionInfo cninf,
                                   java.lang.String tblname)

The constructor for the controller.

Parameters:

cninf - (JDBCConnectionInfo) The JDBC connection to use.

Method Detail

getFieldNames

public java.lang.String[] getFieldNames()

Returns an array of field names for the table associated with the controller. Overrides getFieldNames in DBObjectController.

Overrides:

getFieldNames in class JDBCObjectController<JDBCGenericObject>

Returns:

String[] - The field names for the associated table.

getFieldNamesForKey

protected java.lang.String[] getFieldNamesForKey()

Returns an array of primary key field names for the table associated with the controller. Overrides getFieldNamesForKey in DBObjectController.

Overrides:

getFieldNamesForKey in class JDBCObjectController<JDBCGenericObject>

Returns:

String[] - The primary key field names for the associated table.

getFieldNulls

protected boolean[] getFieldNulls()

Returns an array of field nullable flags for the table associated with the controller. Overrides getFieldNulls in DBObjectController.

Overrides:

getFieldNulls in class JDBCObjectController<JDBCGenericObject>

Returns:

boolean[] - The field nullable flags for the associated table.

getFieldTypes

protected int[] getFieldTypes()

Returns an array of field types (java.sql.Types) for the table associated with the controller. Overrides getFieldTypes in DBObjectController.

Currently only supports the following SQL data types. All other data types are processed as Types.OTHER values.
• Types.CHAR
• Types.DATE
• Types.DECIMAL
• Types.INTEGER
• Types.SMALLINT
• Types.TIMESTAMP
• Types.VARCHAR

Overrides:

getFieldTypes in class JDBCObjectController<JDBCGenericObject>

Returns:

int[] - The field types for the associated table.

getStatementKey

protected java.lang.String getStatementKey(java.lang.String stmtsfx)

Returns the full SQL statement resource key for a given statement resource key suffix. Overrides getStatementKey in DBObjectController.

Overrides:

getStatementKey in class JDBCObjectController<JDBCGenericObject>

Parameters:

stmtsfx - (String) The resource key suffix for the desired SQL statement. "SQL.@base." is prepended to the suffix to form the actual resource key for the requested SQL statement.

Returns:

String - The full SQL statement resource key for the specified statement key suffix.

add

public boolean add(java.sql.ResultSet rs)

Adds all records in the given result set to the table associated with this controller.

Parameters:

rs - (ResultSet) A result set of the records to add.

Returns:

boolean - true if the records added successfully, otherwise false.