这个压缩包里的都是超级经典的java例子

				
				
				
				Inserting a VARRAY Value into an Oracle Table Using a Prepared Statement (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 VARRAYs
				             [4 examples]
				            
				
				  e303. Inserting a VARRAY Value into an Oracle Table Using a Prepared Statement
				
				This example inserts a row with a VARRAY of numbers as defined in
				e301 Creating a VARRAY Type in an Oracle Database. This example uses a prepared
				statement.
				
				
				    try {
				        // Create an oracle.sql.ARRAY object to hold the values
				        oracle.sql.ArrayDescriptor arrayDesc =
				            oracle.sql.ArrayDescriptor.createDescriptor("number_varray", connection);
				        int arrayValues[] = {123, 234};
				        oracle.sql.ARRAY array = new oracle.sql.ARRAY(arrayDesc, connection, arrayValues);
				    
				        // Create a prepared statement for insertion into varray_table
				        PreparedStatement ps =
				            connection.prepareStatement("INSERT INTO varray_table VALUES(?)");
				    
				        // Set the values to insert
				        ((oracle.jdbc.driver.OraclePreparedStatement)ps).setARRAY(1, array);
				    
				        // Insert the new row
				        ps.execute();
				    } catch (SQLException e) {
				    }
				
				
				
				
				             Related Examples
				
				
				
				
				e301. 
				    Creating a VARRAY Type in an Oracle Database
				
				
				
				e302. 
				    Inserting a VARRAY Value into an Oracle Table
				
				
				
				e304. 
				    Getting a VARRAY Value from an Oracle Table
				
				
				
				
				
				
				
				
				        See also: 
				
				    Batching
				  
				
				
				    Connections
				  
				
				
				    Database Meta Data
				  
				
				
				    Deleting Data
				  
				
				
				    Drivers
				  
				
				
				    Importing and Exporting
				  
				
				
				    Inserting and Updating Data
				  
				
				
				    Oracle OBJECTs
				  
				
				
				    Procedures and Functions
				  
				
				
				    Retrieving Data
				  
				
				
				    Scrollable Result Sets
				  
				
				
				    Tables
				  
				
				
				    Updatable Result Sets
				  
				
				
				
				
				
				
				
				
				
				© 2002 Addison-Wesley.