close
來源:Mapping SQL and Java Data Types
沒時間整理...
The following table shows the mapping between SQL and Java data types. They are from JDBC.
| SQL data type | Java data type | |
|---|---|---|
| Simply mappable | Object mappable | |
| CHARACTER | String | |
| VARCHAR | String | |
| LONGVARCHAR | String | |
| NUMERIC | java.math.BigDecimal | |
| DECIMAL | java.math.BigDecimal | |
| BIT | boolean | Boolean |
| TINYINT | byte | Integer |
| SMALLINT | short | Integer |
| INTEGER | int | Integer |
| BIGINT | long | Long |
| REAL | float | Float |
| FLOAT | double | Double |
| DOUBLE PRECISION | double | Double |
| BINARY | byte[] | |
| VARBINARY | byte[] | |
| LONGVARBINARY | byte[] | |
| DATE | java.sql.Date | |
| TIME | java.sql.Time | |
| TIMESTAMP | java.sql.Timestamp | |
Related Articles
More on the general topic: SQLJ
全站熱搜
留言列表