|
|||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--oracle.jsp.dbutil.CursorBean
A general purpose cursor bean. Can represent Statement, Prepared Statement and Callable Statement depending upon the type specified. Can also represent Scrollable cursors.
Field Summary | |
static int |
CALL_STMT
|
static int |
CONCUR_READ_ONLY
|
static int |
CONCUR_UPDATABLE
|
static int |
PLAIN_STMT
|
static int |
PREP_STMT
|
static int |
TYPE_FORWARD_ONLY
|
static int |
TYPE_SCROLL_INSENSITIVE
|
static int |
TYPE_SCROLL_SENSITIVE
|
Constructor Summary | |
CursorBean()
|
Method Summary | |
void |
close()
Close the cursor. |
void |
create()
Create a cursor for Queries |
void |
create(ConnBean cb)
Create a cursor for Queries |
void |
create(ConnBean cb,
int type,
java.lang.String sql)
Create a cursor with the given type and sql string on a given connection. |
void |
create(int type,
java.lang.String sql)
Create a cursor with the given type and sql string on a connection set before. |
boolean |
execute()
Execute the Statement and return the status. |
boolean |
execute(java.lang.String sql)
Execute the Statement with the given sql. |
java.sql.ResultSet |
executeQuery()
Execute the Statement and return the ResultSet. |
java.sql.ResultSet |
executeQuery(java.lang.String sql)
Execute the Statement with the given Sql. |
int |
executeUpdate()
Execute the Statement and return the no of rows affected. |
int |
executeUpdate(java.lang.String sql)
Execute the Statement with the given Sql. |
oracle.jsp.dbutil.ARRAY |
getARRAY(int parameterIndex)
|
java.io.InputStream |
getAsciiStream(int parameterIndex)
|
oracle.jsp.dbutil.BFILE |
getBFILE(int parameterIndex)
|
java.math.BigDecimal |
getBigDecimal(int parameterIndex,
int scale)
|
java.io.InputStream |
getBinaryStream(int parameterIndex)
|
oracle.jsp.dbutil.BLOB |
getBLOB(int parameterIndex)
|
boolean |
getBoolean(int parameterIndex)
|
byte |
getByte(int parameterIndex)
|
byte[] |
getBytes(int parameterIndex)
|
oracle.jsp.dbutil.CHAR |
getCHAR(int parameterIndex)
|
oracle.jsp.dbutil.CLOB |
getCLOB(int parameterIndex)
|
java.sql.ResultSet |
getCursor(int parameterIndex)
|
java.lang.Object |
getCustomDatum(int parameterIndex,
oracle.jsp.dbutil.CustomDatumFactory factory)
|
java.sql.Date |
getDate(int parameterIndex)
|
oracle.jsp.dbutil.DATE |
getDATE(int parameterIndex)
|
double |
getDouble(int parameterIndex)
|
int |
getExecuteBatch()
Get the execute batch size for this cursor bean. |
float |
getFloat(int parameterIndex)
|
int |
getInt(int parameterIndex)
|
java.sql.Connection |
getJDBCConnection()
Get the underlying connection object. |
long |
getLong(int parameterIndex)
|
oracle.jsp.dbutil.NUMBER |
getNUMBER(int parameterIndex)
|
java.lang.Object |
getObject(int parameterIndex)
|
oracle.jsp.dbutil.Datum |
getOracleObject(int parameterIndex)
|
int |
getPreFetch()
Get the Row prefetch size for this cursor bean. |
int |
getQueryTimeout()
The queryTimeout limit is the number of seconds the driver will wait for a Statement to execute. |
oracle.jsp.dbutil.RAW |
getRAW(int parameterIndex)
|
oracle.jsp.dbutil.REF |
getREF(int parameterIndex)
|
java.lang.String |
getResultAsHTMLTable()
Execute the Sql and return the result as a HTM Table. |
java.lang.String |
getResultAsHTMLTable(java.lang.String sql)
Execute the Sql and return the result as a HTM Table. |
java.lang.String |
getResultAsXMLString()
Execute the Sql and return the result as a XML String Sql string is the one that was used at creation time. |
java.lang.String |
getResultAsXMLString(java.lang.String sql)
Execute the Sql and return the result as a XML String |
int |
getResultSetConcurrency()
Return the concurrency level set for this cursor. |
int |
getResultSetType()
Return the result type set for this cursor. |
oracle.jsp.dbutil.ROWID |
getROWID(int parameterIndex)
|
short |
getShort(int parameterIndex)
|
java.lang.String |
getString(int parameterIndex)
|
oracle.jsp.dbutil.STRUCT |
getSTRUCT(int parameterIndex)
|
java.sql.Time |
getTime(int parameterIndex)
|
java.sql.Timestamp |
getTimestamp(int parameterIndex)
|
java.io.InputStream |
getUnicodeStream(int parameterIndex)
|
int |
getUpdateCount()
|
void |
outOfScope(JspScopeEvent ae)
Invoked when a JSP scope that this object is attached to is ending. |
void |
registerOutParameter(int paramIndex,
int sqlType)
|
void |
registerOutParameter(int paramIndex,
int sqlType,
int scale)
|
void |
registerOutParameter(int paramIndex,
int sqlType,
int scale,
int maxLength)
|
void |
registerOutParameter(int paramIndex,
int sqlType,
java.lang.String sqlName)
|
void |
setARRAY(int paramIndex,
oracle.jsp.dbutil.ARRAY arr)
|
void |
setAsciiStream(int paramIndex,
java.io.InputStream istream,
int length)
|
void |
setBfile(int paramIndex,
oracle.jsp.dbutil.BFILE file)
|
void |
setBFILE(int paramIndex,
oracle.jsp.dbutil.BFILE file)
|
void |
setBigDecimal(int paramIndex,
java.math.BigDecimal x)
|
void |
setBinaryStream(int paramIndex,
java.io.InputStream istream,
int length)
|
void |
setBLOB(int paramIndex,
oracle.jsp.dbutil.BLOB lob)
|
void |
setBoolean(int paramIndex,
boolean x)
|
void |
setByte(int paramIndex,
byte x)
|
void |
setBytes(int paramIndex,
byte[] x)
|
void |
setCHAR(int paramIndex,
oracle.jsp.dbutil.CHAR ch)
|
void |
setCLOB(int paramIndex,
oracle.jsp.dbutil.CLOB lob)
|
void |
setConnBean(ConnBean cb)
Set the underlying connection bean. |
void |
setCursor(int paramIndex,
java.sql.ResultSet rs)
|
void |
setCustomDatum(int paramIndex,
oracle.jsp.dbutil.CustomDatum x)
|
void |
setDate(int paramIndex,
java.sql.Date x)
|
void |
setDATE(int paramIndex,
oracle.jsp.dbutil.DATE date)
|
void |
setDouble(int paramIndex,
double x)
|
void |
setExecuteBatch(int bsize)
Set the Execute Batch Size for DMLs. |
void |
setFixedCHAR(int paramIndex,
java.lang.String x)
|
void |
setFloat(int paramIndex,
float x)
|
void |
setInt(int paramIndex,
int x)
|
void |
setLong(int paramIndex,
long x)
|
void |
setNull(int paramIndex,
int sqlType)
|
void |
setNull(int paramIndex,
int sqlType,
java.lang.String sqlName)
|
void |
setNUMBER(int paramIndex,
oracle.jsp.dbutil.NUMBER num)
|
void |
setObject(int paramIndex,
java.lang.Object x)
|
void |
setObject(int paramIndex,
java.lang.Object x,
int targetSqlType)
|
void |
setObject(int paramIndex,
java.lang.Object x,
int targetSqlType,
int scale)
|
void |
setOracleObject(int paramIndex,
oracle.jsp.dbutil.Datum x)
|
void |
setPreFetch(int prefSize)
Set the Row prefetch size for the rows returned for queries. |
void |
setQueryTimeout(int tout)
The queryTimeout limit is the number of seconds the driver will wait for a Statement to execute. |
void |
setRAW(int paramIndex,
oracle.jsp.dbutil.RAW raw)
|
void |
setREF(int paramIndex,
oracle.jsp.dbutil.REF ref)
|
void |
setRefType(int paramIndex,
oracle.jsp.dbutil.REF ref)
|
void |
setResultSetConcurrency(int rscon)
Set the ResultSet Concurrency for the cursor. |
void |
setResultSetType(int rtype)
Set the ResultType for the cursor created. |
void |
setROWID(int paramIndex,
oracle.jsp.dbutil.ROWID x)
|
void |
setShort(int paramIndex,
short x)
|
void |
setString(int paramIndex,
java.lang.String x)
|
void |
setSTRUCT(int paramIndex,
oracle.jsp.dbutil.STRUCT struct)
|
void |
setTime(int paramIndex,
java.sql.Time x)
|
void |
setTimestamp(int paramIndex,
java.sql.Timestamp x)
|
void |
setUnicodeStream(int paramIndex,
java.io.InputStream istream,
int length)
|
Methods inherited from class java.lang.Object |
clone,
equals,
finalize,
getClass,
hashCode,
notify,
notifyAll,
toString,
wait,
wait,
wait |
Field Detail |
public static final int PLAIN_STMT
public static final int PREP_STMT
public static final int CALL_STMT
public static final int TYPE_FORWARD_ONLY
public static final int TYPE_SCROLL_INSENSITIVE
public static final int TYPE_SCROLL_SENSITIVE
public static final int CONCUR_READ_ONLY
public static final int CONCUR_UPDATABLE
Constructor Detail |
public CursorBean()
Method Detail |
public void setConnBean(ConnBean cb)
cb
- underlying connection bean for the cursorpublic void create(ConnBean cb, int type, java.lang.String sql) throws java.sql.SQLException
cb
- underlying connection bean for the cursorstype
- Statement Type. Possible values are
sql
- Sql string to be executedpublic void create(ConnBean cb) throws java.sql.SQLException
cb
- underlying connection bean for the cursorpublic void create() throws java.sql.SQLException
public java.sql.Connection getJDBCConnection()
public void create(int type, java.lang.String sql) throws java.sql.SQLException
stype
- Statement Type. Possible values are
sql
- Sql string to be executedpublic java.sql.ResultSet executeQuery(java.lang.String sql) throws java.sql.SQLException
Sql
- string to be executedpublic java.sql.ResultSet executeQuery() throws java.sql.SQLException
public int executeUpdate(java.lang.String sql) throws java.sql.SQLException
Sql
- string to be executedpublic int executeUpdate() throws java.sql.SQLException
public int getUpdateCount() throws java.sql.SQLException
public boolean execute(java.lang.String sql) throws java.sql.SQLException
public boolean execute() throws java.sql.SQLException
public void close() throws java.sql.SQLException
public void setResultSetType(int rtype)
rtype
- Result Set type. Possible values are
public int getResultSetType()
public void setResultSetConcurrency(int rscon)
rscon.
- ResultSet Concurrency. Possible values are
public int getResultSetConcurrency()
public void setPreFetch(int prefSize)
prefSize
- prefetch sizepublic int getPreFetch()
public void setExecuteBatch(int bsize)
bsize
- Execute Batch Sizepublic int getExecuteBatch()
public void setQueryTimeout(int tout)
tout
- the new query timeout limit in seconds; zero means unlimitpublic int getQueryTimeout()
public void setNull(int paramIndex, int sqlType, java.lang.String sqlName) throws java.sql.SQLException
public void setNull(int paramIndex, int sqlType) throws java.sql.SQLException
public void setBoolean(int paramIndex, boolean x) throws java.sql.SQLException
public void setByte(int paramIndex, byte x) throws java.sql.SQLException
public void setShort(int paramIndex, short x) throws java.sql.SQLException
public void setInt(int paramIndex, int x) throws java.sql.SQLException
public void setLong(int paramIndex, long x) throws java.sql.SQLException
public void setFloat(int paramIndex, float x) throws java.sql.SQLException
public void setDouble(int paramIndex, double x) throws java.sql.SQLException
public void setBigDecimal(int paramIndex, java.math.BigDecimal x) throws java.sql.SQLException
public void setString(int paramIndex, java.lang.String x) throws java.sql.SQLException
public void setFixedCHAR(int paramIndex, java.lang.String x) throws java.sql.SQLException
public void setCursor(int paramIndex, java.sql.ResultSet rs) throws java.sql.SQLException
public void setROWID(int paramIndex, oracle.jsp.dbutil.ROWID x) throws java.sql.SQLException
public void setARRAY(int paramIndex, oracle.jsp.dbutil.ARRAY arr) throws java.sql.SQLException
public void setSTRUCT(int paramIndex, oracle.jsp.dbutil.STRUCT struct) throws java.sql.SQLException
public void setRAW(int paramIndex, oracle.jsp.dbutil.RAW raw) throws java.sql.SQLException
public void setCHAR(int paramIndex, oracle.jsp.dbutil.CHAR ch) throws java.sql.SQLException
public void setDATE(int paramIndex, oracle.jsp.dbutil.DATE date) throws java.sql.SQLException
public void setNUMBER(int paramIndex, oracle.jsp.dbutil.NUMBER num) throws java.sql.SQLException
public void setBLOB(int paramIndex, oracle.jsp.dbutil.BLOB lob) throws java.sql.SQLException
public void setCLOB(int paramIndex, oracle.jsp.dbutil.CLOB lob) throws java.sql.SQLException
public void setBFILE(int paramIndex, oracle.jsp.dbutil.BFILE file) throws java.sql.SQLException
public void setBfile(int paramIndex, oracle.jsp.dbutil.BFILE file) throws java.sql.SQLException
public void setBytes(int paramIndex, byte[] x) throws java.sql.SQLException
public void setDate(int paramIndex, java.sql.Date x) throws java.sql.SQLException
public void setTime(int paramIndex, java.sql.Time x) throws java.sql.SQLException
public void setTimestamp(int paramIndex, java.sql.Timestamp x) throws java.sql.SQLException
public void setUnicodeStream(int paramIndex, java.io.InputStream istream, int length) throws java.sql.SQLException
public void setAsciiStream(int paramIndex, java.io.InputStream istream, int length) throws java.sql.SQLException
public void setBinaryStream(int paramIndex, java.io.InputStream istream, int length) throws java.sql.SQLException
public void setCustomDatum(int paramIndex, oracle.jsp.dbutil.CustomDatum x) throws java.sql.SQLException
public void setObject(int paramIndex, java.lang.Object x, int targetSqlType, int scale) throws java.sql.SQLException
public void setObject(int paramIndex, java.lang.Object x, int targetSqlType) throws java.sql.SQLException
public void setRefType(int paramIndex, oracle.jsp.dbutil.REF ref) throws java.sql.SQLException
public void setREF(int paramIndex, oracle.jsp.dbutil.REF ref) throws java.sql.SQLException
public void setObject(int paramIndex, java.lang.Object x) throws java.sql.SQLException
public void setOracleObject(int paramIndex, oracle.jsp.dbutil.Datum x) throws java.sql.SQLException
public void registerOutParameter(int paramIndex, int sqlType, java.lang.String sqlName) throws java.sql.SQLException
public void registerOutParameter(int paramIndex, int sqlType, int scale) throws java.sql.SQLException
public void registerOutParameter(int paramIndex, int sqlType, int scale, int maxLength) throws java.sql.SQLException
public void registerOutParameter(int paramIndex, int sqlType) throws java.sql.SQLException
public java.lang.String getString(int parameterIndex) throws java.sql.SQLException
public oracle.jsp.dbutil.Datum getOracleObject(int parameterIndex) throws java.sql.SQLException
public oracle.jsp.dbutil.ROWID getROWID(int parameterIndex) throws java.sql.SQLException
public oracle.jsp.dbutil.NUMBER getNUMBER(int parameterIndex) throws java.sql.SQLException
public oracle.jsp.dbutil.DATE getDATE(int parameterIndex) throws java.sql.SQLException
public oracle.jsp.dbutil.REF getREF(int parameterIndex) throws java.sql.SQLException
public oracle.jsp.dbutil.ARRAY getARRAY(int parameterIndex) throws java.sql.SQLException
public oracle.jsp.dbutil.STRUCT getSTRUCT(int parameterIndex) throws java.sql.SQLException
public oracle.jsp.dbutil.CHAR getCHAR(int parameterIndex) throws java.sql.SQLException
public oracle.jsp.dbutil.RAW getRAW(int parameterIndex) throws java.sql.SQLException
public oracle.jsp.dbutil.BLOB getBLOB(int parameterIndex) throws java.sql.SQLException
public oracle.jsp.dbutil.CLOB getCLOB(int parameterIndex) throws java.sql.SQLException
public oracle.jsp.dbutil.BFILE getBFILE(int parameterIndex) throws java.sql.SQLException
public boolean getBoolean(int parameterIndex) throws java.sql.SQLException
public byte getByte(int parameterIndex) throws java.sql.SQLException
public short getShort(int parameterIndex) throws java.sql.SQLException
public int getInt(int parameterIndex) throws java.sql.SQLException
public long getLong(int parameterIndex) throws java.sql.SQLException
public float getFloat(int parameterIndex) throws java.sql.SQLException
public double getDouble(int parameterIndex) throws java.sql.SQLException
public java.math.BigDecimal getBigDecimal(int parameterIndex, int scale) throws java.sql.SQLException
public byte[] getBytes(int parameterIndex) throws java.sql.SQLException
public java.sql.Date getDate(int parameterIndex) throws java.sql.SQLException
public java.sql.Time getTime(int parameterIndex) throws java.sql.SQLException
public java.sql.Timestamp getTimestamp(int parameterIndex) throws java.sql.SQLException
public java.io.InputStream getAsciiStream(int parameterIndex) throws java.sql.SQLException
public java.io.InputStream getUnicodeStream(int parameterIndex) throws java.sql.SQLException
public java.io.InputStream getBinaryStream(int parameterIndex) throws java.sql.SQLException
public java.lang.Object getObject(int parameterIndex) throws java.sql.SQLException
public java.lang.Object getCustomDatum(int parameterIndex, oracle.jsp.dbutil.CustomDatumFactory factory) throws java.sql.SQLException
public java.sql.ResultSet getCursor(int parameterIndex) throws java.sql.SQLException
public java.lang.String getResultAsXMLString() throws java.sql.SQLException
public java.lang.String getResultAsXMLString(java.lang.String sql) throws java.sql.SQLException
sql
- Sql String to be executedpublic java.lang.String getResultAsHTMLTable(java.lang.String sql) throws java.sql.SQLException
sql
- Sql String to be executedpublic java.lang.String getResultAsHTMLTable() throws java.sql.SQLException
public void outOfScope(JspScopeEvent ae)
|
|||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |