| java.lang.Object
 net.sourceforge.orbroker.BrokerConnection
net.sourceforge.orbroker.QueryableConnection
All known Subclasses: net.sourceforge.orbroker.ExecutableConnection, net.sourceforge.orbroker.Query,
| Method Summary | |
| final public void | closeIterator(Iterator iterator)
Close iterator. | | final protected QueryResult | executeQuery(Statement stm, boolean useScrollable)
| | public Iterator | iterate(String statementID, int fetchSize)
Return a live iterator. | | final public List | selectMany(String statementID)
Return a list of 0..n objects. | | final public int | selectMany(String statementID, Collection resultCollection)
Fill Collection with 0..n objects. | | final public int | selectMany(String statementID, Collection resultCollection, int startRow, int rowCount)
Fill Collection with 0..n objects. | | final public List | selectMany(String statementID, int startRow, int rowCount)
Return a list of 0..n objects. | | final public Object | selectOne(String statementID)
Return a single result object. | | final public boolean | selectOne(String statementID, Object resultObject)
Use supplied result object to apply values to. | | public Object | selectOneFromMany(String statementID, int fromRow)
Return one result object from a query containing many.
Returns null if query is empty or returnRow is out of range.
Parameters:
statementID - Statement id
Parameters:
fromRow - Row to return. |
| iterate | | public Iterator iterate(String statementID, int fetchSize)(Code) | | Return a live iterator. Very useful for large rows
that, for memory concerns, need to be built a few at a time,
controlled by the fetch size. The Iterator must be iterated
with the source object active, i.e. a
Query or
Transaction must be open.
Parameters:
statementID - Statement id
Parameters:
fetchSize - Row buffer size Streamed Iterator of result objects. |
| selectMany | | final public List selectMany(String statementID) throws BrokerException(Code) | | Return a list of 0..n objects. An empty
List will be returned if
result set is empty.
Parameters:
statementID - Statement id List of result objects
throws:
BrokerException - |
| selectMany | | final public int selectMany(String statementID, Collection resultCollection) throws BrokerException(Code) | | Fill Collection with 0..n objects. The supplied Collection does not have
to be empty. Objects are added to Collection.
Parameters:
statementID - Statement id
Parameters:
resultCollection - The collection where the result will be added. Number of objects added to collection.
throws:
BrokerException - |
| selectMany | | final public int selectMany(String statementID, Collection resultCollection, int startRow, int rowCount) throws BrokerException(Code) | | Fill Collection with 0..n objects. The supplied Collection does not have
to be empty. Objects are added to Collection.
Parameters:
statementID - Statement id
Parameters:
resultCollection - The collection where the result will be added.
Parameters:
startRow - The start row to return. First row is 1.
Parameters:
rowCount - The number of rows to return Number of objects added to collection.
throws:
BrokerException - |
| selectMany | | final public List selectMany(String statementID, int startRow, int rowCount) throws BrokerException(Code) | | Return a list of 0..n objects. An empty
List will be returned if
result set is empty or if startRow is greater than
the result set size.
Parameters:
statementID - Statement id
Parameters:
startRow - The start row to return. First row is 1.
Parameters:
rowCount - The number of rows to return List of result objects
throws:
BrokerException - |
| selectOneFromMany | | public Object selectOneFromMany(String statementID, int fromRow) throws BrokerException(Code) | | Return one result object from a query containing many.
Returns null if query is empty or returnRow is out of range.
Parameters:
statementID - Statement id
Parameters:
fromRow - Row to return. First row is 1. result object from row
throws:
BrokerException - |
|
|