本文详细介绍了Mybatis中JdbcType与MySQL数据库各种数据类型的对应关系，帮助开发者高效地进行数据映射，减少类型转换错误。
Mybatis JdbcType和Mysql数据类型对应关系
|
Mybatis |
JdbcType |
MySql |
|
JdbcType |
ARRAY | |
|
JdbcType |
BIGINT |
BIGINT |
|
JdbcType |
BINARY | |
|
JdbcType |
BIT |
BIT |
|
JdbcType |
BLOB |
BLOB |
|
JdbcType |
BOOLEAN | |
|
JdbcType |
CHAR |
CHAR |
|
JdbcType |
CLOB |
CLOB–>修改为TEXT |
|
JdbcType |
CURSOR | |
|
JdbcType |
DATE |
DATE |
|
JdbcType |
DECIMAL |
DECIMAL |
|
JdbcType |
DOUBLE |
DOUBLE |
|
JdbcType |
FLOAT |
FLOAT |
|
JdbcType |
INTEGER |
INTEGER |
|
JdbcType |
LONGVARBINARY | |
|
JdbcType |
LONGVARCHAR | |
|
JdbcType |
NCHAR | |
|
JdbcType |
NCLOB | |
|
JdbcType |
NULL | |
|
JdbcType |
NUMERIC |
NUMERIC/ |
|
JdbcType |
NVARCHAR | |
|
JdbcType |
OTHER | |
|
JdbcType |
REAL |
REAL |
|
JdbcType |
SMALLINT |
SMALLINT |
|
JdbcType |
STRUCT | |
|
JdbcType |
TIME |
TIME |
|
JdbcType |
TIMESTAMP |
TIMESTAMP/DATETIME |
|
JdbcType |
TINYINT |
TINYINT |
|
JdbcType |
UNDEFINED | |
|
JdbcType |
VARBINARY | |
|
JdbcType |
VARCHAR |
VARCHAR |
扫一扫
6604
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
