Mybatis中jdbcType和javaType以及数据库类型的对应关系
|
|
|
|
CHAR
|
String
|
CHAR
|
CHAR
|
VARCHAR
|
String
|
VARCHAR
|
VARCHAR
|
LONGVARCHAR
|
String
|
VARCHAR
|
LONG
|
NUMERIC
|
java.math.BigDecimal
|
NUMERIC
|
NUMERIC/NUMBER
|
DECIMAL
|
java.math.BigDecimal
|
DECIMAL
|
DECIMAL
|
BIT
|
boolean
|
|
BIT
|
BOOLEAN
|
boolean
|
|
|
TINYINT
|
byte
|
TINYINT
|
TINYINT
|
SMALLINT
|
short
|
SMALLINT
|
SMALLINT
|
INTEGER
|
int
|
INTEGER
|
INTEGER
|
BIGINT
|
long
|
BIGINT
|
|
REAL
|
float
|
REAL
|
REAL
|
FLOAT
|
double
|
FLOAT
|
FLOAT
|
DOUBLE
|
double
|
DOUBLE
|
NUMBER
|
BINARY
|
byte[]
|
|
|
VARBINARY
|
byte[]
|
|
|
LONGVARBINARY
|
byte[]
|
|
|
DATE
|
java.sql.Date
|
DATE
|
DATE
|
TIME
|
java.sql.Time
|
|
TIME
|
TIMESTAMP
|
java.sql.Timestamp
|
TIMESTAMP/DATETIME
|
TIMESTAMP
|
CLOB
|
Clob
|
CLOB
|
CLOB
|
BLOB
|
Blob
|
BLOB
|
BLOB
|
ARRAY
|
Array
|
|
|
DISTINCT
|
mapping of underlying type
|
|
|
STRUCT
|
Struct
|
|
|
REF
|
Ref
|
|
|
DATALINK
|
java.net.URL[color=red][/color]
|
|
|
NCLOB
|
|
|
NCLOB
|
|
|
|
|
原文地址:https://www.cnblogs.com/guoyinghome/p/10904052.html