Release 5.0.1
Part No. A95261-01
 Contents |
 Index |
|
Oracle9i Lite Developer's Guide for Java
Release 5.0.1 Part No. A95261-01 |
|
This appendix discusses the new JDBC 2.0 features.
createStatement(int resultSetType, int resultSetConcurrency)
Creates a Statement object that will generate ResultSet objects with the given type and concurrency.
getTypeMap()
Gets the type map object associated with this connection.
prepareCall(String sql, int resultSetType, int resultSetConcurrency)
Creates a CallableStatement object that will generate ResultSet objects with the given type and concurrency.
prepareStatement(String sql, int resultSetType, int resultSetConcurrency)
Creates a PreparedStatement object that will generate ResultSet objects with the given type and concurrency.
setTypeMap(Map map)
Installs the given type map as the type map for this connection.
getConnection()
Returns the Connection object that produced this Statement object.
getFetchDirection()
Retrieves the direction for fetching rows from database tables that is the default for result sets generated from this Statement object. Only FETCH_FORWARD is supported for now.
getFetchSize()
Retrieves the number of result set rows that is the default fetch size for result sets generated from this Statement object. Only fetch size = 1 is supported for now.
getResultSetConcurrency()
Retrieves the result set concurrency. Only CONCUR_READ_ONLY is supported for now.
getResultSetType()
Determine the result set type. Only TYPE_FORWARD_ONLY and TYPE_SCROLL_INSENSITIVE are supported for now.
setFetchDirection(int direction)
Gives the driver a hint as to the direction in which the rows in a result set will be processed.
setFetchSize(int rows)
Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed.
CONCUR_READ_ONLY
The concurrency mode for a ResultSet object that may NOT be updated.
CONCUR_UPDATABLE
The concurrency mode for a ResultSet object that may be updated. Not supported for now.
FETCH_FORWARD
The rows in a result set will be processed in a forward direction; first-to-last.
FETCH_REVERSE
The rows in a result set will be processed in a reverse direction; last-to-first. Not supported for now.
FETCH_UNKNOWN
The order in which rows in a result set will be processed is unknown.
TYPE_FORWARD_ONLY
The type for a ResultSet object whose cursor may move only forward.
TYPE_SCROLL_INSENSITIVE
The type for a ResultSet object that is scrollable but generally not sensitive to changes made by others.
TYPE_SCROLL_SENSITIVE
The type for a ResultSet object that is scrollable and generally sensitive to changes made by others. Not supported for now.
absolute(int row)
Moves the cursor to the given row number in the result set.
afterLast()
Moves the cursor to the end of the result set, just after the last row.
beforeFirst()
Moves the cursor to the front of the result set, just before the first row.
first()
Moves the cursor to the first row in the result set.
getArray(String colName)
Gets an SQL ARRAY value in the current row of this ResultSet object.
getBigDecimal(int columnIndex)
Gets the value of a column in the current row as a java.math.BigDecimal object with full precision.
getBigDecimal(String columnName)
Gets the value of a column in the current row as a java.math.BigDecimal object with full precision.
getConcurrency()
Returns the concurrency mode of this result set.
getDate(int columnIndex, Calendar cal)
Gets the value of a column in the current row as a java.sql.Date object.
getFetchDirection()
Returns the fetch direction for this result set.
getFetchSize()
Returns the fetch size for this result set.
getRow()
Retrieves the current row number.
getStatement()
Returns the Statement that produced this ResultSet object.
getType()
Returns the type of this result set.
isAfterLast()
isBeforeFirst()
isFirst()
isLast()
last()
Moves the cursor to the last row in the result set.
previous()
Moves the cursor to the previous row in the result set.
refreshRow()
Refreshes the current row with its most recent value in the database. Currently does nothing.
relative(int rows)
Moves the cursor a relative number of rows, either positive or negative.
The following three methods always return false because this release does not support deletes, inserts, or updates.
rowDeleted()
Indicates whether a row has been deleted.
rowInserted()
Indicates whether the current row has had an insertion.
rowUpdated()
Indicates whether the current row has been updated.
setFetchDirection(int direction)
Gives a hint as to the direction in which the rows in this result set will be processed.
setFetchSize(int rows)
Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this result set.
getConnection()
Retrieves the connection that produced this metadata object.
supportsResultSetConcurrency(int type, int concurrency)
Supports the concurrency type in combination with the given result set type.
supportsResultSetType(int type)
Supports the given result set type.
The following methods return false, because this release does not support deletes or updates.
deletesAreDetected(int type)
Indicates whether or not a visible row delete can be detected by calling ResultSet.rowDeleted().
insertsAreDetected(int type)
Indicates whether or not a visible row insert can be detected by calling ResultSet.rowInserted().
othersDeletesAreVisible(int type)
Indicates whether deletes made by others are visible.
othersInsertsAreVisible(int type)
Indicates whether inserts made by others are visible.
othersUpdatesAreVisible(int type)
Indicates whether updates made by others are visible.
ownDeletesAreVisible(int type)
Indicates whether a result set's own deletes are visible.
ownInsertsAreVisible(int type)
Indicates whether a result set's own inserts are visible.
ownUpdatesAreVisible(int type)
Indicates whether a result set's own updates are visible.
updatesAreDetected(int type)
Indicates whether or not a visible row update can be detected by calling the method ResultSet.rowUpdated.
SetMetaDatagetMetaData()
Gets the number, types and properties of a ResultSet's columns.
setDate(int parameterIndex, Date x, Calendar cal)
Sets the designated parameter to a java.sql.Date value, using the given Calendar object.
setTime(int parameterIndex, Time x, Calendar cal)
Sets the designated parameter to a java.sql.Time value, using the given Calendar object.
setTimestamp(int parameterIndex, Timestamp x, Calendar cal)
Sets the designated parameter to a java.sql.Timestamp value, using the given Calendar object.
|
 Copyright © 2002 Oracle Corporation All rights reserved |
|