oracle.jdbc.driver.oracleresultset.html

Oracle JDBC 的javaDoc

    <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(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getSTRUCT"><b>getSTRUCT</b></a>
<pre>
 public abstract <a href="oracle.sql.STRUCT.html#_top_">STRUCT</a> getSTRUCT(int columnIndex) 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> columnIndex - the first column is 1, the second is 2, ...
    <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(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getREF"><b>getREF</b></a>
<pre>
 public abstract <a href="oracle.sql.REF.html#_top_">REF</a> getREF(int columnIndex) 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> columnIndex - the first column is 1, the second is 2, ...
    <dt> <b>Returns:</b>
    <dd> the column value as an oracle.sql.REF
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs.
  </dl></dd>
</dl>
<a name="getCHAR(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getCHAR"><b>getCHAR</b></a>
<pre>
 public abstract <a href="oracle.sql.CHAR.html#_top_">CHAR</a> getCHAR(int columnIndex) 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> columnIndex - the first column is 1, the second is 2, ...
    <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(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getRAW"><b>getRAW</b></a>
<pre>
 public abstract <a href="oracle.sql.RAW.html#_top_">RAW</a> getRAW(int columnIndex) 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> columnIndex - the first column is 1, the second is 2, ...
    <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(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getBLOB"><b>getBLOB</b></a>
<pre>
 public abstract <a href="oracle.sql.BLOB.html#_top_">BLOB</a> getBLOB(int columnIndex) 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> columnIndex - the first column is 1, the second is 2, ...
    <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(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getCLOB"><b>getCLOB</b></a>
<pre>
 public abstract <a href="oracle.sql.CLOB.html#_top_">CLOB</a> getCLOB(int columnIndex) 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> columnIndex - the first column is 1, the second is 2, ...
    <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(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getBFILE"><b>getBFILE</b></a>
<pre>
 public abstract <a href="oracle.sql.BFILE.html#_top_">BFILE</a> getBFILE(int columnIndex) 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> columnIndex - the first column is 1, the second is 2, ...
    <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(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getBfile"><b>getBfile</b></a>
<pre>
 public abstract <a href="oracle.sql.BFILE.html#_top_">BFILE</a> getBfile(int columnIndex) 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> columnIndex - the first column is 1, the second is 2, ...
    <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(int, 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 abstract <a href="oracle.sql.CustomDatum.html#_top_">CustomDatum</a> getCustomDatum(int columnIndex,
                                            <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> columnIndex - the first column is 1, the second is 2, ...
    <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="getCURSOR(java.lang.String)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getCURSOR"><b>getCURSOR</b></a>
<pre>
 public ResultSet getCURSOR(String columnName) throws SQLException
</pre>
<dl>
  <dd> Oracle extension.
Get the REFCURSOR value of the column as a ResultSet.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> columnName - the name of the column
    <dt> <b>Returns:</b>
    <dd> the REFCURSOR column value as a ResultSet
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs
  </dl></dd>
</dl>
<a name="getROWID(java.lang.String)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getROWID"><b>getROWID</b></a>
<pre>
 public <a href="oracle.sql.ROWID.html#_top_">ROWID</a> getROWID(String columnName) throws SQLException
</pre>
<dl>
  <dd> Oracle extension.
Get the ROWID column value as ROWID.
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> columnName - the name of the column
    <dt> <b>Returns:</b>
    <dd> the ROWID column value as an oracle.sql.ROWID
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs.
  </dl></dd>
</dl>
<a name="getNUMBER(java.lang.String)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getNUMBER"><b>getNUMBER</b></a>
<pre>
 public NUMBER getNUMBER(String columnName) throws SQLException
</pre>
<dl>
  <dd> Oracle extension. 
Get the column value as a NUMBER. NUMBER values have the same 
representation as Oracle numbers in the database, thus
they have exactly the same value. Getting numeric values as other 
types can result in very slightly different values due to the
difference in representation. Additionally, JDBC does not have to do 
any conversion when using getNUMBER and so is more efficient.
<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.NUMBER
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs.
  </dl></dd>
</dl>
<a name="getDATE(java.lang.String)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getDATE"><b>getDATE</b></a>
<pre>
 public DATE getDATE(String columnName) throws SQLException
</pre>
<dl>
  <dd> Oracle extension. 
Get the column value as a DATE.
<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.DATE
    <dt> <b>Throws:</b> SQLException
    <dd> if a database access error occurs.
  </dl></dd>
</dl>
<a name="getOracleObject(java.lang.String)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getOracleObject"><b>getOracleObject</b></a>