翻译文献Working with Oracle Object Types.docVIP

大连交通大学2016届本科生毕业设计（论文）外文翻译 -12- 外文原文 Working with Oracle Object Types This chapter describes JDBC support for user-defined object types. It discusses functionality of the generic, weakly typed oracle.sql.STRUCT class, as well as how to map to custom Java classes that implement either the JDBC standard SQLData interface or the Oracle ORAData interface. This chapter also describes how JDBC drivers access SQLJ object types in SQL representation. The following topics are covered: _ Mapping Oracle Objects _ Using the Default STRUCT Class for Oracle Objects _ Creating and Using Custom Object Classes for Oracle Objects _ Object-Type Inheritance _ Using JPublisher to Create Custom Object Classes _ Describing an Object Type _ SQLJ Object Types Note: For general information about Oracle object features and functionality, see the Oracle9i Application Developers Guide -Object-Relational Features. Mapping Oracle Objects Oracle object types provide support for composite data structures in the database. For example, you can define a type Person that has attributes such as name (type CHAR), phone number (type CHAR), and employee number (type NUMBER). Oracle provides tight integration between its Oracle object features and its JDBC functionality. You can use a standard, generic JDBC type to map to Oracle objects, or you can customize the mapping by creating custom Java type definition classes. In this book, Java classes that you create to map to Oracle objects will be referred to as custom Java classes or, more specifically, custom object classes. This is as opposed to custom references classes to map to object references, and custom collection classes to map to Oracle collections. Custom object classes can implement either a standard JDBC interface or an Oracle extension interface to read and write data. JDBC materializes Oracle objects as instances of particular Java classes. Two main steps in using JDBC to access Oracle objects are: 1) cr