- 数据库类型和mapper中jdbc对应的类型
数据库类型 | java数据类型 | jdbc Type类型 |
---|---|---|
bigint | Long | BIGINT |
tinyint | Byte | TINYINT |
smallint | Short | SMALLINT |
mediumint | Integer | INTEGER |
integer | Integer | INTEGER |
int | Integer | INTEGER |
float | Float | REAL |
double | Double | DOUBLE |
decimal | BigDecimal | DECIMAL |
numeric | BigDecimal | DECIMAL |
char | String | CHAR |
varchar | String | VARCHAR |
tinyblob | DataTypeWithBLOBs.byte[] | BINARY |
tinytext | String | VARCHAR |
blob | DataTypeWithBLOBs.byte[] | BINARY |
text | DataTypeWithBLOBs.String | LONGVARCHAR |
mediumblob | DataTypeWithBLOBs.byte[] | LONGVARBINARY |
mediumtext | DataTypeWithBLOBs.String | LONGVARCHAR |
longblob | DataTypeWithBLOBs.byte[] | LONGVARBINARY |
longtext | DataTypeWithBLOBs.String | LONGVARCHAR |
date | Date | DATE |
time | Date | TIME |
year | Date | DATE |
datetime | Date | TIMESTAMP |
timestamp | Date | TIMESTAMP |