Hibernate 数据库字段映射类型Hibernate 数据库字段映射类型

  <property name="img" type="java.lang.String">           <column name="IMG" />        </property>

 

 映射文件中的type

Hibernate 映射类型    java 类型                                    标准 sql 类型 

integer                int or 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_date          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