这个压缩包里的都是超级经典的java例子
源代码在线查看: insertobjectoracle.htm
Inserting an OBJECT Value into an Oracle Table (Java Developers Almanac Example)
The Java Developers Almanac 1.4
Order this book from Amazon.
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";
//-->
Home
>
List of Packages
>
java.sql
[73 examples]
>
Oracle OBJECTs
[5 examples]
e297. Inserting an OBJECT Value into an Oracle Table
This example inserts a row into a table with a column that contains an
OBJECT type. The example uses the table and types created in
e296 Creating an OBJECT Type in an Oracle Database.
try {
// Create a statement
Statement stmt = connection.createStatement();
// Insert a row with values for both the object1 and object2 types
stmt.execute("INSERT INTO object1_table VALUES(1, object1('str1', object2('obj2str1', 123)))");
} catch (SQLException e) {
}
Related Examples
e296.
Creating an OBJECT Type in an Oracle Database
e298.
Inserting an OBJECT Value into an Oracle Table Using a Prepared Statement
e299.
Getting an OBJECT Value from an Oracle Table
e300.
Deleting an OBJECT Type from an Oracle Table
See also:
Batching
Connections
Database Meta Data
Deleting Data
Drivers
Importing and Exporting
Inserting and Updating Data
Oracle VARRAYs
Procedures and Functions
Retrieving Data
Scrollable Result Sets
Tables
Updatable Result Sets
© 2002 Addison-Wesley.