📄 insertobjectoraclepreparedstatement.htm
字号:
<HTML>
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<TITLE>Inserting an OBJECT Value into an Oracle Table Using a Prepared Statement (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">
<META CONTENT="no-cache" HTTP-EQUIV="Pragma">
<LINK href="/almanac.css" media="screen" type="text/css" rel="stylesheet">
</HEAD>
<BODY>
<TABLE CELLSPACING="0" CELLPADDING="0" BORDER="0">
<TR>
<TD></TD>
</TR>
</TABLE>
<br>
<TABLE CELLSPACING="0" CELLPADDING="0" BORDER="0">
<TR>
<TD></TD>
</TR>
<TR>
<TD rowspan="3"><A HREF="/?l=ex"><IMG BORDER="0" ALIGN="BOTTOM" HSPACE="10" SRC="/egs/almanac14a.jpg"></A></TD><TD VALIGN="top">
<h1>The Java Developers Almanac 1.4</h1>
<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">
<TABLE CELLSPACING="0" CELLPADDING="0" BORDER="0">
<TR>
<TD valign="top"><script type="text/javascript">
<!--
google_ad_client = "pub-6001183370374757";
google_ad_width = 120;
google_ad_height = 600;
google_ad_format = "120x600_as";
google_ad_channel = "4777242811";
google_ad_type = "text_image";
google_color_border = "FFFFFF";
google_color_bg = "FFFFFF";
google_color_link = "6666CC";
google_color_url = "6666CC";
google_color_text = "000000";
//--></script><script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript"></script></TD><TD> </TD><TD valign="top">
<DIV ALIGN="LEFT">
<A HREF="/">Home</A>
>
<A HREF="../index.html">List of Packages</A>
>
<A HREF="../java.sql/pkg.html">java.sql</A><font color="#666666" class="xsmall-font">
[73 examples]
</font>
>
<B><A HREF="../java.sql/pkg.html#Oracle OBJECTs">Oracle OBJECTs</A></B><font color="#666666" class="xsmall-font">
[5 examples]
</font>
</DIV><P>
<h3>e298. Inserting an OBJECT Value into an Oracle Table Using a Prepared Statement</h3>
This example inserts Oracle OBJECTs into an Oracle table using a
prepared statement. The example uses the OBJECT types and table
created in <a href="../java.sql/CreateObjectOracle.html" class="eglink"><b>e296</b> Creating an OBJECT Type in an Oracle Database</a>.
<pre> try {
// Create an oracle.sql.STRUCT object to hold the values for object2
Object[] object2Values = new Object[]{<font color="#0066ff"><i>"str"</i></font>, new BigDecimal(<font color="#0066ff"><i>123</i></font>)};
oracle.sql.StructDescriptor structDesc =
oracle.sql.StructDescriptor.createDescriptor("OBJECT2", <font color="#0066ff"><i>connection</i></font>);
oracle.sql.STRUCT object2 =
new oracle.sql.STRUCT(structDesc, <font color="#0066ff"><i>connection</i></font>, object2Values);
// Create an oracle.sql.STRUCT object to hold the values for object1
Object[] object1Values = new Object[]{<font color="#0066ff"><i>"str"</i></font>, object2};
structDesc = oracle.sql.StructDescriptor.createDescriptor("OBJECT1", <font color="#0066ff"><i>connection</i></font>);
oracle.sql.STRUCT object1 =
new oracle.sql.STRUCT(structDesc, <font color="#0066ff"><i>connection</i></font>, object1Values);
// Create a prepared statement for insertion into object1_table
PreparedStatement ps =
<font color="#0066ff"><i>connection</i></font>.prepareStatement("INSERT INTO object1_table VALUES(?,?)");
// Set the values to insert
ps.setInt(1, <font color="#0066ff"><i>123</i></font>);
ps.setObject(2, object1);
// Insert the new row
ps.execute();
} catch (SQLException e) {
}
</pre>
<P><table width="600" CELLSPACING="0" CELLPADDING="2" BORDER="0">
<tr>
<td bgcolor="#6666cc" align="center"><font color="#ffffff">
<b>Related Examples</b></font></td>
</tr>
</table>
e296. <a class="eglink" href="CreateObjectOracle.html?l=rel">
Creating an OBJECT Type in an Oracle Database
</a>
<br>
e297. <a class="eglink" href="InsertObjectOracle.html?l=rel">
Inserting an OBJECT Value into an Oracle Table
</a>
<br>
e299. <a class="eglink" href="GetObjectOracle.html?l=rel">
Getting an OBJECT Value from an Oracle Table
</a>
<br>
e300. <a class="eglink" href="DropObjectOracle.html?l=rel">
Deleting an OBJECT Type from an Oracle Table
</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>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Connections">
Connections
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Database%20Meta%20Data">
Database Meta Data
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Deleting%20Data">
Deleting Data
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Drivers">
Drivers
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Importing%20and%20Exporting">
Importing and Exporting
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Inserting%20and%20Updating%20Data">
Inserting and Updating Data
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Oracle%20VARRAYs">
Oracle VARRAYs
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Procedures%20and%20Functions">
Procedures and Functions
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Retrieving%20Data">
Retrieving Data
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Scrollable%20Result%20Sets">
Scrollable Result Sets
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Tables">
Tables
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Updatable%20Result%20Sets">
Updatable Result Sets
</a>
</td>
</tr>
</table>
<br>
<br>
<FONT class="xsmall-font">
© 2002 Addison-Wesley.
</FONT></TD><TD> </TD><TD valign="top"><A href="http://compositesw.com/devzone?ref=javaalmanac"><IMG alt="Click Here" height="600" width="120" border="0" src="/csw_oad_120x600_final.gif"></A></TD>
</TR>
</TABLE>
</BODY>
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<META CONTENT="NO-CACHE" HTTP-EQUIV="PRAGMA">
</HEAD>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -