mysql、oracle和java数据类型的对照
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
FLOATFLOAT java.lang.Float
INT NUMBER(10,0) java.lang.Integer
INTEGER NUMBER(10,0) java.lang.Integer
LONGBLOB BLOB RAW byte[]
LONGTEXTCLOB RAW java.lang.String
MEDIUM BLOB BLOB RAW byte[]
MEDIUM INTNUMBER(7,0) java.lang.Integer
MEDIUM TEXT CLOB RAWjava.lang.String
NUMERICNUMBER
REALFLOAT (24)
SETVARCHAR2 java.lang.String
SMALLINTNUMBER(5,0) java.lang.Integer
TEXTVARCHAR2 CLOB java.lang.String
TIMEDATE java.sql.Time
TIMESTAMPDATE java.sql.Timestamp
TINYBLOBRAW byte[]
TINYINTNUMBER(3,0) java.lang.Boolean