來源：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

 

 

arrow
arrow
    全站熱搜

    Robert 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄