这里面包含了一百多个JAVA源文件

源代码在线查看: e298. inserting an object value into an oracle table using a prepared statement.txt

软件大小: 551 K
上传用户: maple_78
关键词: JAVA
下载地址: 免注册下载 普通下载 VIP

相关代码

				This example inserts Oracle OBJECTs into an Oracle table using a prepared statement. The example uses the OBJECT types and table created in e296 Creating an OBJECT Type in an Oracle Database. 
				    try {
				        // Create an oracle.sql.STRUCT object to hold the values for object2
				        Object[] object2Values = new Object[]{"str", new BigDecimal(123)};
				        oracle.sql.StructDescriptor structDesc =
				            oracle.sql.StructDescriptor.createDescriptor("OBJECT2", connection);
				        oracle.sql.STRUCT object2 =
				            new oracle.sql.STRUCT(structDesc, connection, object2Values);
				    
				        // Create an oracle.sql.STRUCT object to hold the values for object1
				        Object[] object1Values = new Object[]{"str", object2};
				        structDesc = oracle.sql.StructDescriptor.createDescriptor("OBJECT1", connection);
				        oracle.sql.STRUCT object1 =
				            new oracle.sql.STRUCT(structDesc, connection, object1Values);
				    
				        // Create a prepared statement for insertion into object1_table
				        PreparedStatement ps =
				            connection.prepareStatement("INSERT INTO object1_table VALUES(?,?)");
				    
				        // Set the values to insert
				        ps.setInt(1, 123);
				        ps.setObject(2, object1);
				    
				        // Insert the new row
				        ps.execute();
				    } catch (SQLException e) {
				    }
				
							

相关资源