美文网首页
hibernate和mysql之中的数据类型转换

hibernate和mysql之中的数据类型转换

作者: 可爱傻妞是我的爱 | 来源:发表于2017-07-14 14:13 被阅读518次

    映射类型                   Java类型                          标准SQL字段类型

    integer                      int or java.lang.Integer       INTEGER

    long                           long or java.lang.Long       BIGINT

    short                          short or java.lang.Short      SMALLINT

    float                           float or java.lang.Float         FLOAT

    double                       double or java.lang.Double   DOUBLE

    big_decimal                java.math.BigDecimal          NUMERIC

    character                    java.lang.String                    CHAR(1)

    string                          java.lang.String                   VARCHAR

    byte                            byte or java.lang.Byte         TINYINT

    boolean                      boolean or java.lang.Boolean      BIT

    yes_no                       boolean or java.lang.Boolean          CHAR(1('Y'or'N')

    true_false                   boolean or java.lang.Boolean          CHAR(1)('Y'or'N')

    date                            java.util.Date or java.sql.Date              DATE

    time                            java.util.Date or java.sql.Time            TIME

    timestamp                  java.util.Date or java.sql.Timestamp       TIMESTAMP

    calendar                     java.util.Calendar                                TIMESTAMP

    calendar_datev          java.util.Calendar                                 DATE

    binary                         byte[]                                                        VARBINARY(or BLOB)

    text                             java.lang.String                                         CLOB

    serializable                  java.io.Serializable的任何实例              VARBINARY(or BLOB)

    clob                              java.sql.Clob                                       CLOB

    blob                              java.sql.Blob            BLOB

    class                            java.lang.Class              VARCHAR

    locale                           java.util.Locale              VARCHAR

    timezone                     java.util.TimeZone          VARCHAR

    currency                       java.util.Currency            VARCHAR

    相关文章

      网友评论

          本文标题:hibernate和mysql之中的数据类型转换

          本文链接:https://www.haomeiwen.com/subject/yonnhxtx.html