jdbcType与javaType的对应关系

来源：互联网发布：淘宝巧克力知乎编辑：程序博客网时间：2024/06/07 00:34

java.sql.Types 值Java 类型IBM DB2OracleSybaseSQLInformixIBM Content Manager BIGINTjava.lang.longBIGINTNUMBER (38, 0)BIGINTBIGINTINT8DK_CM_BIGINT BINARYbyte[]CHAR FOR BIT DATARAWBINARYIMAGEBYTEDK_CM_BLOB BITjava.lang.BooleanN/ABITBITBITBITDK_CM_SMALLINT BLOBbyte[]BLOBBLOBBLOBBLOBBLOBDK_CM_BLOB CHARjava.lang.StringCHAR, GRAPHICCHARCHARCHARCHARDK_CM_CHAR CLOBjava.lang.StringCLOB, DBCLOBCLOBCLOBCLOBCLOBDK_CM_CLOB DATEjava.sql.DateDATEDATEDATEDATEDATEDK_CM_DATE DECIMALjava.math.BigDecimalDECIMALNUMBERDECIMAL, MONEY, SMALLMONEYDECIMALDECIMALDK_CM_DECIMAL DOUBLEjava.lang.DoubleDOUBLEDOUBLE PRECISIONDOUBLE PRECISIONDOUBLE PRECISIONDOUBLE PRECISIONDK_CM_DOUBLE FLOATjava.lang.DoubleFLOATFLOATFLOATFLOATFLOATDK_CM_DOUBLE INTEGERjava.lang.IntegerINTEGERINTEGERINTINTEGERINTEGERDK_CM_INTEGER JAVA_OBJECTjava.lang.ObjectJAVA_OBJECTJAVA_OBJECTJAVA_OBJECTJAVA_OBJECTOPAQUEN/A LONGVARBINARYbyte[]LONG VARCHAR FOR BIT DATALONG RAWIMAGEIMAGEBYTEDK_CM_BLOB LONGVARCHARjava.lang.StringLONG VARCHAR, LONG VARGRAPHICLONGTEXTTEXTTEXTDK_CM_VARCHAR(3500) NUMERICjava.math.BigDecimalNUMERICNUMBERNUMERICNUMERICNUMERICDK_CM_DECIMAL OTHERjava.lang.ObjectOTHEROTHEROTHEROTHEROTHERN/A REALjava.lang.FloatREALREALREALREALREALDK_CM_DOUBLE SMALLINTjava.lang.IntegerSMALLINTSMALLINTSMALLINTSMALLINTSMALLINTDK_CM_INTEGER TIMEjava.sql.TimeTIMEDATETIMETIMEDATETIME HOUR TO SECONDDK_CM_TIME TIMESTAMPjava.sql.TimestampTIMESTAMPDATEDATETIME, SMALLDATETIMEDATETIMEDATETIME YEAR TO FRACTION (5)DK_CM_TIMESTAMP TINYINTjava.lang.ButeSMALLINT

TINYINT

TINYINTTINYINTDK_CM_INTEGER VARBINARYbyte[]VARCHAR FOR BIT DATARAWVARBINARYIMAGEBYTEDK_CM_BLOB VARCHARjava.lang.StringVARCHAR, VARGRAPHICVARCHARVARCHARVARCHARVARCHARDK_CM_VARCHAR

0 0