MySQL\Hibernate\Java数据类型映射关系

类型名称显示长度数据库类型JAVA类型JDBC类型索引(int)描述      VARCHARL+NVARCHARjava.lang.String12 CHARNCHARjava.lang.String1 BLOBL+NBLOBjava.lang.byte[]-4 TEXT65535VARCHARjava.lang.String-1       INTEGER4INTEGER UNSIGNEDjava.lang.Long4 TINYINT3TINYINT UNSIGNEDjava.lang.Integer-6 SMALLINT5SMALLINT UNSIGNEDjava.lang.Integer5 MEDIUMINT8MEDIUMINT UNSIGNEDjava.lang.Integer4 BIT1BITjava.lang.Boolean-7 BIGINT20BIGINT UNSIGNEDjava.math.BigInteger-5 FLOAT4+8FLOATjava.lang.Float7 DOUBLE22DOUBLEjava.lang.Double8 DECIMAL11DECIMALjava.math.BigDecimal3 BOOLEAN1同TINYINT         ID11PK (INTEGER UNSIGNED)java.lang.Long4       DATE10DATEjava.sql.Date91 TIME8TIMEjava.sql.Time92 DATETIME19DATETIMEjava.sql.Timestamp93 TIMESTAMP19TIMESTAMPjava.sql.Timestamp93 YEAR4YEARjava.sql.Date91       

出处：http://database.51cto.com/art/201010/230118.htm

下面是hibernate官方文档给出的映射表：

Table 8.1. Basic Type Mappings

Hibernate typeDatabase typeJDBC typeType registryorg.hibernate.type.StringTypestringVARCHARstring, java.lang.Stringorg.hibernate.type.MaterializedClobstringCLOBmaterialized_cloborg.hibernate.type.TextTypestringLONGVARCHARtextorg.hibernate.type.CharacterTypechar, java.lang.CharacterCHARchar, java.lang.Characterorg.hibernate.type.BooleanTypebooleanBITboolean, java.lang.Booleanorg.hibernate.type.NumericBooleanTypebooleanINTEGER, 0 is false, 1 is truenumeric_booleanorg.hibernate.type.YesNoTypebooleanCHAR, 'N'/'n' is false, 'Y'/'y' is true. The uppercase value is written to the database.yes_noorg.hibernate.type.TrueFalseTypebooleanCHAR, 'F'/'f' is false, 'T'/'t' is true. The uppercase value is written to the database.true_falseorg.hibernate.type.ByteTypebyte, java.lang.ByteTINYINTbyte, java.lang.Byteorg.hibernate.type.ShortTypeshort, java.lang.ShortSMALLINTshort, java.lang.Shortorg.hibernate.type.IntegerTypesint, java.lang.IntegerINTEGERint, java.lang.Integerorg.hibernate.type.LongTypelong, java.lang.LongBIGINTlong, java.lang.Longorg.hibernate.type.FloatTypefloat, java.lang.FloatFLOATfloat, java.lang.Floatorg.hibernate.type.DoubleTypedouble, java.lang.DoubleDOUBLEdouble, java.lang.Doubleorg.hibernate.type.BigIntegerTypejava.math.BigIntegerNUMERICbig_integerorg.hibernate.type.BigDecimalTypejava.math.BigDecimalNUMERICbig_decimal, java.math.bigDecimalorg.hibernate.type.TimestampTypejava.sql.TimestampTIMESTAMPtimestamp, java.sql.Timestamporg.hibernate.type.TimeTypejava.sql.TimeTIMEtime, java.sql.Timeorg.hibernate.type.DateTypejava.sql.DateDATEdate, java.sql.Dateorg.hibernate.type.CalendarTypejava.util.CalendarTIMESTAMPcalendar, java.util.Calendarorg.hibernate.type.CalendarDateTypejava.util.CalendarDATEcalendar_dateorg.hibernate.type.CurrencyTypejava.util.CurrencyVARCHARcurrency, java.util.Currencyorg.hibernate.type.LocaleTypejava.util.LocaleVARCHARlocale, java.utility.localeorg.hibernate.type.TimeZoneTypejava.util.TimeZoneVARCHAR, using the TimeZone IDtimezone, java.util.TimeZoneorg.hibernate.type.UrlTypejava.net.URLVARCHARurl, java.net.URLorg.hibernate.type.ClassTypejava.lang.ClassVARCHAR, using the class nameclass, java.lang.Classorg.hibernate.type.BlobTypejava.sql.BlobBLOBblog, java.sql.Bloborg.hibernate.type.ClobTypejava.sql.ClobCLOBclob, java.sql.Cloborg.hibernate.type.BinaryTypeprimitive byte[]VARBINARYbinary, byte[]org.hibernate.type.MaterializedBlobTypeprimitive byte[]BLOBmaterized_bloborg.hibernate.type.ImageTypeprimitive byte[]LONGVARBINARYimageorg.hibernate.type.BinaryTypejava.lang.Byte[]VARBINARYwrapper-binaryorg.hibernate.type.CharArrayTypechar[]VARCHARcharacters, char[]org.hibernate.type.CharacterArrayTypejava.lang.Character[]VARCHARwrapper-characters, Character[], java.lang.Character[]org.hibernate.type.UUIDBinaryTypejava.util.UUIDBINARYuuid-binary, java.util.UUIDorg.hibernate.type.UUIDCharTypejava.util.UUIDCHAR, can also read VARCHARuuid-charorg.hibernate.type.PostgresUUIDTypejava.util.UUIDPostgreSQL UUID, through Types#OTHER, which complies to the PostgreSQL JDBC driver definitionpg-uuidorg.hibernate.type.SerializableTypeimplementors of java.lang.SerializableVARBINARYUnlike the other value types, multiple instances of this type are registered. It is registered once under java.io.Serializable, and registered under the specific java.io.Serializable implementation class names.