<html> <head> <title>Interface XStatement</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <link rel="stylesheet" type="text/css" href="../../../../idl.css"> </head> <body> <div id="adc-idlref"> <a name="_top_"> </a><table class="navimain" border="0" cellpadding="3"> <tr> <td class="navimain"><a href="../module-ix.html" class="navimain">Overview</a></td> <td class="navimain"><a href="module-ix.html" class="navimain">Module</a></td> <td class="navimain"><a href="XStatement-xref.html" class="navimain">Use</a></td> <td class="navimainnone">Devguide</td> <td class="navimain"><a href="../../../../index-files/index-1.html" class="navimain">Index</a></td> </tr> </table> <table class="navisub" border="0" cellpadding="0"> <tr> <td class="navisub"><a href="#MethodsSummary" class="navisub">Methods' Summary</a></td> <td class="navisub">Attributes' Summary</td> <td class="navisub"><a href="#MethodsDetails" class="navisub">Methods' Details</a></td> <td class="navisub">Attributes' Details</td> </tr> </table> <hr> <table border="0" width="100%" cellpadding="5" cellspacing="3" class="title-table" style="margin-bottom:6pt;"> <tr> <td><p class="namechain"><a href="../../../../module-ix.html" class="namechain">::</a> <a href="../../../module-ix.html" class="namechain">com</a> :: <a href="../../module-ix.html" class="namechain">sun</a> :: <a href="../module-ix.html" class="namechain">star</a> :: <a href="module-ix.html" class="namechain">sdbc</a> :: </p> </td> </tr> <tr> <td class="title">interface XStatement</td> </tr> <tr> <td/></tr> <tr> <td><dl> <dt><b>Description</b></dt> <dd>is used for executing a static SQL statement and obtaining the results produced by it. </dd> <dd><p> Only one ResultSet per Statement can be open at any point in time; therefore, if the reading of one ResultSet is interleaved with the reading of another, each must have been generated by different Statements. All statement <code>execute</code> methods implicitly close a statement's current ResultSet if an open one exists. </p> </dd> </dl> </td> </tr> </table> <hr> <a name="MethodsSummary"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Methods' Summary</td> </tr> <tr> <td class="imsum_left"><a href="#executeQuery">executeQuery</a></td> <td class="imsum_right">executes a SQL statement that returns a single ResultSet. </td> </tr> <tr> <td class="imsum_left"><a href="#executeUpdate">executeUpdate</a></td> <td class="imsum_right">executes an SQL INSERT, UPDATE, or DELETE statement. In addition, SQL statements that return nothing, such as SQL DDL statements, can be executed. </td> </tr> <tr> <td class="imsum_left"><a href="#execute">execute</a></td> <td class="imsum_right">executes a SQL statement that may return multiple results. </td> </tr> <tr> <td class="imsum_left"><a href="#getConnection">getConnection</a></td> <td class="imsum_right">returns the <a href="Connection.html">Connection</a> object that produced this <code>Statement</code> object. </td> </tr> </table> <a name="MethodsDetails"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle">Methods' Details</td> </tr> <tr> <td class="imdetail"><a name="executeQuery" class="membertitle">executeQuery</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-method" bgcolor="#ffffff" align="center"> <tr> <td><table class="table-in-method" border="0"> <tr> <td valign="top" colspan="3"><a href="XResultSet.html">XResultSet</a></td> </tr> <tr> <td valign="top"><b>executeQuery</b>(</td> <td valign="top">[in] string</td> <td valign="bottom"> sql )</td> </tr> <tr> <td valign="top" align="right">raises( </td> <td valign="top" colspan="2"><a href="SQLException.html">SQLException</a> );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>executes a SQL statement that returns a single ResultSet. </dd> <dt><b>Parameter sql</b></dt> <dd>the SQL statement which should be executed </dd> <dt><b>Returns</b></dt> <dd>a ResultSet that contains the data produced by the query; never <b>NULL</b> </dd> <dt><b>Throws</b></dt> <dd>SQLException if a database access error occurs. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="executeUpdate" class="membertitle">executeUpdate</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-method" bgcolor="#ffffff" align="center"> <tr> <td><table class="table-in-method" border="0"> <tr> <td valign="top" colspan="3">long</td> </tr> <tr> <td valign="top"><b>executeUpdate</b>(</td> <td valign="top">[in] string</td> <td valign="bottom"> sql )</td> </tr> <tr> <td valign="top" align="right">raises( </td> <td valign="top" colspan="2"><a href="SQLException.html">SQLException</a> );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>executes an SQL INSERT, UPDATE, or DELETE statement. In addition, SQL statements that return nothing, such as SQL DDL statements, can be executed. </dd> <dt><b>Parameter sql</b></dt> <dd>a SQL INSERT, UPDATE or DELETE statement or a SQL statement that returns nothing </dd> <dt><b>Returns</b></dt> <dd>either the row count for INSERT, UPDATE or DELETE or 0 for SQL statements that return nothing </dd> <dt><b>Throws</b></dt> <dd>SQLException if a database access error occurs. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="execute" class="membertitle">execute</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-method" bgcolor="#ffffff" align="center"> <tr> <td><table class="table-in-method" border="0"> <tr> <td valign="top" colspan="3">boolean</td> </tr> <tr> <td valign="top"><b>execute</b>(</td> <td valign="top">[in] string</td> <td valign="bottom"> sql )</td> </tr> <tr> <td valign="top" align="right">raises( </td> <td valign="top" colspan="2"><a href="SQLException.html">SQLException</a> );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>executes a SQL statement that may return multiple results. </dd> <dd><p> Under some (uncommon) situations a single SQL statement may return multiple result sets and/or update counts. Normally you can ignore this unless you are (1) executing a stored procedure that you know may return multiple results or (2) you are dynamically executing an unknown SQL string. The navigation through multiple results is covered by <a href="XMultipleResults.html">XMultipleResults</a>. </p> <p> The <code>execute</code> method executes a SQL statement and indicates the form of the first result. You can then use <a href="XStatement.html">XStatement</a>::<a href="XStatement.html#getResultSet">getResultSet()</a> or <a href="XStatement.html">XStatement</a>::<a href="XStatement.html#getUpdateCount">getUpdateCount()</a> to retrieve the result, and <a href="XStatement.html">XStatement</a>::<a href="XStatement.html#getMoreResults">getMoreResults()</a> to move to any subsequent result(s). </p> </dd> <dt><b>Parameter sql</b></dt> <dd>any SQL statement </dd> <dt><b>Returns</b></dt> <dd><b>true</b> if the next result is a ResultSet; <b>false</b> if it is an update count or there are no more results </dd> <dt><b>Throws</b></dt> <dd>SQLException if a database access error occurs. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="getConnection" class="membertitle">getConnection</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-method" bgcolor="#ffffff" align="center"> <tr> <td><table class="table-in-method" border="0"> <tr> <td valign="top" colspan="3"><a href="XConnection.html">XConnection</a></td> </tr> <tr> <td valign="top"><b>getConnection</b>()</td> </tr> <tr> <td valign="top" align="right">raises( </td> <td valign="top" colspan="2"><a href="SQLException.html">SQLException</a> );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>returns the <a href="Connection.html">Connection</a> object that produced this <code>Statement</code> object. </dd> <dt><b>Returns</b></dt> <dd>the connection that produced this statement </dd> <dt><b>Throws</b></dt> <dd>SQLException if a database access error occurs. </dd> </dl> </td> </tr> </table> </td> </tr> </table> <a href="#_top_">Top of Page</a><hr size="3"><p class="copyright" align="center">Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.</p> </div> <!-- id="adc-idlref" --> </body> </html>