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>