jdbcType與javaType的對應關系



java.sql.types 值

java 類型

ibm db2

oracle

sybase

sql

informix

ibm content manager

bigint

java.lang.long

number (38, 0)

int8

dk_cm_bigint

binary

byte[]

char for bit data

raw

image

byte

dk_cm_blob

bit

java.lang.boolean

n/a

dk_cm_smallint

blob

char

java.lang.string

char, graphic

dk_cm_char

clob

clob, dbclob

dk_cm_clob

date

java.sql.date

dk_cm_date

decimal

java.math.bigdecimal

number

decimal, money, smallmoney

dk_cm_decimal

double

java.lang.double

double precision

dk_cm_double

float

integer

java.lang.integer

int

dk_cm_integer

java_object

java.lang.object

opaque

longvarbinary

long varchar for bit data

long raw

longvarchar

long varchar, long vargraphic

long

text

dk_cm_varchar(3500)

numeric

other

real

java.lang.float

smallint

time

java.sql.time

datetime hour to second

dk_cm_time

timestamp

java.sql.timestamp

datetime, smalldatetime

datetime

datetime year to fraction (5)

dk_cm_timestamp

tinyint

java.lang.bute

varbinary

varchar for bit data

varchar

varchar, vargraphic

dk_cm_var