本文详细介绍了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 |
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
