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
全站熱搜
留言列表