mybatis的jdbcType和javaType、oracle,MySQL的对应类型
Mybatis中jdbcType和javaType的对应关系
JDBC Type | Java Type | JDBC Type | Java Type |
---|
CHAR | String | FLOAT | double |
VARCHAR | String | DOUBLE | double |
LONGVARCHAR | String | BINARY | byte[] |
NUMERIC | java.math.BigDecimal | VARBINARY | byte[] |
DECIMAL | java.math.BigDecimal | LONGVARBINARY | byte[] |
BIT | boolean | DATE | java.sql.Date |
BOOLEAN | boolean | TIME | java.sql.Time |
TINYINT | byte | TIMESTAMP | java.sql.Timestamp |
SMALLINT | short | CLOB | Clob |
INTEGER | int | BLOB | Blob |
BIGINT | long | ARRAY | Array |
REAL | float | DISTINCT | mapping of underlying type |
STRUCT | Struct | REF | Ref |
DATALINK | java.net.URL | | |
Mybatis JdbcType与Oracle、MySql数据类型对应列表
https://www.cnblogs.com/pianai-shu/p/6349183.html