从 JDBC 类型映射到 Java 类型

来源：互联网发布：小学教师网络研修日志编辑：程序博客网时间：2024/05/22 00:22

从 JDBC 类型映射到 Java 类型

JDBC 类型Java 类型CHARStringVARCHARStringLONGVARCHARStringNUMERICjava.math.BigDecimalDECIMALjava.math.BigDecimalBITbooleanTINYINTbyteSMALLINTshortINTEGERintBIGINTlongREALfloatFLOATdoubleDOUBLEdoubleBINARYbyte[]VARBINARYbyte[]LONGVARBINARYbyte[]DATEjava.sql.DateTIMEjava.sql.TimeTIMESTAMPjava.sql.Timestamp

从 Java 类型映射到 JDBC 类型

Java 类型JDBC 类型StringVARCHAR 或 LONGVARCHARjava.math.BigDecimalNUMERICbooleanBITbyteTINYINTshortSMALLINTintINTEGERlongBIGINTfloatREALdoubleDOUBLEbyte[]VARBINARY 或 LONGVARBINARYjava.sql.DateDATEjava.sql.TimeTIMEjava.sql.TimestampTIMESTAMP

从 JDBC 类型到 Java Object 类型的映射

JDBC 类型Java Object 类型CHARStringVARCHARStringLONGVARCHARStringNUMERICjava.math.BigDecimalDECIMALjava.math.BigDecimalBITBooleanTINYINTIntegerSMALLINTIntegerINTEGERIntegerBIGINTLongREALFloatFLOATDoubleDOUBLEDoubleBINARYbyte[]VARBINARYbyte[]LONGVARBINARYbyte[]DATEjava.sql.DateTIMEjava.sql.TimeTIMESTAMPjava.sql.Timestamp

Java Object 类型映射到 JDBC 类型

Java Object 类型JDBC 类型StringVARCHAR 或 LONGVARCHARjava.math.BigDecimalNUMERICBooleanBITIntegerINTEGERLongBIGINTFloatREALDoubleDOUBLEbyte[]VARBINARY 或 LONGVARBINARYjava.sql.DateDATEjava.sql.TimeTIMEjava.sql.Timestamp

TIMESTAMP

各数据库JDBC类型Java类型映射

java.sql.Types 值Java 类型IBM DB2OracleSybaseSQLInformixIBM Content ManagerBIGINTjava.lang.longBIGINTNUMBER (38, 0)BIGINTBIGINTINT8DK_CM_BIGINTBINARYbyte[]CHAR FOR BIT DATARAWBINARYIMAGEBYTEDK_CM_BLOBBITjava.lang.BooleanN/ABITBITBITBITDK_CM_SMALLINTBLOBbyte[]BLOBBLOBBLOBBLOBBLOBDK_CM_BLOBCHARjava.lang.StringCHAR, GRAPHICCHARCHARCHARCHARDK_CM_CHARCLOBjava.lang.StringCLOB, DBCLOBCLOBCLOBCLOBCLOBDK_CM_CLOBDATEjava.sql.DateDATEDATEDATEDATEDATEDK_CM_DATEDECIMALjava.math.BigDecimalDECIMALNUMBERDECIMAL, MONEY, SMALLMONEYDECIMALDECIMALDK_CM_DECIMALDOUBLEjava.lang.DoubleDOUBLEDOUBLE PRECISIONDOUBLE PRECISIONDOUBLE PRECISIONDOUBLE PRECISIONDK_CM_DOUBLEFLOATjava.lang.DoubleFLOATFLOATFLOATFLOATFLOATDK_CM_DOUBLEINTEGERjava.lang.IntegerINTEGERINTEGERINTINTEGERINTEGERDK_CM_INTEGERJAVA_OBJECTjava.lang.ObjectJAVA_OBJECTJAVA_OBJECTJAVA_OBJECTJAVA_OBJECTOPAQUEN/ALONGVARBINARYbyte[]LONG VARCHAR FOR BIT DATALONG RAWIMAGEIMAGEBYTEDK_CM_BLOBLONGVARCHARjava.lang.StringLONG VARCHAR, LONG VARGRAPHICLONGTEXTTEXTTEXTDK_CM_VARCHAR(3500)NUMERICjava.math.BigDecimalNUMERICNUMBERNUMERICNUMERICNUMERICDK_CM_DECIMALOTHERjava.lang.ObjectOTHEROTHEROTHEROTHEROTHERN/AREALjava.lang.FloatREALREALREALREALREALDK_CM_DOUBLESMALLINTjava.lang.IntegerSMALLINTSMALLINTSMALLINTSMALLINTSMALLINTDK_CM_INTEGERTIMEjava.sql.TimeTIMEDATETIMETIMEDATETIME HOUR TO SECONDDK_CM_TIMETIMESTAMPjava.sql.TimestampTIMESTAMPDATEDATETIME, SMALLDATETIMEDATETIMEDATETIME YEAR TO FRACTION (5)DK_CM_TIMESTAMPTINYINTjava.lang.ButeSMALLINT

TINYINT

TINYINTTINYINTDK_CM_INTEGERVARBINARYbyte[]VARCHAR FOR BIT DATARAWVARBINARYIMAGEBYTEDK_CM_BLOBVARCHARjava.lang.StringVARCHAR, VARGRAPHICVARCHARVARCHARVARCHARVARCHARDK_CM_VARCHAR

2 0