翻译文献Accessing and Manipulating Oracle Data.docVIP

大连交通大学2016届本科生毕业设计（论文）外文翻译 -18- 外文原文 Accessing and Manipulating Oracle Data This chapter describes data access in oracle.sql.* formats, as opposed to standard Java formats. As described in the previous chapter, the oracle.sql.* formats are a key factor of the Oracle JDBC extensions, offering significant advantages in efficiency and precision in manipulating SQL data. Using oracle.sql.* formats involves casting your result sets and statements to OracleResultSet, OracleStatement, OraclePreparedStatement, and OracleCallableStatement objects, as appropriate, and using the getOracleObject(), setOracleObject(), getXXX(), and setXXX() methods of these classes (where XXX corresponds to the types in the oracle.sql package). This chapter covers the following topics: Data Conversion Considerations Result Set and Statement Extensions Comparison of Oracle get and set Methods to Standard JDBC Using Result Set Meta Data Extensions Data Conversion Considerations When JDBC programs retrieve SQL data into Java, you can use standard Java types, or you can use types of the oracle.sql package. The classes in this package simply wrap the raw SQL data. Standard Types versus Oracle Types In processing speed and effort, the oracle.sql.* classes provide the most efficient way of representing SQL data. These classes store the usual representations of SQL data as byte arrays. They do not reformat the data or perform any character-set conversions (aside from the usual network conversions) on it. The data remains in SQL format, and therefore no information is lost. For SQL primitive types (such as NUMBER, and CHAR), the oracle.sql.* classes simply wrap the SQL data. For SQL structured types (such as objects and arrays), the classes provide additional information such as conversion methods and structure details. If you are moving data within the database, then you will probably want to keep your data in oracle.sql.* format. If you are displaying the data or performing calculations on it