Hibernate-java-sql 三者的数据类型对照

Hibernate--java--sql 三者的数据类型对比

Java数据类型                             Hibernate数据类型             标准SQL数据类型(对于不同的DB可能有所差异)
byte、java.lang.Byte                  byte                                      TINYINT
short、java.lang.Short                short                                    SMALLINT
int、 java.lang.Integer                integer                                  INGEGER
long、java.lang.Long                   long                                      BIGINT
float、 java.lang.Float                 float                                      FLOAT
double、 java.lang.Double          double                                  DOUBLE
java.math.BigDecimal                 big_decimal                         NUMERIC
char、java.lang.Character          character                             CHAR(1)
boolean、java.lang.Boolean       boolean                                BIT
java.lang.String                             string                                    VARCHAR
boolean、java.lang.Boolean       yes_no                                 CHAR(1)('Y'或'N')
boolean、java.lang.Boolean       true_false                            CHAR(1)('Y'或'N')
java.util.Date、java.sql.Date      date                                      DATE
java.util.Date、java.sql.Time      time                                     TIME

java.util.Date、java.sql.Timestamp      timestamp             TIMESTAMP
java.util.Calendar                       calendar                                TIMESTAMP
java.util.Calendar                       calendar_date                      DATE
byte[]                                             binary                                   VARBINARY、BLOB
java.lang.String                           text                                        CLOB
java.io.Serializable                      serializable                          VARBINARY、BLOB
java.sql.Clob                                clob                                         CLOB
java.sql.Blob                                blob                                         BLOB
java.lang.Class                           class                                        VARCHAR
java.util.Locale                            locale                                     VARCHAR
java.util.TimeZone                      timezone                               VARCHAR
java.util.Currency                       currency                                VARCHAR