jdbcType与javaType的对应关系

来源：互联网发布：一品威客网知乎编辑：程序博客网时间：2024/06/05 08:26

Java 类型java.sql.Types 值OracleIBM DB2SybaseSQLInformixIBM Content Managerjava.lang.longBIGINTNUMBER (38, 0)BIGINTBIGINTBIGINTINT8DK_CM_BIGINTbyte[]BINARYRAWCHAR FOR BIT DATABINARYIMAGEBYTEDK_CM_BLOBjava.lang.BooleanBITBITN/ABITBITBITDK_CM_SMALLINTbyte[]BLOBBLOBBLOBBLOBBLOBBLOBDK_CM_BLOBjava.lang.StringCHARCHARCHAR, GRAPHICCHARCHARCHARDK_CM_CHARjava.lang.StringCLOBCLOBCLOB, DBCLOBCLOBCLOBCLOBDK_CM_CLOBjava.sql.DateDATEDATEDATEDATEDATEDATEDK_CM_DATEjava.math.BigDecimalDECIMALNUMBERDECIMALDECIMAL, MONEY, SMALLMONEYDECIMALDECIMALDK_CM_DECIMALjava.lang.DoubleDOUBLEDOUBLE PRECISIONDOUBLEDOUBLE PRECISIONDOUBLE PRECISIONDOUBLE PRECISIONDK_CM_DOUBLEjava.lang.DoubleFLOATFLOATFLOATFLOATFLOATFLOATDK_CM_DOUBLEjava.lang.IntegerINTEGERINTEGERINTEGERINTINTEGERINTEGERDK_CM_INTEGERjava.lang.ObjectJAVA_OBJECTJAVA_OBJECTJAVA_OBJECTJAVA_OBJECTJAVA_OBJECTOPAQUEN/Abyte[]LONGVARBINARYLONG RAWLONG VARCHAR FOR BIT DATAIMAGEIMAGEBYTEDK_CM_BLOBjava.lang.StringLONGVARCHARLONGLONG VARCHAR, LONG VARGRAPHICTEXTTEXTTEXTDK_CM_VARCHAR(3500)java.math.BigDecimalNUMERICNUMBERNUMERICNUMERICNUMERICNUMERICDK_CM_DECIMALjava.lang.ObjectOTHEROTHEROTHEROTHEROTHEROTHERN/Ajava.lang.FloatREALREALREALREALREALREALDK_CM_DOUBLEjava.lang.IntegerSMALLINTSMALLINTSMALLINTSMALLINTSMALLINTSMALLINTDK_CM_INTEGERjava.sql.TimeTIMEDATETIMETIMETIMEDATETIME HOUR TO SECONDDK_CM_TIMEjava.sql.TimestampTIMESTAMPDATETIMESTAMPDATETIME, SMALLDATETIMEDATETIMEDATETIME YEAR TO FRACTION (5)DK_CM_TIMESTAMPjava.lang.ButeTINYINTTINYINTSMALLINTTINYINTTINYINTTINYINTDK_CM_INTEGERbyte[]VARBINARYRAWVARCHAR FOR BIT DATAVARBINARYIMAGEBYTEDK_CM_BLOBjava.lang.StringVARCHARVARCHARVARCHAR, VARGRAPHICVARCHARVARCHARVARCHARDK_CM_VARCHAR

0 0