Oracle与Java JDBC数据类型对照

天天代码码天天
312 阅读1分钟

Oracle Database JDBC开发人员指南和参考

SQL Data TypesJDBC Type CodesStandard Java TypesOracle Extension Java Types
CHARjava.sql.Types.CHARjava.lang.Stringoracle.sql.CHAR
VARCHAR2java.sql.Types.VARCHARjava.lang.Stringoracle.sql.CHAR
LONGjava.sql.Types.LONGVARCHARjava.lang.Stringoracle.sql.CHAR
NUMBERjava.sql.Types.NUMERICjava.math.BigDecimaloracle.sql.NUMBER
NUMBERjava.sql.Types.DECIMALjava.math.BigDecimaloracle.sql.NUMBER
NUMBERjava.sql.Types.BITbooleanoracle.sql.NUMBER
NUMBERjava.sql.Types.TINYINTbyteoracle.sql.NUMBER
NUMBERjava.sql.Types.SMALLINTshortoracle.sql.NUMBER
NUMBERjava.sql.Types.INTEGERintoracle.sql.NUMBER
NUMBERjava.sql.Types.BIGINTlongoracle.sql.NUMBER
NUMBERjava.sql.Types.REALfloatoracle.sql.NUMBER
NUMBERjava.sql.Types.FLOATdoubleoracle.sql.NUMBER
NUMBERjava.sql.Types.DOUBLEdoubleoracle.sql.NUMBER
RAWjava.sql.Types.BINARYbyte[]oracle.sql.RAW
RAWjava.sql.Types.VARBINARYbyte[]oracle.sql.RAW
LONGRAWjava.sql.Types.LONGVARBINARYbyte[]oracle.sql.RAW
DATEjava.sql.Types.DATEjava.sql.Dateoracle.sql.DATE
DATEjava.sql.Types.TIMEjava.sql.Timeoracle.sql.DATE
TIMESTAMPjava.sql.Types.TIMESTAMPjaval.sql.Timestamporacle.sql.TIMESTAMP
BLOBjava.sql.Types.BLOBjava.sql.Bloboracle.jdbc.OracleBlobFoot 1
CLOBjava.sql.Types.CLOBjava.sql.Cloboracle.jdbc.OracleClobFoot 2
user-defined objectjava.sql.Types.STRUCTjava.sql.Structoracle.jdbc.OracleStructFoot 3
user-defined referencejava.sql.Types.REFjava.sql.Reforacle.jdbc.OracleRefFoot 4
user-defined collectionjava.sql.Types.ARRAYjava.sql.Arrayoracle.jdbc.OracleArrayFoot 5
ROWIDjava.sql.Types.ROWIDjava.sql.RowIdoracle.sql.ROWID
NCLOBjava.sql.Types.NCLOBjava.sql.NCloboracle.sql.NCLOB
NCHARjava.sql.Types.NCHARjava.lang.Stringoracle.sql.CHAR
BFILEoracle.jdbc.OracleTypes.BFILE(ORACLE EXTENSION)NAoracle.sql.BFILE
REF CURSORoracle.jdbc.OracleTypes.CURSOR(ORACLE EXTENSION)java.sql.ResultSetoracle.jdbc.OracleResultSet
TIMESTAMPoracle.jdbc.OracleTypes.TIMESTAMP(ORACLE EXTENSION)java.sql.Timestamporacle.sql.TIMESTAMP
TIMESTAMP WITH TIME ZONEoracle.jdbc.OracleTypes.TIMESTAMPTZ(ORACLE EXTENSION)java.sql.Timestamporacle.sql.TIMESTAMPTZ
TIMESTAMP WITH LOCAL TIME ZONEoracle.jdbc.OracleTypes.TIMESTAMPLTZ(ORACLE EXTENSION)java.sql.Timestamporacle.sql.TIMESTAMPLTZ
avatar
文章
阅读
粉丝