|
地址：
http://otndnld./document/products/oracle10g/102/doc_cd/java.102/B19275-03/datacc.htm#BHCJBJCC
| SQL數(shù)據(jù)類型 |
JDBC類型代碼 |
標(biāo)準(zhǔn)的Java類型 |
Oracle擴(kuò)展的Java類型 |
| |
1.0標(biāo)準(zhǔn)的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標(biāo)準(zhǔn)的JDBC類型:
|
|
|
|
BLOB
|
java.sql.Types.BLOB
|
java.sql.Blob
|
oracle.sql.BLOB
|
|
CLOB
|
java.sql.Types.CLOB
|
java.sql.Clob
|
oracle.sql.CLOB
|
|
用戶定義的對(duì)象
|
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擴(kuò)展:
|
|
|
|
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
|
|
