oracle.jdbc.driver.oracleresultset.html

Oracle JDBC 的javaDoc

<pre>
 public Datum getOracleObject(String columnName) throws SQLException
</pre>
<dl>
  <dd> Oracle extension.
Get the column value as the appropriate oracle.sql. type. This differs 
from getObject in that getObject returns the appropriate
jdbc.sql. type. The Oracle specific types in oracle.sql more closely
model the underlying Oracle database types
possible loss of information due to conversion and slightly greater 
efficiency.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> columnName - the name of the column
    <dt> <b>Returns:</b>
    <dd> the column value as the appropriate oracle.sql. type; if the
value is SQL NULL, the result is null
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs.
  </dl></dd>
</dl>
<a name="getARRAY(java.lang.String)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getARRAY"><b>getARRAY</b></a>
<pre>
 public <a href="oracle.sql.ARRAY.html#_top_">ARRAY</a> getARRAY(String columnName) throws SQLException
</pre>
<dl>
  <dd> Oracle extension.
Get the column value as a ARRAY. An ARRAY instance maps
to a Nested Table or VARRAY value in database.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> columnName - the name of the column
    <dt> <b>Returns:</b>
    <dd> the column value as an oracle.sql.ARRAY
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs.
  </dl></dd>
</dl>
<a name="getSTRUCT(java.lang.String)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getSTRUCT"><b>getSTRUCT</b></a>
<pre>
 public <a href="oracle.sql.STRUCT.html#_top_">STRUCT</a> getSTRUCT(String columnName) throws SQLException
</pre>
<dl>
  <dd> Oracle extension. 
Get the column value as a STRUCT. A STRUCT instance maps
to a structured data type instance in database.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> columnName - the name of the column
    <dt> <b>Returns:</b>
    <dd> the column value as an oracle.sql.STRUCT
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs.
    <dt> <b>See Also:</b>
    <dd> getCustomDatum
  </dl></dd>
</dl>
<a name="getREF(java.lang.String)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getREF"><b>getREF</b></a>
<pre>
 public <a href="oracle.sql.REF.html#_top_">REF</a> getREF(String columnName) throws SQLException
</pre>
<dl>
  <dd> Oracle extension. 
Get the column value as a REF. A REF instance maps to a 
REF (to a row or concreated object) value in database.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> columnName - the name of the column
    <dt> <b>Returns:</b>
    <dd> the column value as an oracle.sql.REF
    <dt> <b>Throws:</b> SQLException
    <dd> if a database acc
  </dl></dd>
</dl>
<a name="getCHAR(java.lang.String)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getCHAR"><b>getCHAR</b></a>
<pre>
 public <a href="oracle.sql.CHAR.html#_top_">CHAR</a> getCHAR(String columnName) throws SQLException
</pre>
<dl>
  <dd> Oracle extension. 
Get the column as a CHAR value. CHAR values retain the same same 
representation as they have in the database, so there can be no 
loss of information through conversion. While the vast majority 
of characters in the various Oracle NLS character sets are represented 
in the Unicode character set used by Java there are a very small number 
that are not. 
Additionally, JDBC does not have to perform any conversion when getting 
character data as CHAR, so getCHAR is slightly efficient than getString.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> columnName - the name of the column
    <dt> <b>Returns:</b>
    <dd> the column value as an oracle.sql.CHAR
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs.
  </dl></dd>
</dl>
<a name="getRAW(java.lang.String)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getRAW"><b>getRAW</b></a>
<pre>
 public <a href="oracle.sql.RAW.html#_top_">RAW</a> getRAW(String columnName) throws SQLException
</pre>
<dl>
  <dd> Oracle extension.
Get the column value as a RAW. A RAW instance maps to a RAW 
or LONG RAW value in database.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> columnName - the name of the column
    <dt> <b>Returns:</b>
    <dd> the column value as an oracle.sql.RAW
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs.
  </dl></dd>
</dl>
<a name="getBLOB(java.lang.String)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getBLOB"><b>getBLOB</b></a>
<pre>
 public <a href="oracle.sql.BLOB.html#_top_">BLOB</a> getBLOB(String columnName) throws SQLException
</pre>
<dl>
  <dd> Oracle extension. 
Get the column value as a BLOB (unstructured binary data). BLOB
data is accessed and referenced by using a locator which is stored 
in the database table and points to the BLOB data.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> columnName - the name of the column
    <dt> <b>Returns:</b>
    <dd> the column value as an oracle.sql.BLOB
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs.
  </dl></dd>
</dl>
<a name="getCLOB(java.lang.String)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getCLOB"><b>getCLOB</b></a>
<pre>
 public <a href="oracle.sql.CLOB.html#_top_">CLOB</a> getCLOB(String columnName) throws SQLException
</pre>
<dl>
  <dd> Oracle extension.
Get the column value as a CLOB (single-byte character data). CLOB
data is accessed and referenced by using a locator which is stored 
in the database table and points to the CLOB data.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> columnName - the name of the column
    <dt> <b>Returns:</b>
    <dd> the column value as an oracle.sql.CLOB
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs.
  </dl></dd>
</dl>
<a name="getBFILE(java.lang.String)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getBFILE"><b>getBFILE</b></a>
<pre>
 public <a href="oracle.sql.BFILE.html#_top_">BFILE</a> getBFILE(String columnName) throws SQLException
</pre>
<dl>
  <dd> Oracle extension. 
Get the column as a BFILE locator. BFILES are large binary data 
objects stored in operating system files outside of database tablespaces. 
These files use reference semantics. They may also be located on 
tertiary storage devices such as hard disks, CD-ROMs, PhotoCDs and
DVDs. Like BLOBs and CLOBs, a BFILE is accessed and referenced by a 
locator which is stored in the database table and points to the BFILE
data.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> columnName - the name of the column
    <dt> <b>Returns:</b>
    <dd> the column value as an oracle.sql.BFILE
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs.
  </dl></dd>
</dl>
<a name="getBfile(java.lang.String)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getBfile"><b>getBfile</b></a>
<pre>
 public <a href="oracle.sql.BFILE.html#_top_">BFILE</a> getBfile(String columnName) throws SQLException
</pre>
<dl>
  <dd> Oracle extension. 
Get the column as a BFILE locator. BFILES are large binary data 
objects stored in operating system files outside of database tablespaces. 
These files use reference semantics. They may also be located on 
tertiary storage devices such as hard disks, CD-ROMs, PhotoCDs and
DVDs. Like BLOBs and CLOBs, a BFILE is accessed and referenced by a 
locator which is stored in the database table and points to the BFILE
data.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> columnName - the name of the column
    <dt> <b>Returns:</b>
    <dd> the column value as an oracle.sql.BFILE
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs.
  </dl></dd>
</dl>
<a name="getCustomDatum(java.lang.String, oracle.sql.CustomDatumFactory)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getCustomDatum"><b>getCustomDatum</b></a>
<pre>
 public <a href="oracle.sql.CustomDatum.html#_top_">CustomDatum</a> getCustomDatum(String columnName,
                                   <a href="oracle.sql.CustomDatumFactory.html#_top_">CustomDatumFactory</a> factory) throws SQLException
</pre>
<dl>
  <dd> Oracle extension. 
Get the column value as an instance of a subclass of CustomDatum. 
Which subclass is determined by the factory parameter.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> columnName - the name of the column
    <dd> factory - CustomDatumFactory used to materialize the column value
    <dt> <b>Returns:</b>
    <dd> the column value as a CustomDatum; if the value is SQL NULL,
the result is null
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs.
  </dl></dd>
</dl>
<a name="updateOracleObject(int, oracle.jdbc.driver.Datum)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="updateOracleObject"><b>updateOracleObject</b></a>
<pre>
 public abstract void updateOracleObject(int columnIndex,
                                         Datum x) throws SQLException
</pre>
<dl>
  <dd> Oracle extension.
Updates a column with an oracle.sql.xxx value.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> columnIndex - the first column is 1, the second is 2, ...
    <dd> x - the new column value
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs
  </dl></dd>
</dl>
<a name="updateROWID(int, oracle.sql.ROWID)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="updateROWID"><b>updateROWID</b></a>
<pre>
 public abstract void updateROWID(int columnIndex,
                                  <a href="oracle.sql.ROWID.html#_top_">ROWID</a> x) throws SQLException
</pre>
<dl>
  <dd> Oracle extension.
Updates a column with an oracle.sql.ROWID value.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> columnIndex - the first column is 1, the second is 2, ...
    <dd> x - the new column value
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs
  </dl></dd>
</dl>
<a name="updateNUMBER(int, oracle.jdbc.driver.NUMBER)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="updateNUMBER"><b>updateNUMBER</b></a>
<pre>
 public abstract void updateNUMB