📄 oracle.jdbc.driver.oraclestatement.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"><!--NewPage--><html><head><!-- Generated by javadoc on Thu Dec 02 03:30:11 PST 1999 --><title> Class oracle.jdbc.driver.OracleStatement</title></head><body><a name="_top_"></a><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><hr><h1> Class oracle.jdbc.driver.OracleStatement</h1><pre>java.lang.Object | +----oracle.jdbc.driver.OracleStatement</pre><hr><dl> <dt> public class <b>OracleStatement</b> <dt> extends Object <dt> implements Statement</dl>Oracle statement class.<p><hr><a name="index"></a><h2> <img src="images/variable-index.gif" width=207 height=38 alt="Variable Index"></h2><dl> <dt> <img src="images/magenta-ball-small.gif" width=6 height=6 alt=" o "> <a href="#auto_rollback"><b>auto_rollback</b></a> <dd> <dt> <img src="images/magenta-ball-small.gif" width=6 height=6 alt=" o "> <a href="#closed"><b>closed</b></a> <dd> <dt> <img src="images/magenta-ball-small.gif" width=6 height=6 alt=" o "> <a href="#dbstmt"><b>dbstmt</b></a> <dd> <dt> <img src="images/magenta-ball-small.gif" width=6 height=6 alt=" o "> <a href="#defines"><b>defines</b></a> <dd> <dt> <img src="images/magenta-ball-small.gif" width=6 height=6 alt=" o "> <a href="#wait_option"><b>wait_option</b></a> <dd> </dl><h2> <img src="images/method-index.gif" width=207 height=38 alt="Method Index"></h2><dl> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#addBatch(java.lang.String)"><b>addBatch</b></a>(String) <dd> Add a SQL command to the current batch. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#cancel()"><b>cancel</b></a>() <dd> Cancel the current statement <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#clearBatch()"><b>clearBatch</b></a>() <dd> Make the set of commands in the current batch empty. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#clearDefines()"><b>clearDefines</b></a>() <dd> Allows the user to clear previously defined types forthe define-columns of a select statement.<p>This is useful if the user wishes to re-use a statementfor a different query. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#clearWarnings()"><b>clearWarnings</b></a>() <dd> We do not have any statement-level warnings. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#close()"><b>close</b></a>() <dd> Close the current result set, if any, and then close the statement. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#defineColumnType(int, int)"><b>defineColumnType</b></a>(int, int) <dd> Define the type under which you will fetch data from the column. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#defineColumnType(int, int, int)"><b>defineColumnType</b></a>(int, int, int) <dd> Define the type under which you will fetch data from the columnand the maximum size of data you want. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#defineColumnType(int, int, java.lang.String)"><b>defineColumnType</b></a>(int, int, String) <dd> Define the type under which you will fetch data from the column. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#execute(java.lang.String)"><b>execute</b></a>(String) <dd> Execute a SQL statement. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#executeBatch()"><b>executeBatch</b></a>() <dd> Submit a batch of commands to the database for execution. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#executeQuery(java.lang.String)"><b>executeQuery</b></a>(String) <dd> Execute a query statement. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#executeUpdate(java.lang.String)"><b>executeUpdate</b></a>(String) <dd> Execute an update statement. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getAutoRollback()"><b>getAutoRollback</b></a>() <dd> <b>Deprecated.</b> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getConnection()"><b>getConnection</b></a>() <dd> JDBC 2.0Returns the <code>Connection</code> objectthat produced this <code>Statement</code> object. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getFetchDirection()"><b>getFetchDirection</b></a>() <dd> JDBC 2.0Retrieves the direction for fetching rows fromdatabase tables that is the default for result setsgenerated from this <code>Statement</code> object. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getFetchSize()"><b>getFetchSize</b></a>() <dd> JDBC 2.0Retrieves the number of result set rows that is the default fetch size for result sets generated from this <code>Statement</code> object. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getMaxFieldSize()"><b>getMaxFieldSize</b></a>() <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getMaxRows()"><b>getMaxRows</b></a>() <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getMoreResults()"><b>getMoreResults</b></a>() <dd> We only have one result and there no way to indicate it. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getOriginalSql()"><b>getOriginalSql</b></a>() <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getQueryTimeout()"><b>getQueryTimeout</b></a>() <dd> The queryTimeout limit is the number of seconds the driver willwait for a Statement to execute. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getResultSet()"><b>getResultSet</b></a>() <dd> Allocate a result set. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getResultSetConcurrency()"><b>getResultSetConcurrency</b></a>() <dd> JDBC 2.0Retrieves the result set concurrency. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getResultSetType()"><b>getResultSetType</b></a>() <dd> JDBC 2.0Determine the result set type. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getRevisedSql()"><b>getRevisedSql</b></a>() <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getRowPrefetch()"><b>getRowPrefetch</b></a>() <dd> Allows the user to retrieve the prefetch value for all resultssets created from this statement. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getUpdateCount()"><b>getUpdateCount</b></a>() <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getWaitOption()"><b>getWaitOption</b></a>() <dd> <b>Deprecated.</b> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getWarnings()"><b>getWarnings</b></a>() <dd> We do not have any statement-level warnings <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#sendBatch()"><b>sendBatch</b></a>() <dd> Void entrypoint so that we do not have to cast statements toOraclePreparedStatements when sending the batch <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#setAutoRollback(int)"><b>setAutoRollback</b></a>(int) <dd> <b>Deprecated.</b> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#setCursorName(java.lang.String)"><b>setCursorName</b></a>(String) <dd> We do not support that <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#setEscapeProcessing(boolean)"><b>setEscapeProcessing</b></a>(boolean) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#setFetchDirection(int)"><b>setFetchDirection</b></a>(int) <dd> JDBC 2.0Gives the driver a hint as to the direction in whichthe rows in a result set will be processed. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#setFetchSize(int)"><b>setFetchSize</b></a>(int) <dd> JDBC 2.0Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#setMaxFieldSize(int)"><b>setMaxFieldSize</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#setMaxRows(int)"><b>setMaxRows</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#setQueryTimeout(int)"><b>setQueryTimeout</b></a>(int) <dd> The queryTimeout limit is the number of seconds the driver willwait for a Statement to execute. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#setResultSetCache(oracle.jdbc.driver.OracleResultSetCache)"><b>setResultSetCache</b></a>(OracleResultSetCache) <dd> Oracle ExtenstionOverride the default result set cache. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#setRowPrefetch(int)"><b>setRowPrefetch</b></a>(int) <dd> setRowPrefetch allows the user to set the row prefetch valuefor all result sets created from this statement.<p>setRowPrefetch overrides the prefetch value set from theconnection, for this particular statement.<p>The row_prefetch will be turned back to 1 automaticallyby the driver if any of the select-column types isstreaming (long data or long raw data). <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#setWaitOption(int)"><b>setWaitOption</b></a>(int) <dd> <b>Deprecated.</b></dl><a name="variables"></a><h2> <img src="images/variables.gif" width=153 height=38 alt="Variables"></h2><a name="defines"><img src="images/magenta-ball.gif" width=12 height=12 alt=" o "></a><b>defines</b><pre> public DBDataSet defines</pre><a name="dbstmt"><img src="images/magenta-ball.gif" width=12 height=12 alt=" o "></a><b>dbstmt</b><pre> public DBStatement dbstmt</pre><a name="closed"><img src="images/magenta-ball.gif" width=12 height=12 alt=" o "></a><b>closed</b><pre> public boolean closed</pre><a name="auto_rollback"><img src="images/magenta-ball.gif" width=12 height=12 alt=" o "></a><b>auto_rollback</b><pre> public int auto_rollback</pre><a name="wait_option"><img src="images/magenta-ball.gif" width=12 height=12 alt=" o "></a><b>wait_option</b><pre> public int wait_option</pre><a name="methods"></a><h2> <img src="images/methods.gif" width=151 height=38 alt="Methods"></h2><a name="executeQuery(java.lang.String)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="executeQuery"><b>executeQuery</b></a><pre> public synchronized ResultSet executeQuery(String sql) throws SQLException</pre><dl> <dd> Execute a query statement.<p> <dd><dl> <dt> <b>Parameters:</b> <dd> sqlSQL - statement to be executed. The query is transformedinto native SQL. <dt> <b>Returns:</b> <dd> the query result set. <dt> <b>Throws:</b> SQLException <dd> if error(s) occurred. </dl></dd></dl><a name="close()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="close"><b>close</b></a><pre> public synchronized void close() throws SQLException</pre><dl> <dd> Close the current result set, if any, and then close the statement.<p> <dd><dl> <dt> <b>Throws:</b> SQLException <dd> if error(s) occurred. </dl></dd></dl><a name="executeUpdate(java.lang.String)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="executeUpdate"><b>executeUpdate</b></a><pre> public synchronized int executeUpdate(String sql) throws SQLException</pre><dl>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -