Hibernate-Java-MySql
Hibernate映射类型 | Java字段(属性)类型 | MySql字段类型 |
integer 或者 int | 或者 java.lang.Integer | INTEGER |
long | long Long | BIGINT |
shortt | short Short | SMALLINT |
byte | byte Byte | TINYINT |
float | float Float | FLOAT |
double | double Double | DOUBLE |
big_decimal | java.math.BigDecimal | NUMERIC |
character | char Character String | CHAR(1) |
string | String | VARCHAR |
boolean | boolean Boolean | BIT |
yes_no | boolean Boolean | CHAR(1) (Y-N) |
true_false | boolean Boolean | CHAR(1) (T-F) |
timestamp | Date | Date |
date | util.Date 或者 sql.Date | Date |
time | util.Date/java.sql.TIme | TIME |
如下代码以及映射:
/**
* 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>