创建部门表department
创建雇员表employee
新建持久化类
Department.java
- package www.hbsi.net.many2one;
- public class Department {
- private Integer id;
- private String name;
- public Integer getId() {
- return this.id;
- }
- public void setId(Integer id) {
- this.id = id;
- }
- public String getName() {
- return this.name;
- }
- public void setName(String name) {
- this.name = name;
- }
- }
Employee.java
- package www.hbsi.net.many2one;
- public class Employee {
- private Integer id;
- private Department department;//反应了对象之间的关系
- private String username;
- public Integer getId() {
- return this.id;
- }
- public void setId(Integer id) {
- this.id = id;
- }
- public Department getDepartment() {
- return this.department;
- }
- public void setDepartment(Department department) {
- this.department = department;
- }
- public String getUsername() {
- return this.username;
- }
- public void setUsername(String username) {
- this.username = username;
- }
- }
新建映射文件
Department.hbm.xml
- <?xml version="1.0" encoding="utf-8"?>
- <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
- "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
- <hibernate-mapping package="www.hbsi.net.many2one">
- <class name="Department" table="department" catalog="hibernate">
- <id name="id" type="java.lang.Integer">
- <column name="id" />
- <generator class="native" />
- </id>
- <property name="name" column ="name" type="string" />
- </class>
- </hibernate-mapping>
Employee.hbm.xml
- <?xml version="1.0" encoding="utf-8"?>
- <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
- "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
- <hibernate-mapping package="www.hbsi.net.many2one">
- <class name="Employee" table="employee">
- <id name="id" type="java.lang.Integer">
- <column name="id" />
- <generator class="native" />
- </id>
- <property name="username" type="string" column ="username" />
- <many-to-one name="department" column ="dept_id" />
- </class>
- </hibernate-mapping>
更改hibernate映射问价的mapping属性
hibernate.cfg.xml;
- <?xml version='1.0' encoding='UTF-8'?>
- <!DOCTYPE hibernate-configuration PUBLIC
- "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
- "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
- <!-- Generated by MyEclipse Hibernate Tools. -->
- <hibernate-configuration>
- <session-factory>
- <property name="dialect">
- org.hibernate.dialect.MySQLDialect
- </property>
- <property name="connection.url">
- jdbc:mysql://localhost:3306/hibernate
- </property>
- <property name="connection.username">root</property>
- <property name="connection.password">123456</property>
- <property name="connection.driver_class">
- com.mysql.jdbc.Driver
- </property>
- <property name="show_sql">true</property>
- <property name="hbm2ddl.auto">update</property>
- <mapping resource="www/hbsi/net/many2one/Department.hbm.xml" />
- <mapping resource="www/hbsi/net/many2one/Employee.hbm.xml" />
- </session-factory>
- </hibernate-configuration>
创建测试类
Many2one.java
- package www.hbsi.net.many2one;
- import javax.persistence.Temporal;
- import org.hibernate.Session;
- import org.junit.Test;
- import www.hbsi.net.util.HibernateSessionFactory;
- public class Many2one {
- @Test
- public void add(){
- Session session = HibernateSessionFactory.getSession();
- session.beginTransaction();
- Department department = new Department();
- department.setName("软件系");
- Employee employee1 = new Employee();
- employee1.setUsername("Nacy");
- employee1.setDepartment(department);
- Employee employee2 = new Employee();
- employee2.setUsername("Tom");
- employee2.setDepartment(department);
- session .save(department);
- session .save(employee1);
- session .save(employee2);
- session.getTransaction().commit();
- HibernateSessionFactory.closeSession();
- }
- }
控制台输出:
department表
employee表
查找:
Many2one.java
- /**
- * 先保存部门在保存雇员
- * 一般推荐这种方法
- */
- package www.hbsi.net.many2one;
- import org.hibernate.Session;
- import org.junit.Test;
- import www.hbsi.net.util.HibernateSessionFactory;
- public class Many2one {
- @Test
- public void add(){
- Session session = HibernateSessionFactory.getSession();
- session.beginTransaction();
- Department department = new Department();
- department.setName("软件系");
- Employee employee1 = new Employee();
- employee1.setUsername("Nacy");
- employee1.setDepartment(department);
- Employee employee2 = new Employee();
- employee2.setUsername("Tom");
- employee2.setDepartment(department);
- session .save(department);
- session .save(employee1);
- session .save(employee2);
- session.getTransaction().commit();
- HibernateSessionFactory.closeSession();
- }
- /**
- * 通过雇员ID查找所属部门
- */
- @Test
- public void find() {
- Session session = HibernateSessionFactory.getSession();
- session.beginTransaction();
- Employee employee = (Employee) session.get(Employee.class, 5);
- System.out.println(employee.getUsername()+"--"+employee.getDepartment().getName());
- session.getTransaction().commit();
- HibernateSessionFactory.closeSession();
- }
- }