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 |