Many To One关联映射的CURD

 

2张表：Department(部门表),Employee(员工表),结构分别如下。

Department:

int id, varchar(255) name

 

Employee:

int id, varchar(255) name, depart_id

 

多个员工对应一个部分即多对一映射。

 

Domain对象

Department.java public class Department { private int id; private String name; public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } } Employee.java public class Employee { private int id; private String name; private Department department; public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public Department getDepartment() { return department; } public void setDepartment(Department department) { this.department = department; } } 

 

XML配置文件：

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="org.domain"> <class name="Department"> <id name="id"> <generator class="native"/> </id> <property name="name"/> </class> </hibernate-mapping> 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="org.domain"> <class name="Employee"> <id name="id"> <generator class="native"/> </id> <property name="name"/> <many-to-one name="department" column="depart_id" /><!--定义外键--> </class> </hibernate-mapping> 

 

测试文件：

ManyToOneTest.java package test; import org.domain.Department; import org.domain.Employee; import org.hibernate.Hibernate; import org.hibernate.Session; import org.hibernate.Transaction; import org.util.HibernateUtil; public class ManyToOne { /** * @param args */ public static void main(String[] args) { // TODO Auto-generated method stub Session s = null; try{ s = HibernateUtil.getSession(); Transaction tx = s.beginTransaction(); Department depart = new Department(); depart.setName("departName"); Employee em = new Employee(); em.setDepartment(depart); em.setName("test"); s.save(em); s.save(depart); tx.commit(); Employee emp = query(1); System.out.println("name:"+emp.getName()); System.out.println("depart name:" + emp.getDepartment().getName()); }finally{ if(s!=null) s.close(); } } public static Employee query(int emp_id){ Session s = null; try{ s = HibernateUtil.getSession(); Transaction tx = s.beginTransaction(); Employee emp = (Employee)s.get(Employee.class, emp_id); //System.out.println("depart name:" + emp.getDepartment().getName()); Hibernate.initialize(emp.getDepartment());//使用懒加载 tx.commit(); return emp; }finally{ if(s != null) s.close(); } } }