JAVA数据类型与MySQL数据类型对照
MySQL数据类型: | Java数据类型: |
VARCHAR | String |
CHAR | String |
BLOB | byte[] |
VARCHAR | String |
INTEGER UNSIGNED | Long |
TINYINT UNSIGNED | Integer |
SMALLINT UNSIGNED | Integer |
MEDIUMINT UNSIGNED | Integer |
BIT | Boolean |
BIGINT UNSIGNED | BigInteger |
FLOAT | Float |
DOUBLE | Double |
DECIMAL | BigDecimal |
PK (INTEGER UNSIGNED) | Long |
DATE | Date |
TIME | Time |
DATETIME | Timestamp |
TIMESTAMP | Timestamp |
YEAR | Date |