oracle.jdbc.driver.oraclestatement.html

Oracle JDBC 的javaDoc

<dd><b> Note: getAutoRollback() is deprecated.</b>
<i>As of JDBC 8.1.6.  No Replacement.
933355: Transaction management, if different from the default 
behavior, should be handled by the user at the application level.</i>
<p>
</dl>
<a name="setWaitOption(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="setWaitOption"><b>setWaitOption</b></a>
<pre>
 public synchronized void setWaitOption(int waitOption) throws SQLException
</pre>
<dl>
<dd><b> Note: setWaitOption() is deprecated.</b>
<i>As of JDBC 8.1.6.  No Replacement.
933355: Time to wait for resources, if different from the default
behavior, should be handled by the user at the application level.
if waitOption is 0, program will wait indefinitely for resource.
if waitOption is 4, program will receive an error message when a
requested resource is not available.</i>
<p>
</dl>
<a name="getWaitOption()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getWaitOption"><b>getWaitOption</b></a>
<pre>
 public synchronized int getWaitOption() throws SQLException
</pre>
<dl>
<dd><b> Note: getWaitOption() is deprecated.</b>
<i>As of JDBC 8.1.6.  No Replacement.
933355: Time to wait for resources, if different from the default
behavior, should be handled by the user at the application level.</i>
<p>
</dl>
<a name="getWarnings()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getWarnings"><b>getWarnings</b></a>
<pre>
 public SQLWarning getWarnings() throws SQLException
</pre>
<dl>
  <dd> We do not have any statement-level warnings
<p>
</dl>
<a name="clearWarnings()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="clearWarnings"><b>clearWarnings</b></a>
<pre>
 public void clearWarnings() throws SQLException
</pre>
<dl>
  <dd> We do not have any statement-level warnings.
<p>
</dl>
<a name="setCursorName(java.lang.String)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="setCursorName"><b>setCursorName</b></a>
<pre>
 public void setCursorName(String name) throws SQLException
</pre>
<dl>
  <dd> We do not support that
<p>
</dl>
<a name="getResultSet()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getResultSet"><b>getResultSet</b></a>
<pre>
 public synchronized ResultSet getResultSet() throws SQLException
</pre>
<dl>
  <dd> Allocate a result set.  I'm not sure if we should clear the warnings
here or not.
<p>
</dl>
<a name="getUpdateCount()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getUpdateCount"><b>getUpdateCount</b></a>
<pre>
 public synchronized int getUpdateCount() throws SQLException
</pre>
<dl>
</dl>
<a name="getMoreResults()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getMoreResults"><b>getMoreResults</b></a>
<pre>
 public boolean getMoreResults() throws SQLException
</pre>
<dl>
  <dd> We only have one result and there no way to indicate it.
<p>
</dl>
<a name="sendBatch()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="sendBatch"><b>sendBatch</b></a>
<pre>
 public int sendBatch() throws SQLException
</pre>
<dl>
  <dd> Void entrypoint so that we do not have to cast statements to
OraclePreparedStatements when sending the batch
<p>
</dl>
<a name="setFetchDirection(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="setFetchDirection"><b>setFetchDirection</b></a>
<pre>
 public synchronized void setFetchDirection(int direction) throws SQLException
</pre>
<dl>
  <dd> JDBC 2.0
Gives the driver a hint as to the direction in which
the rows in a result set will be processed. The hint applies 
only to result sets created using this Statement object.
Oracle JDBC driver only supports FETCH_FORWARD; changing
fetch direction to FETCH_REVERSE or FETCH_UNKNOWN is ignored.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> direction - the initial direction for processing rows
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs
  </dl></dd>
</dl>
<a name="getFetchDirection()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getFetchDirection"><b>getFetchDirection</b></a>
<pre>
 public int getFetchDirection() throws SQLException
</pre>
<dl>
  <dd> JDBC 2.0
Retrieves the direction for fetching rows from
database tables that is the default for result sets
generated from this <code>Statement</code> object.
Since Oracle database only supports forward only cursor. 
This method always return FETCH_FORWARD.
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> the default fetch direction for result sets generated
from this <code>Statement</code> object
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs
  </dl></dd>
</dl>
<a name="setFetchSize(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="setFetchSize"><b>setFetchSize</b></a>
<pre>
 public synchronized void setFetchSize(int rows) throws SQLException
</pre>
<dl>
  <dd> JDBC 2.0
Gives the JDBC driver a hint as to the number of rows that should 
be fetched from the database when more rows are needed.  The number 
of rows specified affects only result sets created using this 
statement. If the value specified is zero, the connection default
row prefetch size is used.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> rows - the number of rows to fetch
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs, or the
condition 0 <= rows <= this.getMaxRows() is not satisfied.
  </dl></dd>
</dl>
<a name="getFetchSize()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getFetchSize"><b>getFetchSize</b></a>
<pre>
 public int getFetchSize() throws SQLException
</pre>
<dl>
  <dd> JDBC 2.0
Retrieves the number of result set rows that is the default 
fetch size for result sets generated from this 
<code>Statement</code> object.
If this <code>Statement</code> object has not set
a fetch size by calling the method <code>setFetchSize</code>,
the return value is the connection default prefetch size.
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> the default fetch size for result sets generated
from this <code>Statement</code> object
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs
  </dl></dd>
</dl>
<a name="getResultSetConcurrency()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getResultSetConcurrency"><b>getResultSetConcurrency</b></a>
<pre>
 public int getResultSetConcurrency() throws SQLException
</pre>
<dl>
  <dd> JDBC 2.0
Retrieves the result set concurrency.
<p>
</dl>
<a name="getResultSetType()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getResultSetType"><b>getResultSetType</b></a>
<pre>
 public int getResultSetType() throws SQLException
</pre>
<dl>
  <dd> JDBC 2.0
Determine the result set type.
<p>
</dl>
<a name="getConnection()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getConnection"><b>getConnection</b></a>
<pre>
 public Connection getConnection() throws SQLException
</pre>
<dl>
  <dd> JDBC 2.0
Returns the <code>Connection</code> object
that produced this <code>Statement</code> object.
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> the connection that produced this statement
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs
  </dl></dd>
</dl>
<a name="setResultSetCache(oracle.jdbc.driver.OracleResultSetCache)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="setResultSetCache"><b>setResultSetCache</b></a>
<pre>
 public synchronized void setResultSetCache(<a href="oracle.jdbc.driver.OracleResultSetCache.html#_top_">OracleResultSetCache</a> cache) throws SQLException
</pre>
<dl>
  <dd> Oracle Extenstion
Override the default result set cache.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> cache - is a OracleResultSetCache instance
  </dl></dd>
</dl>
<a name="addBatch(java.lang.String)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="addBatch"><b>addBatch</b></a>
<pre>
 public synchronized void addBatch(String sql) throws SQLException
</pre>
<dl>
  <dd> Add a SQL command to the current batch.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> sql
typically - this is a static SQL INSERT or UPDATE
statement.
    <dt> <b>Throws:</b> SQLException
    <dd> if an error occurred.
  </dl></dd>
</dl>
<a name="clearBatch()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="clearBatch"><b>clearBatch</b></a>
<pre>
 public synchronized void clearBatch() throws SQLException
</pre>
<dl>
  <dd> Make the set of commands in the current batch empty.
<p>
  <dd><dl>
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurred.
  </dl></dd>
</dl>
<a name="executeBatch()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="executeBatch"><b>executeBatch</b></a>
<pre>
 public synchronized int[] executeBatch() throws SQLException
</pre>
<dl>
  <dd> Submit a batch of commands to the database for execution.
<p>
Commands are executed in the order in which they were added to the
batch.  This method closes the calling Statement object's current
set if one is open.  The statement's internal list of batch
commands is reset to empty once this method returns.
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> an array of update counts containing one element for
each command in the batch.  The array is ordered
according to the order in which commands were inserted
into the batch.
    <dt> <b>Throws:</b> BatchUpdateException
    <dd> if any of the commands in the batch failed to execute
property.  (For example, the batch will fail if it
contained a command that returns a result set.)
executeBatch() will stop when the first command
returns an error.  The update counts for the executed
commands can be obtained by invoking the method
BatchUpdateException.getUpdateCounts().
  </dl></dd>
</dl>
<a name="getRevisedSql()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getRevisedSql"><b>getRevisedSql</b></a>
<pre>
 public String getRevisedSql() throws SQLException
</pre>
<a name="getOriginalSql()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getOriginalSql"><b>getOriginalSql</b></a>
<pre>
 public String getOriginalSql() throws SQLException
</pre>
<hr>
<pre>
<a href="packages.html">All Packages</a>  <a href="tree.html">Class Hierarchy</a>  <a href="Package-oracle.jdbc.driver.html">This Package</a>  <a href="oracle.jdbc.driver.OracleResultSetMetaData.html#_top_">Previous</a>  <a href="oracle.jdbc.driver.OracleTypes.html#_top_">Next</a>  <a href="AllNames.html">Index</a></pre>
</body>
</html>