1、 -18- 外文原文 Accessing and Manipulating Oracle DataAccessing 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, offe
2、ring 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 getOracleObje
3、ct(), 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 J
4、DBC 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
