|
SQL类型
|
Java类型
|
|---|---|
|
CHAR
|
java.lang.String
|
|
VARCHAR
|
java.lang.String
|
|
LONGVARCHAR
|
java.lang.String
|
|
NUMERIC
|
java.math.BigDecimal
|
|
DECIMAL
|
java.math.BigDecimal
|
|
BIT
|
boolean
|
|
TINYINT
|
byte
|
|
SMALLINT
|
short
|
|
INTEGER
|
int
|
|
BIGINT
|
long
|
|
REAL
|
float
|
|
FLOAT
|
double
|
|
DOUBLE
|
double
|
|
BINARY
|
byte[]
|
|
VARBINARY
|
byte[]
|
|
LONGVARBINARY
|
byte[]
|
|
DATE
|
java.sql.Date
|
|
TIME
|
java.sql.Time
|
|
TIMESTAMP
|
java.sql.Timestamp
|
|
BLOB
|
java.sql.Blob
|
|
CLOB
|
java.sql.Clob
|
|
Array
|
java.sql.Array
|
|
REF
|
java.sql.Ref
|
|
Struct
|
java.sql.Struct
|
