hibernate多对一

SQL语句：

CREATE TABLE TB_DEPARTMENT
(
    ID INTEGER PRIMARY KEY,
    NAME VARCHAR2(20) NOT NULL
);

CREATE SEQUENCE SQ_DEPARTMENT
INCREMENT BY 1
START WITH 1
NOMAXVALUE
NOCYCLE
CACHE 10;

CREATE TABLE TB_EMPLOYEE
(
    ID INTEGER PRIMARY KEY,
    NAME VARCHAR2(20) NOT NULL,
    DEPARTMENT_ID INTEGER NOT NULL REFERENCES TB_DEPARTMENT(ID)
);

CREATE SEQUENCE SQ_EMPLOYEE
INCREMENT BY 1
START WITH 1
NOMAXVALUE
NOCYCLE
CACHE 10;

java代码如下：

package com.employee.pojo;

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;
	}
}

package com.employee.pojo;

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;
	}
}

hbm如下：

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
      "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
          "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">

<hibernate-mapping package="com.employee.pojo">

	<class name="Department" table="tb_department">
		<id name="id" column="id" type="integer">
			<generator class="sequence">
				<param name="sequence">SQ_DEPARTMENT</param>
			</generator>
		</id>
		<property name="name" column="name" type="string" />
	</class>

</hibernate-mapping>

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
      "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
          "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">

<hibernate-mapping package="com.employee.pojo">

	<class name="Employee" table="tb_employee">
		<id name="id" column="id" type="integer">
			<generator class="sequence">
				<param name="sequence">SQ_EMPLOYEE</param>
			</generator>
		</id>
		<property name="name" column="name" type="string" />
		<many-to-one name="department" column="department_id" class="Department" cascade="save-update"></many-to-one>
	</class>

</hibernate-mapping>

hibernate.cfg.xml：

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">

<hibernate-configuration>

	<session-factory>

		<!-- Database connection settings -->
		<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
		<property name="connection.url">jdbc:oracle:thin:@localhost:1521:ORCL</property>
		<property name="connection.username">HIBERNATE</property>
		<property name="connection.password">HIBERNATE</property>

		<property name="connection.pool_size">1</property>

		<property name="dialect">org.hibernate.dialect.Oracle10gDialect</property>

		<property name="show_sql">true</property>

		<property name="hibernate.show_sql">true </property>
		
		<property name="jdbc.fetch_size">50</property>
		
		<mapping resource="com/employee/pojo/Employee.hbm.xml"/>
		<mapping resource="com/employee/pojo/Department.hbm.xml"/>

	</session-factory>

</hibernate-configuration>

测试代码：

package com.employee.pojo.test;

import java.util.ArrayList;
import java.util.List;
import java.util.Random;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

import com.employee.pojo.Department;
import com.employee.pojo.Employee;

import junit.framework.TestCase;

public class TestEmployee extends TestCase {
	private Session session = null;
	
	private static final String cfgName = "/oracle.hibernate.cfg.xml";
	
	private static final SessionFactory factory = new Configuration().configure(cfgName).buildSessionFactory();

	private Transaction tran = null;

	@Override
	protected void setUp() throws Exception {
		session = factory.openSession();
		tran = session.beginTransaction();
	}

	public void testInsert() {
		List<Department> departmentList = new ArrayList<Department>();
		for (int i = 0; i < 3; i++) {
			Department department = new Department();
			department.setName("department_" + i);
			session.save(department);
			departmentList.add(department);
		}
		
		for (int i = 0; i < 10; i++) {
			Employee employee = new Employee();
			employee.setName("employee_" + i);
			int departmentId = i % 3;
			Department department = departmentList.get(departmentId);
			employee.setDepartment(department);
			session.save(employee);
		}
		tran.commit();
	}

	public void testUpdateDepartment() {
		Random random = new Random();
		Department department = new Department();
		department.setId(21);
		department.setName("u_department_" + random.nextInt(10));
		Employee employee = new Employee();
		employee.setId(22);
		employee.setName("u_employee_" + random.nextInt(10));
		employee.setDepartment(department);
		session.saveOrUpdate(employee);
		tran.commit();
	}
	
	@Override
	protected void tearDown() throws Exception {
		tran = null;
		session.close();
		session = null;
	}

}