com.solidstategroup.data
Class DataAccess

java.lang.Object
  com.solidstategroup.data.DataAccess

Direct Known Subclasses:

FilteredDataAccess, TransformDataAccess

public abstract class DataAccess
extends java.lang.Object

User: Phil Date: 31-Mar-2005 Time: 13:18:25

Field Summary

protected java.sql.Connection	connection
static java.lang.String	DATA_NO
static java.lang.String	DATA_YES
static int	NULL_VALUE
protected static int	ORDER_BY_COUNT
protected static java.lang.String	SQL_COUNT
protected static java.lang.String	SQL_LIMIT

Constructor Summary

protected

DataAccess(java.sql.Connection connection)

Method Summary

protected static void	createEqualClause(java.lang.Object value, java.lang.String colname, java.lang.StringBuffer stmt, java.util.Collection whereParams)
protected static void	createGreaterClause(java.lang.Object value, java.lang.String colname, java.lang.StringBuffer stmt, java.util.Collection whereParams)
protected static void	createGreaterEqualClause(java.lang.Object value, java.lang.String colname, java.lang.StringBuffer stmt, java.util.Collection whereParams)
protected static void	createInClause(java.lang.Object[] values, java.lang.String colname, java.lang.StringBuffer stmt, java.util.Collection whereParams) creates a where COLNAME in (?,?,?,?) clause
protected static java.lang.Integer	createInt(int value)
protected static void	createLessClause(java.lang.Object value, java.lang.String colname, java.lang.StringBuffer stmt, java.util.Collection whereParams)
protected static void	createLessEqualClause(java.lang.Object value, java.lang.String colname, java.lang.StringBuffer stmt, java.util.Collection whereParams)
protected static void	createLikeClause(java.lang.Object value, java.lang.String colname, java.lang.StringBuffer stmt, java.util.Collection whereParams)
protected abstract java.lang.Object	extractData(java.sql.ResultSet rs)
protected java.lang.Object	findByPrimaryKey(int pk, java.lang.String sql)
java.sql.Connection	getConnection()
protected int	getCount(java.util.Collection whereParams, java.lang.String sql) returns a intger count of the number of results found by the SQL statement
protected java.util.Date	getDate(java.sql.ResultSet rs, java.lang.String column)
protected static int	getInt(java.sql.ResultSet rs, java.lang.String colname) returns a -1 or a real number
protected java.sql.ResultSet	getResultSet(java.util.Collection whereParams, java.lang.String sql)
protected java.util.Collection	getRows(java.util.Collection whereParams, java.lang.String sql) returns a Collection of Objects found by the SQL statement
protected void	insertSql(java.util.Collection params, java.lang.String sql)
void	setConnection(java.sql.Connection connection)
protected void	setDate(java.sql.PreparedStatement prepStmt, java.util.Date date, int index)
protected void	setInt(java.sql.PreparedStatement prepStmt, int value, int index)
protected void	updateSql(java.util.Collection params, java.lang.String sql)

Methods inherited from class java.lang.Object

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

Field Detail

NULL_VALUE

public static final int NULL_VALUE

See Also:

Constant Field Values

SQL_COUNT

protected static final java.lang.String SQL_COUNT

See Also:

Constant Field Values

SQL_LIMIT

protected static final java.lang.String SQL_LIMIT

See Also:

Constant Field Values

ORDER_BY_COUNT

protected static final int ORDER_BY_COUNT

See Also:

Constant Field Values

DATA_YES

public static final java.lang.String DATA_YES

See Also:

Constant Field Values

DATA_NO

public static final java.lang.String DATA_NO

See Also:

Constant Field Values

connection

protected java.sql.Connection connection

Constructor Detail

DataAccess

protected DataAccess(java.sql.Connection connection)

Method Detail

getConnection

public java.sql.Connection getConnection()

setConnection

public void setConnection(java.sql.Connection connection)

getCount

protected int getCount(java.util.Collection whereParams,
                       java.lang.String sql)

returns a intger count of the number of results found by the SQL statement

Parameters:

sql -

Returns:

getRows

protected java.util.Collection getRows(java.util.Collection whereParams,
                                       java.lang.String sql)

returns a Collection of Objects found by the SQL statement

findByPrimaryKey

protected java.lang.Object findByPrimaryKey(int pk,
                                            java.lang.String sql)
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultSet

protected java.sql.ResultSet getResultSet(java.util.Collection whereParams,
                                          java.lang.String sql)
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

insertSql

protected void insertSql(java.util.Collection params,
                         java.lang.String sql)

updateSql

protected void updateSql(java.util.Collection params,
                         java.lang.String sql)

getDate

protected java.util.Date getDate(java.sql.ResultSet rs,
                                 java.lang.String column)
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

setDate

protected void setDate(java.sql.PreparedStatement prepStmt,
                       java.util.Date date,
                       int index)
                throws java.sql.SQLException

Throws:

java.sql.SQLException

setInt

protected void setInt(java.sql.PreparedStatement prepStmt,
                      int value,
                      int index)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

createInClause

protected static void createInClause(java.lang.Object[] values,
                                     java.lang.String colname,
                                     java.lang.StringBuffer stmt,
                                     java.util.Collection whereParams)

creates a where COLNAME in (?,?,?,?) clause

Parameters:

values -

colname -

stmt -

whereParams -

getInt

protected static int getInt(java.sql.ResultSet rs,
                            java.lang.String colname)
                     throws java.sql.SQLException

returns a -1 or a real number

Parameters:

rs -

colname -

Returns:

Throws:

java.sql.SQLException

createLikeClause

protected static void createLikeClause(java.lang.Object value,
                                       java.lang.String colname,
                                       java.lang.StringBuffer stmt,
                                       java.util.Collection whereParams)

createEqualClause

protected static void createEqualClause(java.lang.Object value,
                                        java.lang.String colname,
                                        java.lang.StringBuffer stmt,
                                        java.util.Collection whereParams)

createLessEqualClause

protected static void createLessEqualClause(java.lang.Object value,
                                            java.lang.String colname,
                                            java.lang.StringBuffer stmt,
                                            java.util.Collection whereParams)

createLessClause

protected static void createLessClause(java.lang.Object value,
                                       java.lang.String colname,
                                       java.lang.StringBuffer stmt,
                                       java.util.Collection whereParams)

createGreaterClause

protected static void createGreaterClause(java.lang.Object value,
                                          java.lang.String colname,
                                          java.lang.StringBuffer stmt,
                                          java.util.Collection whereParams)

createGreaterEqualClause

protected static void createGreaterEqualClause(java.lang.Object value,
                                               java.lang.String colname,
                                               java.lang.StringBuffer stmt,
                                               java.util.Collection whereParams)

createInt

protected static java.lang.Integer createInt(int value)

extractData

protected abstract java.lang.Object extractData(java.sql.ResultSet rs)
                                         throws java.sql.SQLException

Throws:

java.sql.SQLException