oracle数据类型和对应的java类型
| SQL类型 |
JDBC类型(JDBC 1.0) |
Java型 |
Oracle Java型 |
| CHAR |
java.sql.Types.CHAR |
java.lang.String |
oracle.sql.CHAR |
| VARCHAR2 |
java.sql.Types.VARCHAR |
java.lang.String |
oracle.sql.CHAR |
| LONG |
java.sql.Types.LONGVARCHAR |
java.lang.String |
oracle.sql.CHAR |
| NUMBER |
java.sql.Types.NUMERIC |
java.math.BigDecimal |
oracle.sql.NUMBER |
| NUMBER |
java.sql.Types.DECIMAL |
java.math.BigDecimal |
oracle.sql.NUMBER |
| NUMBER |
java.sql.Types.BIT |
boolean |
oracle.sql.NUMBER |
| NUMBER |
java.sql.Types.TINYINT |
byte |
oracle.sql.NUMBER |
| NUMBER |
java.sql.Types.SMALLINT |
short |
oracle.sql.NUMBER |
| NUMBER |
java.sql.Types.INTEGER |
int |
oracle.sql.NUMBER |
| NUMBER |
java.sql.Types.BIGINT |
long |
oracle.sql.NUMBER |
| NUMBER |
java.sql.Types.REAL |
float |
oracle.sql.NUMBER |
| NUMBER |
java.sql.Types.FLOAT |
double |
oracle.sql.NUMBER |
| NUMBER |
java.sql.Types.DOUBLE |
double |
oracle.sql.NUMBER |
| RAW |
java.sql.Types.BINARY |
byte[] |
oracle.sql.RAW |
| RAW |
java.sql.Types.VARBINARY |
byte[] |
oracle.sql.RAW |
| LONGRAW |
java.sql.Types.LONGVARBINARY |
byte[] |
oracle.sql.RAW |
| DATE |
java.sql.Types.DATE |
java.sql.Date |
oracle.sql.DATE |
| DATE |
java.sql.Types.TIME |
java.sql.Time |
oracle.sql.DATE |
| TIMESTAMP |
java.sql.Types.TIMESTAMP |
javal.sql.Timestamp |
oracle.sql.TIMESTAMP |
| JDBC 2.0: |
|||
| BLOB |
java.sql.Types.BLOB |
java.sql.Blob |
oracle.sql.BLOB |
| CLOB |
java.sql.Types.CLOB |
java.sql.Clob |
oracle.sql.CLOB |
|
|
java.sql.Types.STRUCT |
java.sql.Struct |
oracle.sql.STRUCT |
|
|
java.sql.Types.REF |
java.sql.Ref |
oracle.sql.REF |
|
|
java.sql.Types.ARRAY |
java.sql.Array |
oracle.sql.ARRAY |
| Oracle扩展 |
|||
| BFILE |
oracle.jdbc.OracleTypes.BFILE |
N/A |
oracle.sql.BFILE |
| ROWID |
oracle.jdbc.OracleTypes.ROWID |
N/A |
oracle.sql.ROWID |
| REF CURSOR |
oracle.jdbc.OracleTypes.CURSOR |
java.sql.ResultSet |
oracle.jdbc.OracleResultSet |
| TIMESTAMP |
oracle.jdbc.OracleTypes.TIMESTAMP |
java.sql.Timestamp |
oracle.sql.TIMESTAMP |
| TIMESTAMP WITH TIME ZONE |
oracle.jdbc.OracleTypes.TIMESTAMPTZ |
java.sql.Timestamp |
oracle.sql.TIMESTAMPTZ |
| TIMESTAMP WITH LOCAL TIME ZONE |
oracle.jdbc.OracleTypes.TIMESTAMPLTZ |
java.sql.Timestamp |
oracle.sql.TIMESTAMPLTZ |