SQL Data Type 與 Java class 對應表
SQL Type Java class
-------------------------------------------
CHAR java.lang.String
-------------------------------------------
VARCHAR java.lang.String
-------------------------------------------
LONG VARCHAR java.lang.String
-------------------------------------------
INTEGER java.lang.Integer
-------------------------------------------
TINYINT java.lang.Integer
-------------------------------------------
SMALLINT java.lang.Short
-------------------------------------------
DECIMAL java.math.BigDecimal
-------------------------------------------
NUMERIC java.math.BigDecimal
-------------------------------------------
BIT java.math.Boolean
-------------------------------------------
BIGINT java.lang.Long
-------------------------------------------
REAL java.lang.Float
-------------------------------------------
FLOAT java.lang.Double
-------------------------------------------
DOUBLE java.lang.Double
-------------------------------------------
BINARY java.lang.byte[]
-------------------------------------------
VARBINARY java.lang.byte[]
-------------------------------------------
LONGVARBINARY java.lang.byte[]
-------------------------------------------
DATE java.sql.Date
-------------------------------------------
TIME java.sql.Time
-------------------------------------------
TIMESTAMP java.sql.Timestamp
SQL Type Java class
-------------------------------------------
CHAR java.lang.String
-------------------------------------------
VARCHAR java.lang.String
-------------------------------------------
LONG VARCHAR java.lang.String
-------------------------------------------
INTEGER java.lang.Integer
-------------------------------------------
TINYINT java.lang.Integer
-------------------------------------------
SMALLINT java.lang.Short
-------------------------------------------
DECIMAL java.math.BigDecimal
-------------------------------------------
NUMERIC java.math.BigDecimal
-------------------------------------------
BIT java.math.Boolean
-------------------------------------------
BIGINT java.lang.Long
-------------------------------------------
REAL java.lang.Float
-------------------------------------------
FLOAT java.lang.Double
-------------------------------------------
DOUBLE java.lang.Double
-------------------------------------------
BINARY java.lang.byte[]
-------------------------------------------
VARBINARY java.lang.byte[]
-------------------------------------------
LONGVARBINARY java.lang.byte[]
-------------------------------------------
DATE java.sql.Date
-------------------------------------------
TIME java.sql.Time
-------------------------------------------
TIMESTAMP java.sql.Timestamp
全站熱搜
留言列表