Mybatis的JdbcType类型与Java和Oracle、Mysql数据库类型对应关系
本文所列JdbcType类型引自官方文档:JdbcTypeJavaTypeOracle类型MySQL类型ARRAYArrayBIGINTLongBIGINTBIGINTBINARYByte[]BITBooleanBITBITBLOBBlobBLOBBLOBBOOLEANBooleanTINYINTTINYI...
·
本文所列JdbcType类型引自官方文档:
| JdbcType | JavaType | Oracle类型 | MySQL类型 |
|---|---|---|---|
| ARRAY | Array | ||
| BIGINT | Long | BIGINT | BIGINT |
| BINARY | Byte[] | ||
| BIT | Boolean | BIT | BIT |
| BLOB | Blob | BLOB | BLOB |
| BOOLEAN | Boolean | TINYINT | TINYINT |
| CHAR | String | CHAR | CHAR |
| CLOB | Clob | CLOB | VARCHAR/TEXT |
| CURSOR | |||
| DATALINK | |||
| DATE | Date | DATE | DATE |
| DATETIMEOFFSET | |||
| DECIMAL | BigDecimal | DECIMAL | DECIMAL |
| DISTINCT | |||
| DOUBLE | Double | NUMBER | DOUBLE |
| FLOAT | Float | FLOAT | FLOAT |
| INTEGER | Integer | INTEGER | INTEGER |
| JAVA_OBJECT | |||
| LONGNVARCHAR | String | LONG VARCHAR | VARCHAR |
| LONGVARBINARY | Byte[] | LONGVARBINARY | LONGBLOB |
| LONGVARCHAR | String | LONG VARCHAR | VARCHAR |
| NCHAR | String | NCHAR | CHAR |
| NCLOB | Clob | NCLOB | VARCHAR/TEXT |
| NULL | |||
| NUMERIC | BigDecimal | NUMERIC/NUMBER | NUMERIC |
| NVARCHAR | String | VARCHAR | VARCHAR |
| OTHER | |||
| REAL | Float | REAL | REAL |
| REF | Ref | ||
| ROWID | |||
| SMALLINT | Short | SMALLINT | SMALLINT |
| SQLXML | |||
| STRUCT | Struct | ||
| TIME | Time | TIME | TIME |
| TIMESTAMP | Timestamp | TIMESTAMP | TIMESTAMP/DATETIME |
| TINYINT | Byte | TINYINT | TINYINT |
| UNDEFINED | |||
| VARBINARY | Byte[] | VARBINARY | BLOB |
| VARCHAR | String | VARCHAR | VARCHAR |
更多推荐


所有评论(0)