Mysql |
Oracle |
Java |
BIGINT |
NUMBER(19,0) |
java.lang.Long
|
BIT |
RAW |
byte[]
|
BLOB |
BLOB RAW |
byte[]
|
CHAR |
CHAR |
java.lang.String
|
DATE |
DATE |
java.sql.Date |
DATETIME |
DATE |
java.sql.Timestamp |
DECIMAL |
FLOAT (24) |
java.math.BigDecimal
|
DOUBLE |
FLOAT (24) |
java.lang.Double |
DOUBLE PRECISION |
FLOAT (24) |
java.lang.Double |
ENUM |
VARCHAR2 |
java.lang.String
|
FLOAT |
FLOAT |
java.lang.Float |
INT |
NUMBER(10,0) |
java.lang.Integer
|
INTEGER |
NUMBER(10,0) |
java.lang.Integer
|
LONGBLOB |
BLOB RAW |
byte[] |
LONGTEXT |
CLOB RAW |
java.lang.String |
MEDIUMBLOB |
BLOB RAW |
byte[] |
MEDIUMINT |
NUMBER(7,0) |
java.lang.Integer
|
MEDIUMTEXT |
CLOB RAW |
java.lang.String |
NUMERIC |
NUMBER |
|
REAL |
FLOAT (24) |
|
SET |
VARCHAR2 |
java.lang.String
|
SMALLINT |
NUMBER(5,0) |
java.lang.Integer
|
TEXT |
VARCHAR2 CLOB |
java.lang.String
|
TIME |
DATE |
java.sql.Time |
TIMESTAMP |
DATE |
java.sql.Timestamp |
TINYBLOB |
RAW |
byte[] |
TINYINT |
NUMBER(3,0) |
java.lang.Boolean |
TINYTEXT |
VARCHAR2 |
java.lang.String |
VARCHAR |
VARCHAR2 CLOB |
java.lang.String |
YEAR |
NUMBER |
java.sql.Date(日期設(shè)為2月1日晚上2點) |
|