org.brains2b.data.sql

Class SqlDC<T>

java.lang.Object

org.brains2b.data.sql.SqlDC<T>

All Implemented Interfaces:

DataControl<T>

Direct Known Subclasses:

OracleDC

public abstract class SqlDC<T>
extends java.lang.Object
implements DataControl<T>

Abstract class for SqlDataControl objects.

Implements the Object to hold, the Connection and the PreparedStatement to use but propagates all methods of the DataControl interface for concrete implementation

Adds an additional protected abstract method getObject(ResultSet) as a standardized method to create a data Object from a given ResultSet

Author:

dennis@brains2b.nl

See Also:

DataControl

Field Summary

Fields

Modifier and Type	Field and Description
protected java.sql.Connection	m_con
protected T	m_obj
protected java.sql.PreparedStatement	m_prep Deprecated.

Constructor Summary

Constructors

Constructor and Description
SqlDC(java.sql.Connection con, T o) Constructor for OracleDC which sets the Connection to use for this DataControl and the Object on which it should operate.

Method Summary

Modifier and Type	Method and Description
protected java.sql.PreparedStatement	createScrollableStatement(SqlCondition con, java.lang.String sql) create a Prepared ScrollabeStatemen from an SqlCondition and Sql
protected java.sql.PreparedStatement	createStatement(java.lang.String sql) create a PreparedStatement from SQL
protected java.sql.PreparedStatement	createStatement(java.lang.String sql, int options) create a PreparedStatement from SQL, return value
protected abstract T	getObject(java.sql.ResultSet rs) Method getObject returns an instance of the Object this DataControl was intended to service by reading out the resultset and filling the methods of the object with the values of the individual fields

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.brains2b.data.DataControl

delete, insert, retrieve, retrieveList, update

Field Detail

m_obj

protected T m_obj

m_con

protected java.sql.Connection m_con

m_prep

@Deprecated
protected java.sql.PreparedStatement m_prep

Deprecated.

Constructor Detail

SqlDC

public SqlDC(java.sql.Connection con,
             T o)

Constructor for OracleDC which sets the Connection to use for this DataControl and the Object on which it should operate.

Parameters:

con - Connection, the JDBC connection to use

o - Object, the Object for which this DataControl exists.

Method Detail

getObject

protected abstract T getObject(java.sql.ResultSet rs)
                        throws java.sql.SQLException

Method getObject returns an instance of the Object this DataControl was intended to service by reading out the resultset and filling the methods of the object with the values of the individual fields

This function needs to be implemented to match the specific class definition of the return Object.

Parameters:

rs - ResultSet, Actually a specific position in the ResultSet representing a row in the table to be mapped to an instance of the Object

Returns:

Object, an instance of the Object with all it's particular members filled from the ResultSet row given through the parameter.

Throws:

java.sql.SQLException - if a SqlException occures.

createStatement

protected java.sql.PreparedStatement createStatement(java.lang.String sql)
                                              throws java.sql.SQLException

create a PreparedStatement from SQL

Throws:

java.sql.SQLException

createStatement

protected java.sql.PreparedStatement createStatement(java.lang.String sql,
                                                     int options)
                                              throws java.sql.SQLException

create a PreparedStatement from SQL, return value

Throws:

java.sql.SQLException

createScrollableStatement

protected java.sql.PreparedStatement createScrollableStatement(SqlCondition con,
                                                               java.lang.String sql)
                                                        throws java.sql.SQLException

create a Prepared ScrollabeStatemen from an SqlCondition and Sql

Throws:

java.sql.SQLException