org.apache.ojb.broker.accesslayer
Interface StatementManagerIF

All Known Implementing Classes:
StatementManager

public interface StatementManagerIF

Version:
$Id: StatementManagerIF.java 365232 2005-12-21 22:36:07Z tomdz $

Field Summary
static int FETCH_SIZE_NOT_APPLICABLE
          fetchSize hint marking that setting fetch size for current statement is N/A.
static int FETCH_SIZE_NOT_EXPLICITLY_SET
          fetchSize hint marking that there is no statement-level explicit override.
 
Method Summary
 void bindDelete(java.sql.PreparedStatement stmt, ClassDescriptor cld, java.lang.Object obj)
          binds the objects primary key and locking values to the statement, BRJ
 void bindDelete(java.sql.PreparedStatement stmt, Identity oid, ClassDescriptor cld)
          Binds the Identities Primary key values to the statement.
 void bindInsert(java.sql.PreparedStatement stmt, ClassDescriptor cld, java.lang.Object obj)
          binds the values of the object obj to the statements parameters
 void bindSelect(java.sql.PreparedStatement stmt, Identity oid, ClassDescriptor cld, boolean callableStmt)
          binds the Identities Primary key values to the statement
 int bindStatement(java.sql.PreparedStatement stmt, Query query, ClassDescriptor cld, int param)
          bind a Query based Select Statement
 void bindUpdate(java.sql.PreparedStatement stmt, ClassDescriptor cld, java.lang.Object obj)
          binds the values of the object obj to the statements parameters
 int bindValues(java.sql.PreparedStatement stmt, ValueContainer[] valueContainer, int index)
          binds the given array of values (if not null) starting from the given parameter index
 void closeResources(java.sql.Statement stmt, java.sql.ResultSet rs)
           
 java.sql.PreparedStatement getDeleteStatement(ClassDescriptor cds)
          return a prepared DELETE Statement fitting for the given ClassDescriptor
 java.sql.Statement getGenericStatement(ClassDescriptor cds, boolean scrollable)
          return a generic Statement for the given ClassDescriptor
 java.sql.PreparedStatement getInsertStatement(ClassDescriptor cds)
          return a prepared Insert Statement fitting for the given ClassDescriptor
 java.sql.PreparedStatement getPreparedStatement(ClassDescriptor cds, java.lang.String sql, boolean scrollable, int explicitFetchSizeHint, boolean callableStmt)
          Return a PreparedStatement for selecting against the given ClassDescriptor.
 java.sql.PreparedStatement getSelectByPKStatement(ClassDescriptor cds)
          return a prepared Select Statement for the given ClassDescriptor
 java.sql.PreparedStatement getUpdateStatement(ClassDescriptor cds)
          return a prepared Update Statement fitting to the given ClassDescriptor
 

Field Detail

FETCH_SIZE_NOT_APPLICABLE

static final int FETCH_SIZE_NOT_APPLICABLE
fetchSize hint marking that setting fetch size for current statement is N/A.

See Also:
Constant Field Values

FETCH_SIZE_NOT_EXPLICITLY_SET

static final int FETCH_SIZE_NOT_EXPLICITLY_SET
fetchSize hint marking that there is no statement-level explicit override.

See Also:
Constant Field Values
Method Detail

bindDelete

void bindDelete(java.sql.PreparedStatement stmt,
                Identity oid,
                ClassDescriptor cld)
                throws java.sql.SQLException
Binds the Identities Primary key values to the statement.

Parameters:
stmt -
oid -
cld - ClassDescriptor for the Object, if null will be lookup automatic
Throws:
java.sql.SQLException

bindDelete

void bindDelete(java.sql.PreparedStatement stmt,
                ClassDescriptor cld,
                java.lang.Object obj)
                throws java.sql.SQLException
binds the objects primary key and locking values to the statement, BRJ

Throws:
java.sql.SQLException

bindStatement

int bindStatement(java.sql.PreparedStatement stmt,
                  Query query,
                  ClassDescriptor cld,
                  int param)
                  throws java.sql.SQLException
bind a Query based Select Statement

Throws:
java.sql.SQLException

bindInsert

void bindInsert(java.sql.PreparedStatement stmt,
                ClassDescriptor cld,
                java.lang.Object obj)
                throws java.sql.SQLException
binds the values of the object obj to the statements parameters

Throws:
java.sql.SQLException

bindSelect

void bindSelect(java.sql.PreparedStatement stmt,
                Identity oid,
                ClassDescriptor cld,
                boolean callableStmt)
                throws java.sql.SQLException
binds the Identities Primary key values to the statement

Parameters:
stmt -
oid -
cld - ClassDescriptor for the Object, if null will be lookup automatic
callableStmt - Indicate if the specified PreparedStatement is a CallableStatement supporting stored procedures.
Throws:
java.sql.SQLException

bindUpdate

void bindUpdate(java.sql.PreparedStatement stmt,
                ClassDescriptor cld,
                java.lang.Object obj)
                throws java.sql.SQLException
binds the values of the object obj to the statements parameters

Throws:
java.sql.SQLException

bindValues

int bindValues(java.sql.PreparedStatement stmt,
               ValueContainer[] valueContainer,
               int index)
               throws java.sql.SQLException
binds the given array of values (if not null) starting from the given parameter index

Returns:
the next parameter index
Throws:
java.sql.SQLException

getDeleteStatement

java.sql.PreparedStatement getDeleteStatement(ClassDescriptor cds)
                                              throws PersistenceBrokerSQLException
return a prepared DELETE Statement fitting for the given ClassDescriptor

Throws:
PersistenceBrokerSQLException

getGenericStatement

java.sql.Statement getGenericStatement(ClassDescriptor cds,
                                       boolean scrollable)
                                       throws PersistenceBrokerException
return a generic Statement for the given ClassDescriptor

Throws:
PersistenceBrokerException

getInsertStatement

java.sql.PreparedStatement getInsertStatement(ClassDescriptor cds)
                                              throws PersistenceBrokerSQLException
return a prepared Insert Statement fitting for the given ClassDescriptor

Throws:
PersistenceBrokerSQLException

getPreparedStatement

java.sql.PreparedStatement getPreparedStatement(ClassDescriptor cds,
                                                java.lang.String sql,
                                                boolean scrollable,
                                                int explicitFetchSizeHint,
                                                boolean callableStmt)
                                                throws PersistenceBrokerException
Return a PreparedStatement for selecting against the given ClassDescriptor.

Throws:
PersistenceBrokerException

getSelectByPKStatement

java.sql.PreparedStatement getSelectByPKStatement(ClassDescriptor cds)
                                                  throws PersistenceBrokerSQLException
return a prepared Select Statement for the given ClassDescriptor

Throws:
PersistenceBrokerSQLException

getUpdateStatement

java.sql.PreparedStatement getUpdateStatement(ClassDescriptor cds)
                                              throws PersistenceBrokerSQLException
return a prepared Update Statement fitting to the given ClassDescriptor

Throws:
PersistenceBrokerSQLException

closeResources

void closeResources(java.sql.Statement stmt,
                    java.sql.ResultSet rs)


(C) 2002 - 2006 Apache Software Foundation
All rights reserved. Published under the Apache License 2.0.
http://db.apache.org/ojb
Version: 1.0.4, 2005-12-30