Java数据类型与SQL数据类型的映射
SQL Data Type | Java Data Type |
char/varchar/longvarchar | String |
numeric/decimal | java.math.BigDecimal |
bit | boolean |
tinyint | byte |
smallint | short |
integer | int |
bigint | long |
real | float |
float/double | double |
binary/varbinary/longvarbinary | byte[] |
date | java.sql.Date |
time | java.sql.Time |
timestamp | java.sql.Timestamp |
|
|