<html> <head> <title>Interface XResultSetUpdate</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="XResultSetUpdate-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 XResultSetUpdate</td> </tr> <tr> <td/></tr> <tr> <td><dl> <dt><b>Description</b></dt> <dd>provides the possiblity to write changes made on a result set back to database. </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="#insertRow">insertRow</a></td> <td class="imsum_right">inserts the contents of the insert row into the result set and the database. Must be on the insert row when this method is called. </td> </tr> <tr> <td class="imsum_left"><a href="#updateRow">updateRow</a></td> <td class="imsum_right">updates the underlying database with the new contents of the current row. Cannot be called when on the insert row. </td> </tr> <tr> <td class="imsum_left"><a href="#deleteRow">deleteRow</a></td> <td class="imsum_right">deletes the current row from the result set and the underlying database. Cannot be called when on the insert row. </td> </tr> <tr> <td class="imsum_left"><a href="#cancelRowUpdates">cancelRowUpdates</a></td> <td class="imsum_right">cancels the updates made to a row. </td> </tr> <tr> <td class="imsum_left"><a href="#moveToInsertRow">moveToInsertRow</a></td> <td class="imsum_right">moves the cursor to the insert row. The current cursor position is remembered while the cursor is positioned on the insert row. </td> </tr> <tr> <td class="imsum_left"><a href="#moveToCurrentRow">moveToCurrentRow</a></td> <td class="imsum_right">moves the cursor to the remembered cursor position, usually the current row. This method has no effect if the cursor is not on the insert row. </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="insertRow" class="membertitle">insertRow</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">void</td> </tr> <tr> <td valign="top"><b>insertRow</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>inserts the contents of the insert row into the result set and the database. Must be on the insert row when this method is called. </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="updateRow" class="membertitle">updateRow</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">void</td> </tr> <tr> <td valign="top"><b>updateRow</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>updates the underlying database with the new contents of the current row. Cannot be called when on the insert row. </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="deleteRow" class="membertitle">deleteRow</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">void</td> </tr> <tr> <td valign="top"><b>deleteRow</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>deletes the current row from the result set and the underlying database. Cannot be called when on the insert row. </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="cancelRowUpdates" class="membertitle">cancelRowUpdates</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">void</td> </tr> <tr> <td valign="top"><b>cancelRowUpdates</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>cancels the updates made to a row. </dd> <dd><p> This method may be called after calling an <code>updateXXX</code> method(s) and before calling <a href="XResultSetUpdate.html">XResultSetUpdate</a>::<a href="XResultSetUpdate.html#updateRow">updateRow()</a> to rollback the updates made to a row. If no updates have been made or <code>updateRow</code> has already been called, then this method has no effect. </p> </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="moveToInsertRow" class="membertitle">moveToInsertRow</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">void</td> </tr> <tr> <td valign="top"><b>moveToInsertRow</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>moves the cursor to the insert row. The current cursor position is remembered while the cursor is positioned on the insert row. </dd> <dd><p> The insert row is a special row associated with an updatable result set. It is essentially a buffer where a new row may be constructed by calling the <code>updateXXX</code> methods prior to inserting the row into the result set. </p> <p> Only the <code>updateXXX</code> , <code>getXXX</code> , and <a href="XResultSetUpdate.html">XResultSetUpdate</a>::<a href="XResultSetUpdate.html#insertRow">insertRow()</a> methods may be called when the cursor is on the insert row. All of the columns in a result set must be given a value each time this method is called before calling <code>insertRow</code> . The method <code>updateXXX</code> must be called before a <code>getXXX</code> method can be called on a column value. </p> </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="moveToCurrentRow" class="membertitle">moveToCurrentRow</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">void</td> </tr> <tr> <td valign="top"><b>moveToCurrentRow</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>moves the cursor to the remembered cursor position, usually the current row. This method has no effect if the cursor is not on the insert row. </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 © 2009 Sun Microsystems, Inc.</p> </div> <!-- id="adc-idlref" --> </body> </html>