一对多也是分为两种：
- 单向一对多
- 双向一对多
先来看一下公用的实体类
classes实体类
package entity;
import java.util.Set;
public class Classes {
private int id;
private String className;
private Set<Student> student;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getClassName() {
return className;
}
public void setClassName(String className) {
this.className = className;
}
public Set<Student> getStudent() {
return student;
}
public void setStudent(Set<Student> student) {
this.student = student;
}
}
student实体类（单向的时候没有class这个属性）
package entity;
public class Student {
private int id;
private String name;
private Classes classes;
public Classes getClasses() {
return classes;
}
public void setClasses(Classes classes) {
this.classes = classes;
}
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;
}
}
单向一对多
classes.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="entity">
<class name="Classes" dynamic-update="true" >
<id name="id">
<generator class="native"/>
</id>
<property name="className" />
<set name="student" cascade="delete">
<!-- 这里的column是指数据库中student表中会添加外键classid，关联classes表的主键 -->
<key column="classid"></key>
<one-to-many class="Student" />
</set>
</class>
</hibernate-mapping>
student.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="entity">
<class name="Student" dynamic-update="true">
<id name="id">
<generator class="native"/>
</id>
<property name="name" />
</class>
</hibernate-mapping>
单元测试：
package entity;
import java.util.ArrayList;
import java.util.HashSet;
import java.util.Iterator;
import java.util.Set;
import org.hibernate.classic.Session;
import junit.framework.TestCase;
import util.hibernateUtil;
/**
* 单向一对多（项目名称写错了，应该是一对多）
* 测试目的：
* 1. 新增数据，是否会级联保存？什么时候发出sql语句？
* 2. 查询数据，会不会级联查询？
* 3. 删除数据，会不会级联删除？
* @author arkulo
*
*/
public class testManytoone extends TestCase {
// 新增数据
public void test1() {
Session session = null;
try {
session = hibernateUtil.getSession();
session.beginTransaction();
Student st1 = new Student();
st1.setName("张三");
Student st2 = new Student();
st2.setName("李四");
Student st3 = new Student();
st3.setName("王五");
// 这里必须先保存三个student，否则它们没有ID，最后会抛异常
// 这是sql执行的顺序
// Hibernate: insert into Student (name) values (?)
// Hibernate: insert into Student (name) values (?)
// Hibernate: insert into Student (name) values (?)
// Hibernate: insert into Classes (className) values (?)
// Hibernate: update Student set classid=? where id=?
// Hibernate: update Student set classid=? where id=?
// Hibernate: update Student set classid=? where id=?
session.save(st1);
session.save(st2);
session.save(st3);
// 这属于在one的一方维护关系
Set<Student> set = new HashSet<Student>();
set.add(st1);
set.add(st2);
set.add(st3);
Classes cl = new Classes();
cl.setClassName("一年级三班");
cl.setStudent(set);
session.save(cl);
session.getTransaction().commit();
} catch (Exception e) {
e.printStackTrace();
session.getTransaction().rollback();
} finally {
hibernateUtil.closeSession(session);
}
}
// 查询数据
public void test2() {
test1();
System.out.println("-------------------------------------------------");
Session session = null;
try {
session = hibernateUtil.getSession();
session.beginTransaction();
// 发出两条sql语句
// 如果没有缓存的情况下，这里的iterate会产生n+1问题
Iterator st = session.createQuery("from Classes").iterate();
while (st.hasNext()) {
Classes cl = (Classes) st.next();
System.out.println("班级：" + cl.getClassName());
Set<Student> students = cl.getStudent();
Iterator<Student> it = students.iterator();
while (it.hasNext()) {
Student s = it.next();
System.out.println("用户名：" + s.getName());
}
}
session.getTransaction().commit();
} catch (Exception e) {
e.printStackTrace();
session.getTransaction().rollback();
} finally {
hibernateUtil.closeSession(session);
}
}
// 删除数据
public void test3() {
test1();
System.out.println("-------------------------------------------------");
Session session = null;
try {
session = hibernateUtil.getSession();
session.beginTransaction();
// 再不设置级联的情况下，删除classes，是否会删除student的记录
Classes cl = (Classes) session.get(Classes.class, 1);
System.out.println("班级名称:" + cl.getClassName());
Set<Student> students = cl.getStudent();
Iterator<Student> it = students.iterator();
while (it.hasNext()) {
Student s = it.next();
System.out.println("学生姓名：" + s.getName());
}
System.out.println("------------------------------------------");
// 不设置级联关系为delete的情况下，删除classes，会自动的把student表中的classid字段设置为null
// 设置级联关系为delete后，sql语句顺序为下：
// Hibernate: update Student set classid=null where classid=?
// Hibernate: delete from Student where id=?
// Hibernate: delete from Student where id=?
// Hibernate: delete from Student where id=?
// Hibernate: delete from Classes where id=?
// 可以看出，即使设置了级联为delete，也会先更新classid字段为null，然后在删除student，最后删除classes
session.delete(cl);
session.getTransaction().commit();
} catch (Exception e) {
e.printStackTrace();
session.getTransaction().rollback();
} finally {
hibernateUtil.closeSession(session);
}
}
}
双向一对多
classes.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="entity">
<class name="Classes" dynamic-update="true" >
<id name="id">
<generator class="native"/>
</id>
<property name="className" />
<set name="student" cascade="delete" inverse="true">
<!-- 这里的column是指数据库中student表中会添加外键classid，关联classes表的主键 -->
<key column="classid"></key>
<one-to-many class="Student" />
</set>
</class>
</hibernate-mapping>
student.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="entity">
<class name="Student" dynamic-update="true">
<id name="id">
<generator class="native"/>
</id>
<property name="name" />
<many-to-one name="classes" column="classid"></many-to-one>
</class>
</hibernate-mapping>
单元测试：
package entity;
import java.util.ArrayList;
import java.util.HashSet;
import java.util.Iterator;
import java.util.Set;
import org.hibernate.classic.Session;
import junit.framework.TestCase;
import util.hibernateUtil;
/**
* 双向一对多（一般情况下，不推荐在one的一方维护关系）
*
* 测试目的
* 0. 使many方的设置失效，由one方维护关系
* 1. 新增数据，是否会级联保存？什么时候发出sql语句？
* 2. 查询数据，会不会级联查询？
* 3. 删除数据，会不会级联删除？
* @author arkulo
*
*/
public class testManytoone extends TestCase {
// 新增数据
public void test1() {
Session session = null;
try {
session = hibernateUtil.getSession();
session.beginTransaction();
Classes cl = new Classes();
cl.setClassName("一年级三班");
session.save(cl);
// 这是在many端维护的关系，比较简单，起码不用中间还需要一个set集合
Student st1 = new Student();
st1.setName("张三");
st1.setClasses(cl);
session.save(st1);
session.getTransaction().commit();
} catch (Exception e) {
e.printStackTrace();
session.getTransaction().rollback();
} finally {
hibernateUtil.closeSession(session);
}
}
// 查询数据
public void test2() {
test1();
System.out.println("-------------------------------------------------");
Session session = null;
try {
session = hibernateUtil.getSession();
session.beginTransaction();
// 发出两条sql语句
// 如果没有缓存的情况下，这里的iterate会产生n+1问题
Iterator st = session.createQuery("from Classes").iterate();
while (st.hasNext()) {
Classes cl = (Classes) st.next();
System.out.println("班级：" + cl.getClassName());
Set<Student> students = cl.getStudent();
Iterator<Student> it = students.iterator();
while (it.hasNext()) {
Student s = it.next();
System.out.println("用户名：" + s.getName());
}
}
session.getTransaction().commit();
} catch (Exception e) {
e.printStackTrace();
session.getTransaction().rollback();
} finally {
hibernateUtil.closeSession(session);
}
}
// 删除数据
public void test3() {
test1();
System.out.println("-------------------------------------------------");
Session session = null;
try {
session = hibernateUtil.getSession();
session.beginTransaction();
// 再不设置级联的情况下，删除classes，是否会删除student的记录
Classes cl = (Classes) session.get(Classes.class, 1);
System.out.println("班级名称:" + cl.getClassName());
Set<Student> students = cl.getStudent();
Iterator<Student> it = students.iterator();
while (it.hasNext()) {
Student s = it.next();
System.out.println("学生姓名：" + s.getName());
}
System.out.println("------------------------------------------");
// 不设置级联关系为delete的情况下，删除classes，系统会提示外键关联并抛出异常
// 在student映射文件上设置级联为delete，系统也会报错，因为这里我们删除的是classes
// 在classes上设置级联关系为delete后，sql语句顺序为下：
// Hibernate: delete from Student where id=?
// Hibernate: delete from Classes where id=?
// 这样就实现了级联删除
session.delete(cl);
session.getTransaction().commit();
} catch (Exception e) {
e.printStackTrace();
session.getTransaction().rollback();
} finally {
hibernateUtil.closeSession(session);
}
}
}
网友评论