常见oracle数据类型及其在java中的对应类型
| sql数据类型 | jdbc类型代码 | 标准的java类型 | oracle扩展的java类型 |
|---|---|---|---|
| 1.0标准的jdbc类型: | |||
| 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 |
| 2.0标准的jdbc类型: | |||
| 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.refjava.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 |