二、hibernate一对多关联-CSDN博客

本文链接：https://blog.csdn.net/lvkeyxx/article/details/77150808

工具：MyEclipse 2015

1.导入Hibernate核心jar包（传送门）

2.导入MySQL数据库连接驱动（传送门）

3.创建Hibernate核心配置文件 hibernate.cfg.xml（创建方法传送门）

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
 
<hibernate-configuration>
    <session-factory>
        <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="hibernate.connection.url">
        	<![CDATA[
        		jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=UTF-8
        	]]>
        </property>
        <property name="hibernate.connection.username">root</property>
        <property name="hibernate.connection.password">111111</property>
        <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
        <property name="hibernate.hbm2ddl.auto">update</property>
        
        <property name="show_sql">true</property>
        <property name="format_sql">true</property>
        <!-- 指定对象关系映射文件的路径 -->
        <mapping resource="net/nxfengshang/entity/Grade.hbm.xml"/>
        <mapping resource="net/nxfengshang/entity/Student.hbm.xml"/>
    </session-factory>
</hibernate-configuration>

4.创建班级实体类：Grade.java

package net.nxfengshang.entity;

import java.io.Serializable;
import java.util.HashSet;
import java.util.Set;

public class Grade implements Serializable {

	private int gid;
	private String gname;
	private String gdesc;
	private Set<Student> students = new HashSet<Student>();

	public int getGid() {
		return gid;
	}

	public void setGid(int gid) {
		this.gid = gid;
	}

	public String getGname() {
		return gname;
	}

	public void setGname(String gname) {
		this.gname = gname;
	}

	public String getGdesc() {
		return gdesc;
	}

	public void setGdesc(String gdesc) {
		this.gdesc = gdesc;
	}

	public Set<Student> getStudents() {
		return students;
	}

	public void setStudents(Set<Student> students) {
		this.students = students;
	}

	public Grade(String gname, String gdesc) {
		super();
		this.gname = gname;
		this.gdesc = gdesc;
	}

	public Grade(int gid, String gname, String gdesc, Set<Student> students) {
		super();
		this.gid = gid;
		this.gname = gname;
		this.gdesc = gdesc;
		this.students = students;
	}

	public Grade() {
		super();
	}

}

5.创建学生实体类：Student.java

package net.nxfengshang.entity;

import java.io.Serializable;

public class Student implements Serializable {

	private int sid;
	private String sname;
	private String sex;

	public int getSid() {
		return sid;
	}

	public void setSid(int sid) {
		this.sid = sid;
	}

	public String getSname() {
		return sname;
	}

	public void setSname(String sname) {
		this.sname = sname;
	}

	public String getSex() {
		return sex;
	}

	public void setSex(String sex) {
		this.sex = sex;
	}

	public Student(String sname, String sex) {
		super();
		this.sname = sname;
		this.sex = sex;
	}

	public Student(int sid, String sname, String sex) {
		super();
		this.sid = sid;
		this.sname = sname;
		this.sex = sex;
	}

	public Student() {
		super();
	}

}

6.创建班级对象映射文件：Grade.hbm.xml

<?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>
	<class name="net.nxfengshang.entity.Grade" table="grade">
		<id name="gid" column="gid" type="java.lang.Integer">
			<generator class="increment"></generator>
		</id>
		<property name="gname" type="java.lang.String">
			<column name="gname" length="20" not-null="true"></column>
		</property>
		<property name="gdesc">
			<column name="gdesc"></column>
		</property>
		<!-- 配置单项的一对多关联关系 -->
		<set name="students" table="Student">
			<!-- 指定关联的外检列 -->
			<key column="gid"></key>
			<one-to-many class="net.nxfengshang.entity.Student"/>
		</set>
	</class>
</hibernate-mapping>

7.创建学生对象映射文件：Student.hbm.xml

<?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>
	<class name="net.nxfengshang.entity.Student" table="student">
		<id name="sid" column="sid" type="java.lang.Integer">
			<generator class="increment"></generator>
		</id>
		<property name="sname" type="java.lang.String">
			<column name="sname" length="20" not-null="true"></column>
		</property>
		<property name="sex">
			<column name="sex"></column>
		</property>
	</class>
</hibernate-mapping>

8.创建HibernateUtil工具类：HibernateUtil.java

package net.nxfengshang.util;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.boot.registry.StandardServiceRegistry;
import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
import org.hibernate.cfg.Configuration;

public class HibernateUtil {

	private static SessionFactory sessionFactory;
	private static Session session;
	
	static{
		//创建Configuration对象，读取hibernate.cfg.xml文件，完成初始化
		Configuration config = new Configuration().configure();
		StandardServiceRegistryBuilder ssrb = new StandardServiceRegistryBuilder().applySettings(config.getProperties());
		StandardServiceRegistry ssr = ssrb.build();
		sessionFactory = config.buildSessionFactory(ssr);
	}
	
	//获取sessionFactory
	public static SessionFactory getSessionFactory(){
		return sessionFactory;
	}
	//获取Session
	public static Session getSession(){
		session = sessionFactory.openSession();
		return session;
	}
	//关闭session
	public static void closeSession(Session session){
		if(session != null){
			session.close();
		}
	}
}

9.创建数据库表：

create table grade(
	gid int primary key,
	gname varchar(20) not null,
	gdesc varchar(50)  
);

create table student(
	sid int primary key,
	sname varchar(20) not null,
	sex char(2),
	gid int
);
alter table student add constraint fk_Student_gid foreign key(gid) references grade(gid);

10.创建测试类：Test.java

package net.nxfengshang.entity;

import java.util.Set;

import net.nxfengshang.util.HibernateUtil;

import org.hibernate.Session;
import org.hibernate.Transaction;

/**
 * 单向的一对多关联关系（班级-->学生）
 * @author yangxx
 *
 */
public class Test {
	
	public static void main(String []args){
		//add();
		//findStudentsByGrade();
		//update();
		delete();
	}
	//将学生添加到班级
	public static void add(){
		Grade grade = new Grade("java一班","java开发一班");
		Student stu1 = new Student("张三","男");
		Student stu2 = new Student("女神","女");
		
		grade.getStudents().add(stu1);
		grade.getStudents().add(stu2);
		
		Session session = HibernateUtil.getSession();
		Transaction tx = session.beginTransaction();
		session.save(grade);
		session.save(stu1);
		session.save(stu2);
		tx.commit();
		HibernateUtil.closeSession(session);
	}
	//通过班级查询学生信息
	public static void findStudentsByGrade(){
		Session session = HibernateUtil.getSession();
		Grade grade = (Grade) session.get(Grade.class, 1);
		System.out.println(grade.getGname()+","+grade.getGdesc());
		
		Set<Student> students = grade.getStudents();
		for(Student stu:students){
			System.out.println(stu.getSname()+","+stu.getSex());
		}
	}
	//修改学生信息
	public static void update(){
		Grade grade = new Grade("java二班","java开发二班");
		Session session = HibernateUtil.getSession();
		Transaction tx = session.beginTransaction();
		Student stu = (Student)session.get(Student.class, 1);
		grade.getStudents().add(stu);
		session.save(grade);
		tx.commit();
		HibernateUtil.closeSession(session);
	}
	//删除学生信息
	public static void delete(){
		Session session = HibernateUtil.getSession();
		Transaction tx = session.beginTransaction();
		Student stu = (Student) session.get(Student.class, 2);
		session.delete(stu);
		tx.commit();
		HibernateUtil.closeSession(session);
	}
}

多对一和多对多只需修改配置文件及实体类

学习记录