过一下hibernate4-5

16 篇文章 0 订阅
一. 类继承关系映射到数据库
  1. 主配置文件
    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>

        <!--数据库连接设置 -->
        <property name="connection.driver_class">com.mysql.jdbc.Driver</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="dialect">org.hibernate.dialect.MySQL5Dialect</property>
	
        <!-- 控制台显示SQL -->
        <property name="show_sql">true</property>

        <!-- 自动更新表结构 -->
        <property name="hbm2ddl.auto">update</property>
        
        <!-- 每个具体类对应一个表 -->
  		<mapping resource="com/bee/model/Student.hbm.xml"/>
  		<mapping resource="com/bee/model/LifeImage.hbm.xml"/>
  		<mapping resource="com/bee/model/WorkImage.hbm.xml"/>
  		
  		<!-- 根类对应一个表 -->
  		<mapping resource="com/bee/model/Student2.hbm.xml"/>
  		<mapping resource="com/bee/model/Image2.hbm.xml"/>
  		
  		<!-- 每个类对应一个表 -->
  		<mapping resource="com/bee/model/Student3.hbm.xml"/>
  		<mapping resource="com/bee/model/Image3.hbm.xml"/>

    </session-factory>

</hibernate-configuration>
  1. 类映射
  • 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 package="com.bee.model">

	<class name="Student" table="t_student">
		<id name="id" column="stuId">
			<generator class="native"></generator>
		</id>
		
		<property name="name" column="stuName"></property>
	</class>

</hibernate-mapping>
  • LifeImage.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 package="com.bee.model">

	<class name="LifeImage" table="t_lifeImage">
		<id name="id" column="lifeImageId">
			<generator class="native"></generator>
		</id>
		
		<property name="imageName" column="imageName"></property>
		
		<many-to-one name="student" column="stuId" class="com.bee.model.Student"></many-to-one>
	</class>

</hibernate-mapping>
  • WorkImage.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 package="com.bee.model">

	<class name="WorkImage" table="t_workImage">
		<id name="id" column="workImageId">
			<generator class="native"></generator>
		</id>
		
		<property name="imageName" column="imageName"></property>
		
		<many-to-one name="student" column="stuId" class="com.bee.model.Student"></many-to-one>
	</class>

</hibernate-mapping>
  • Student2.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 package="com.bee.model">

	<class name="Student2" table="t_student2">
		<id name="id" column="stuId">
			<generator class="native"></generator>
		</id>
		
		<property name="name" column="stuName"></property>
		
		<set name="images">
			<key column="stuId"></key>
			<one-to-many class="com.bee.model.Image2"/>
		</set>
	</class>

</hibernate-mapping>
  • Image2.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 package="com.bee.model">

	<class name="Image2" table="t_image2">
		<id name="id" column="imageId">
			<generator class="native"></generator>
		</id>
		
		<discriminator column="imageType" type="string"></discriminator>
		<property name="imageName" column="imageName"></property>
		
		<many-to-one name="student" column="stuId" class="com.bee.model.Student2"></many-to-one>
		
		<subclass name="com.bee.model.LifeImage2" discriminator-value="li"></subclass>
		<subclass name="com.bee.model.WorkImage2" discriminator-value="wi"></subclass>
	</class>

</hibernate-mapping>
  • Student3.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 package="com.bee.model">

	<class name="Student3" table="t_student3">
		<id name="id" column="stuId">
			<generator class="native"></generator>
		</id>
		
		<property name="name" column="stuName"></property>
		
		<set name="images">
			<key column="stuId"></key>
			<one-to-many class="com.bee.model.Image3"/>
		</set>
	</class>

</hibernate-mapping>
  • Image3.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 package="com.bee.model">

	<class name="Image3" table="t_image3">
		<id name="id" column="imageId">
			<generator class="native"></generator>
		</id>
		
		<property name="imageName" column="imageName"></property>
		
		<many-to-one name="student" column="stuId" class="com.bee.model.Student3"></many-to-one>
		
		<joined-subclass name="com.bee.model.LifeImage3" table="t_lifeImage3">
			<key column="lifeImageId"></key>
		</joined-subclass>
		
		<joined-subclass name="com.bee.model.WorkImage3" table="t_workImage3">
			<key column="workImageId"></key>
		</joined-subclass>
	</class>

</hibernate-mapping>
  • 测试
public class StudentTest {

	private SessionFactory sessionFactory=HibernateUtil.getSessionFactory();
	private Session session;
	
	@Before
	public void setUp() throws Exception {
		session=sessionFactory.openSession(); // 生成一个session
	    session.beginTransaction(); // 开启事务
	}

	@After
	public void tearDown() throws Exception {
		 session.getTransaction().commit(); // 提交事务
		 session.close(); // 关闭session
	}

	@Test
	public void testGetAllImages(){
		List<Image> imageList=new ArrayList<Image>();
		int stuId=1;
		List<Image> lifeImageList=(List<Image>)session.createQuery("from LifeImage l where l.student.id="+stuId).list();
		imageList.addAll(lifeImageList);
		List<Image> workImageList=(List<Image>)session.createQuery("from WorkImage w where w.student.id="+stuId).list();
		imageList.addAll(workImageList);
		Iterator it=imageList.iterator();
		while(it.hasNext()){
			Image image=(Image)it.next();
			System.out.println(image.getImageName());
		}
	}
	
	@Test
	public void testGetAllImages2(){
		Student2 student2=(Student2)session.get(Student2.class, 1);
		Set<Image2> images=student2.getImages();
		Iterator it=images.iterator();
		while(it.hasNext()){
			Image2 image=(Image2)it.next();
			System.out.println(image.getImageName());
		}
	}
	
	@Test
	public void testGetAllImages3(){
		Student3 student3=(Student3)session.get(Student3.class, 1);
		Set<Image3> images=student3.getImages();
		Iterator it=images.iterator();
		while(it.hasNext()){
			Image3 image=(Image3)it.next();
			System.out.println(image.getImageName());
		}
	}
	
}
二. 一对一关系映射
  • 主配置文件
    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>

        <!--数据库连接设置 -->
        <property name="connection.driver_class">com.mysql.jdbc.Driver</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="dialect">org.hibernate.dialect.MySQL5Dialect</property>
	
        <!-- 控制台显示SQL -->
        <property name="show_sql">true</property>

        <!-- 自动更新表结构 -->
        <property name="hbm2ddl.auto">update</property>
        
        <!-- 按主键映射一对一 -->
  		<mapping resource="com/bee/model/User.hbm.xml"/>
  		<mapping resource="com/bee/model/Address.hbm.xml"/>
  		
  		<!-- 按外键映射一对一 -->
  		<mapping resource="com/bee/model/User2.hbm.xml"/>
  		<mapping resource="com/bee/model/Address2.hbm.xml"/>

    </session-factory>

</hibernate-configuration>
  • User.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 package="com.bee.model">

	<class name="User" table="t_user">
		<id name="id" column="userId">
			<generator class="native"></generator>
		</id>
		
		<property name="name" column="userName"></property>
		
		<one-to-one name="address" class="com.bee.model.Address" cascade="all"></one-to-one>
	</class>

</hibernate-mapping>
  • Address.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 package="com.bee.model">

	<class name="Address" table="t_address">
		<id name="id" column="addressId">
			<generator class="foreign">
				<param name="property">user</param>
			</generator>
		</id>
		
		<property name="address" column="address"></property>
		<property name="zipcode" column="zipcode"></property>
		
		<one-to-one name="user" class="com.bee.model.User" constrained="true"></one-to-one>
	</class>

</hibernate-mapping>
  • User2.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 package="com.bee.model">

	<class name="User2" table="t_user2">
		<id name="id" column="userId">
			<generator class="native"></generator>
		</id>
		
		<property name="name" column="userName"></property>
		
		<many-to-one name="address" class="com.bee.model.Address2" column="addressId" cascade="all" unique="true"></many-to-one>
	</class>

</hibernate-mapping>
  • Address2.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 package="com.bee.model">

	<class name="Address2" table="t_address2">
		<id name="id" column="addressId">
			<generator class="native">
			</generator>
		</id>
		
		<property name="address" column="address"></property>
		<property name="zipcode" column="zipcode"></property>
		
		<one-to-one name="user" class="com.bee.model.User2" property-ref="address"></one-to-one>
	</class>

</hibernate-mapping>
  • 测试
public class UserTest {

	private SessionFactory sessionFactory=HibernateUtil.getSessionFactory();
	private Session session;
	
	@Before
	public void setUp() throws Exception {
		session=sessionFactory.openSession(); // 生成一个session
	    session.beginTransaction(); // 开启事务
	}

	@After
	public void tearDown() throws Exception {
		 session.getTransaction().commit(); // 提交事务
		 session.close(); // 关闭session
	}

	@Test
	public void testSave1(){
		User user=new User();
		user.setName("张三");
		
		Address address=new Address();
		address.setAddress("某地方");
		address.setZipcode("43242");
		address.setUser(user);
		
		user.setAddress(address);
		session.save(user);
	}
	
	@Test
	public void testSave2(){
		User2 user=new User2();
		user.setName("李四");
		
		Address2 address=new Address2();
		address.setAddress("某地方2");
		address.setZipcode("432422");
		address.setUser(user);
		
		user.setAddress(address);
		session.save(user);
	}
	
}
三. 多对多映射
  • 主配置文件
    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>

        <!--数据库连接设置 -->
        <property name="connection.driver_class">com.mysql.jdbc.Driver</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="dialect">org.hibernate.dialect.MySQL5Dialect</property>
	
        <!-- 控制台显示SQL -->
        <property name="show_sql">true</property>

        <!-- 自动更新表结构 -->
        <property name="hbm2ddl.auto">update</property>
        
        <!-- 多对多单向实现 -->
  		<mapping resource="com/bee/model/Student.hbm.xml"/>
  		<mapping resource="com/bee/model/Course.hbm.xml"/>

		<!-- 多对多双向实现 -->
		<mapping resource="com/bee/model/Student2.hbm.xml"/>
  		<mapping resource="com/bee/model/Course2.hbm.xml"/>
    </session-factory>

</hibernate-configuration>
  • Course.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 package="com.bee.model">

	<class name="Course" table="t_course">
		<id name="id" column="courseId">
			<generator class="native"></generator>
		</id>
		
		<property name="name" column="courseName"></property>
		
	</class>

</hibernate-mapping>
  • 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 package="com.bee.model">

	<class name="Student" table="t_student">
		<id name="id" column="studentId">
			<generator class="native"></generator>
		</id>
		
		<property name="name" column="studentName"></property>
		
		<set name="courses" table="student_course" cascade="save-update">
			<key column="student_id"></key>
			<many-to-many class="com.bee.model.Course" column="course_id"></many-to-many>
		</set>
	</class>

</hibernate-mapping>
  • Course2.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 package="com.bee.model">

	<class name="Course2" table="t_course2">
		<id name="id" column="courseId">
			<generator class="native"></generator>
		</id>
		
		<property name="name" column="courseName"></property>
		
		<set name="students" table="student_course2" inverse="true" >
			<key column="course_id"></key>
			<many-to-many class="com.bee.model.Student2" column="student_id"></many-to-many>
		</set>
		
	</class>

</hibernate-mapping>
  • Student2.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 package="com.bee.model">

	<class name="Student2" table="t_student2">
		<id name="id" column="studentId">
			<generator class="native"></generator>
		</id>
		
		<property name="name" column="studentName"></property>
		
		<set name="courses" table="student_course2" cascade="save-update">
			<key column="student_id"></key>
			<many-to-many class="com.bee.model.Course2" column="course_id"></many-to-many>
		</set>
	</class>

</hibernate-mapping>
  • 测试
public class StudentTest {

	private SessionFactory sessionFactory=HibernateUtil.getSessionFactory();
	private Session session;
	
	@Before
	public void setUp() throws Exception {
		session=sessionFactory.openSession(); // 生成一个session
	    session.beginTransaction(); // 开启事务
	}

	@After
	public void tearDown() throws Exception {
		 session.getTransaction().commit(); // 提交事务
		 session.close(); // 关闭session
	}

	@Test
	public void testSave1(){
		Course course1=new Course();
		course1.setName("语文");
		
		Course course2=new Course();
		course2.setName("数学");
		
		Student student1=new Student();
		student1.setName("张三");
		student1.getCourses().add(course1);
		student1.getCourses().add(course2);
		
		Student student2=new Student();
		student2.setName("李四");
		student2.getCourses().add(course1);
		student2.getCourses().add(course2);
		
		session.save(student1);
		session.save(student2);
	}
	
	@Test
	public void testLoad1(){
		Student student=(Student)session.get(Student.class, 1);
		Set<Course> courses=(Set<Course>)student.getCourses();
		Iterator it=courses.iterator();
		while(it.hasNext()){
			Course c=(Course)it.next();
			System.out.println(c.getName());
		}
	}
	
	
	@Test
	public void testSave2(){
		Course2 course1=new Course2();
		course1.setName("语文");
		
		Course2 course2=new Course2();
		course2.setName("数学");
		
		Student2 student1=new Student2();
		student1.setName("张三");
		student1.getCourses().add(course1);
		student1.getCourses().add(course2);
		
		Student2 student2=new Student2();
		student2.setName("李四");
		student2.getCourses().add(course1);
		student2.getCourses().add(course2);
		
		session.save(student1);
		session.save(student2);
	}
	
	@Test
	public void testLoad2(){
		Course2 course=(Course2)session.get(Course2.class, 1);
		Set<Student2> students=(Set<Student2>)course.getStudents();
		Iterator it=students.iterator();
		while(it.hasNext()){
			Student2 s=(Student2)it.next();
			System.out.println(s.getName());
		}
		
	}
	
	
}
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值