jdbcType与javaType的对应关系

java.sql.Types 值(jdbcType)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

TINYINT

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

其中针对INTEGER类型：

SQLDatatypes

JDBC Typecodes

Standard Java Types

Java取值范围

NUMBER

java.sql.Types.NUMERIC

java.math.BigDecimal

无限制

NUMBER

java.sql.Types.DECIMAL

java.math.BigDecimal

无限制

NUMBER

java.sql.Types.BIT

boolean

true,false

NUMBER

java.sql.Types.TINYINT

byte

from –128 to 127

NUMBER

java.sql.Types.SMALLINT

short

from –32768 to 32767

NUMBER

java.sql.Types.INTEGER

int

From –2147483648 to 2147483647

NUMBER

java.sql.Types.BIGINT

long

From –9223372036854775808 to 9223372036854775807

NUMBER

java.sql.Types.REAL

float

From 1.4E-45

To 3.4028235E38

NUMBER

java.sql.Types.FLOAT

double

From 4.9E-324 to

1.7976931348623157E308

NUMBER

java.sql.Types.DOUBLE

double