Hibernate映射文件中对应的mysql数据库表字段的类型

xiaoxiao2021-02-28  75

根据java类中的属性建Hibernate映射文件映射到mysql数据库中,有些属性、映射类型拿不准,就顺便查查资料总结了一下有关知识:

                                                        Hibernate-Java-MySql

Hibernate映射类型Java字段(属性)类型MySql字段类型integer 或者 int或者 java.lang.IntegerINTEGERlonglong  LongBIGINTshorttshort  ShortSMALLINTbytebyte  ByteTINYINTfloatfloat  FloatFLOATdoubledouble  DoubleDOUBLEbig_decimaljava.math.BigDecimalNUMERICcharacterchar  Character  StringCHAR(1)stringStringVARCHARbooleanboolean  BooleanBITyes_noboolean  BooleanCHAR(1) (Y-N)true_falseboolean  BooleanCHAR(1) (T-F)timestampDateDatedateutil.Date 或者 sql.DateDatetimeutil.Date/java.sql.TImeTIME

如下代码以及映射:

/**

 * java代码

 */

 public class Test

{

   private Long id;     private Integer state;         private String startMemberId;     private Date startDate;     private String approveMemberId;

    private Date approveDate;     private Integer finishedflag;     private Integer ratifyflag;

    private String ratifyMemberId;     private Date ratifyDate;     private Integer sort;     private String modifyMemberId;     private Date modifyDate;

    /**

     *省略get和set方法

      *//

}

<id name="id" type="long" column="id" length="20">             <generator class="assigned" /><!-- 用户自定义id -->         </id>         <property name="state" column="state" type="integer"></property>         <property name="startMemberId" column="" type="string"></property>         <property name="startDate" type="timestamp">             <column name="start_member_id"/>         </property>         <property name="approveMemberId" column="approve_member_id" type="string"></property>         <property name="approveDate" type="timestamp">             <column name="approve_date"></column>         </property>         <property name="finishedflag" column="finishedflag" type="integer"></property>         <property name="ratifyflag" column="ratifyflag" type="integer"></property>         <property name="ratifyMemberId" column="ratifyMemberId" type="string"></property>         <property name="ratifyDate" type="timestamp">             <column name="ratify_date"></column>         </property>         <property name="sort" column="sort" type="integer"></property>         <property name="modifyMemberId" column="modify_member_id" type="string"></property>         <property name="modifyDate" type="timestamp">             <column name="modify_date"></column>         </property>

转载请注明原文地址: https://www.6miu.com/read-42628.html

最新回复(0)