org.brains2b.sql.oracle.cursor

Class OracleCursor

java.lang.Object

org.brains2b.data.cursor.Cursor

org.brains2b.data.sql.cursor.SqlCursor

org.brains2b.sql.oracle.cursor.OracleCursor

Deprecated.

use SqlCursor

public class OracleCursor
extends SqlCursor

Overwrite of the Cursor object to add functionality for having queries with parameters.

The sql statement can contain placeholder characters ? signifying a parameter which can be set at runtime by calling addParameter(index, value). The index corresponds with the count of the placeholder character in the SQL statement starting at 1

Version:

0.22.3 [18-06-2007]

Author:

dennis@brains2b.nl

Field Summary

Fields inherited from class org.brains2b.data.sql.cursor.SqlCursor

m_con, m_last, m_prep, m_select

Fields inherited from class org.brains2b.data.cursor.Cursor

m_prototype

Constructor Summary

Constructors

Constructor and Description
OracleCursor() Deprecated. use OracleCursor(String, String) and OracleCursor(Connection,String,String)
OracleCursor(java.sql.Connection con, java.lang.String name, java.lang.String sql) Deprecated. Constructor for OracleCursor.
OracleCursor(java.lang.String name, java.lang.String sql) Deprecated. Constructor for OracleCursor

Method Summary

Modifier and Type	Method and Description
java.util.Vector	select() Deprecated.

Methods inherited from class org.brains2b.data.sql.cursor.SqlCursor

addParameter, addParameter, addParameter, addParameter, delete, getConnection, getObject, getParameters, getPreparedStatement, getProtoType, getProtoType, getSelect, insert, insert, reset, retrieve, retrieveList, retrieveList, setConnection, setPageable, toString, update

Methods inherited from class org.brains2b.data.cursor.Cursor

getName, getNewCursorData

Methods inherited from class java.lang.Object

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

Constructor Detail

OracleCursor

public OracleCursor()

Deprecated. use OracleCursor(String, String) and OracleCursor(Connection,String,String)

Constructor for OracleCursor.

OracleCursor

public OracleCursor(java.lang.String name,
                    java.lang.String sql)

Deprecated.

Constructor for OracleCursor

Parameters:

name - String, the name of the cursor

sql - String, the SQL-statement to use for this cursor

OracleCursor

public OracleCursor(java.sql.Connection con,
                    java.lang.String name,
                    java.lang.String sql)

Deprecated.

Constructor for OracleCursor.

Usually the Connection does not have to be set at initialization, you can use setConnection(Connection)

Parameters:

con - java.sql.Connection, the JDBC connection to use for this Cursor

name - String, the name of the cursor

sql - String, the SQL-statement to use for this cursor

Method Detail

select

public java.util.Vector select()
                        throws java.lang.Exception

Deprecated.

Throws:

java.lang.Exception