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
|
![](https://img2024.cnblogs.com/blog/35695/202408/35695-20240826070647288-243310440.jpg)