getarray.html

来自「java类库详细讲解」· HTML 代码 · 共 180 行

HTML
180 行
字号 
<HTML>
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<TITLE>Getting a VARRAY Value from an Oracle Table
(Java Developers Almanac Example)
</TITLE>
<META CONTENT="Patrick Chan" NAME="AUTHOR">
<META CONTENT="Code Examples from The Java Developers Almanac 1.4" NAME="DESCRIPTION">
<META CONTENT="Addison-Wesley/Patrick Chan" NAME="OWNER">
<META CONTENT="3/20/02" NAME="revision">
<STYLE TYPE="text/css">
<!--     BODY CODE  {font-family: Courier, Monospace;           font-size: 11pt}    TABLE, BODY          {font-family: Verdana, Arial, Helvetica, sans-serif;           font-size: 10pt}    PRE   {font-family: Courier, Monospace;           font-size: 10pt}    H3    {font-family: Verdana, Arial, Helvetica, sans-serif;           font-size: 11pt}    A.eglink {text-decoration: none}    A:hover.eglink {text-decoration: underline}    -->
</STYLE>
</HEAD>
<BODY>
<TABLE CELLSPACING="0" CELLPADDING="0" BORDER="0">
<TR>
<TD rowspan="3"><A HREF="/?l=ex"><IMG BORDER="0" ALIGN="BOTTOM" HSPACE="10" SRC="/egs/almanac14a.jpg"></A></TD><TD VALIGN="top"><font face="Times" size="6"><b>The Java Developers Almanac 1.4</b></font>
<br>
        Order this book from <a href="/cgi-bin/scripts/redirect.pl?l=ex&url=http://www.amazon.com/exec/obidos/ASIN/0201752808/xeo">Amazon</a>.
    </TD>
</TR>
<TR>
<TD align="right" valign="bottom">
<FORM method="get" action="/cgi-bin/search/find.pl">
<INPUT size="25" name="words" type="text"><INPUT value="Search" type="submit">
</FORM>
</TD>
</TR>
</TABLE>
<HR color="#6666cc">
<DIV ALIGN="LEFT">
<A HREF="/">Home</A>
    &gt;
    <A HREF="../index.html">List of Packages</A>
    &gt;
    <B><A HREF="../java.sql/pkg.html">java.sql</A></B><font color="#666666" SIZE="-2">
        &nbsp;[73 examples]
        </font>
        &gt;
        <B><A HREF="../java.sql/pkg.html#Oracle%20VARRAYs">Oracle VARRAYs</A></B><font color="#666666" SIZE="-2">
            &nbsp;[4 examples]
            </font>
</DIV><P>
  <h3>
    e304.  
    Getting a VARRAY Value from an Oracle Table</h3>

This example retrieves values contained in an Oracle VARRAY type.  The
example uses the table and array type created in
<a href="../java.sql/CreateArray.html" class="eglink"><font size="-1"><b>e301</b> Creating a VARRAY Type in an Oracle Database</font></a>.



<pre>
    try {
        // Create a statement
        Statement stmt = <font color="#0066ff"><i>connection</i></font>.createStatement();
    
        // Select rows from varray_table
        ResultSet resultSet = stmt.executeQuery(<font color="#0066ff"><i>"SELECT * FROM varray_table"</i></font>);
    
        // Get the VARRAY values from each row
        while (resultSet.next()) {
            // Get the VARRAY value in the first column
            oracle.sql.ARRAY array = ((oracle.jdbc.driver.OracleResultSet)resultSet).getARRAY(1);
    
            // Get the VARRAY elements; values.length is the number of values in the VARRAY
            java.math.BigDecimal[] values = (java.math.BigDecimal[])array.getArray();
        }
    } catch (SQLException e) {
    }
</pre>
<P><table width="600" CELLSPACING="0" CELLPADDING="2" BORDER="0">
<tr>
<td bgcolor="#6666cc" align="center"><font color="#ffffff">
            &nbsp;Related Examples
        </font></td>
</tr>
</table>


e301. <a class="eglink" href="CreateArray.html?l=rel">
    Creating a VARRAY Type in an Oracle Database
</a>
<br>

e302. <a class="eglink" href="InsertArray.html?l=rel">
    Inserting a VARRAY Value into an Oracle Table
</a>
<br>

e303. <a class="eglink" href="InsertArrayPs.html?l=rel">
    Inserting a VARRAY Value into an Oracle Table Using a Prepared Statement
</a>
<br>


<table width="600" CELLSPACING="0" CELLPADDING="2" BORDER="0">
<tr>
<td align="left">
<br>
        See also: 
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Batching">
    Batching
</a>&nbsp;&nbsp;

<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Connections">
    Connections
</a>&nbsp;&nbsp;

<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Database%20Meta%20Data">
    Database Meta Data
</a>&nbsp;&nbsp;

<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Deleting%20Data">
    Deleting Data
</a>&nbsp;&nbsp;

<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Drivers">
    Drivers
</a>&nbsp;&nbsp;

<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Importing%20and%20Exporting">
    Importing and Exporting
</a>&nbsp;&nbsp;

<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Inserting%20and%20Updating%20Data">
    Inserting and Updating Data
</a>&nbsp;&nbsp;

<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Oracle%20OBJECTs">
    Oracle OBJECTs
</a>&nbsp;&nbsp;

<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Procedures%20and%20Functions">
    Procedures and Functions
</a>&nbsp;&nbsp;

<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Retrieving%20Data">
    Retrieving Data
</a>&nbsp;&nbsp;

<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Scrollable%20Result%20Sets">
    Scrollable Result Sets
</a>&nbsp;&nbsp;

<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Tables">
    Tables
</a>&nbsp;&nbsp;

<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Updatable%20Result%20Sets">
    Updatable Result Sets
</a>&nbsp;&nbsp;

</td>
</tr>
</table>

<br>

<br>
<FONT FACE="Verdana, Arial, Helvetica, sans-serif" SIZE="0">
&copy; 2002 Addison-Wesley.
</FONT>
</BODY>
</HTML>

getarray.html - 源码说明

本页面展示了「java类库详细讲解」中的 getarray.html 源码文件，采用 HTML 编程语言编写，共 180 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与java相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?