一、涉及的两张表。
1、员工表(序号、员工编号、姓名、密码、部门)??????????????
???????????????????????????? ??? tbl_employee(nativeId,employeeId,employeeName,password,department)
2、部门表(序号、部门编号、部门名、部门信息、部门成员)
????????????????????????????? tbl_department(nativeId,departmentId,departmentName,departmentinfo,employeeList)
?
注:序号标识唯一性,这里采用native生成方式。
?
二、基本类。
1、Employee.java
?
public class Employee { private int nativeId; private String employeeId; private String employeeName; private String password; private Department department; getters and setters... }
?
2、Department.java
?
public class Department { private int nativeId; private String departmentId; private String departmentName; private String departmentinfo; private Set<Employee>employeeList; getters and setters... }
?注:private Set<Employee>employeeList;采用了Set 而非ArrayList。
?
三、Hibernate的映射配置(*.hbm.xml)。?
为看得清楚,将其配置文件分开。
1、Employee.hbm.xml
?
?
<?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping package="wuyechun.studymvc.model"> <class name="Employee" table="tbl_employee"> <id name="nativeId"> <generator class="native"></generator> </id> <property name="employeeId"></property> <property name="employeeName"></property> <property name="password"></property> <many-to-one name="department" column="departmentId" cascade="save-update"></many-to-one> </class> </hibernate-mapping>
?
?2、Department.hbm.xml
?
<?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping package="wuyechun.studymvc.model"> <class name="Department" table="tbl_department"> <id name="nativeId"> <generator class="native"></generator> </id> <property name="departmentId"></property> <property name="departmentName"></property> <property name="departmentinfo"></property> <set name="employeeList" > <key column="departmentId"></key> <one-to-many class="Employee"/> </set> </class> </hibernate-mapping>
?以上为基本类和数据库的映射文件,注意 many-to-one? 和 one-to-many 的配置。如不指定column属性(数据库字段名),默认为class属性名和数据库字段名一样,也可另指定columu属性。
?
?
四、自动生成的表结构。
1、tbl_employee
?
2、tbl_department
?
注:只有tbl_employee表中含有 departmentId 字段标示两张表的映射关系。
?
ps:仅作记录,方便自己翻阅。如果对你有所帮助,不甚荣幸。