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

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值