所有项目导入对应的hibernate的jar包、mysql的jar包和添加每次都需要用到的HibernateUtil.java
第一节：Hibernate 一对一映射关系实现
1，按照主键映射；
2，按照外键映射；
1，按照主键映射：
User.java
package com.wishwzp.model;
public class User {
private int id;
private String name;
private Address address;
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 Address getAddress() {
return address;
}
public void setAddress(Address address) {
this.address = address;
}
}
Address.java
package com.wishwzp.model;
public class Address {
private int id;
private String address;
private String zipcode;
private User user;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public String getZipcode() {
return zipcode;
}
public void setZipcode(String zipcode) {
this.zipcode = zipcode;
}
public User getUser() {
return user;
}
public void setUser(User user) {
this.user = user;
}
}
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.wishwzp.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.wishwzp.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.wishwzp.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.wishwzp.model.User" constrained="true"></one-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> <!--数据库连接设置 -->
<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/wishwzp/model/User.hbm.xml"/>
<mapping resource="com/wishwzp/model/Address.hbm.xml"/> </session-factory> </hibernate-configuration>
UserTest.java
package com.wishwzp.service; import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.junit.After;
import org.junit.Before;
import org.junit.Test; import com.wishwzp.model.Address;
import com.wishwzp.model.Address2;
import com.wishwzp.model.User;
import com.wishwzp.model.User2;
import com.wishwzp.util.HibernateUtil; 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(){ } }
UserTest.java
package com.wishwzp.service; import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.junit.After;
import org.junit.Before;
import org.junit.Test; import com.wishwzp.model.Address;
import com.wishwzp.model.Address2;
import com.wishwzp.model.User;
import com.wishwzp.model.User2;
import com.wishwzp.util.HibernateUtil; 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);
} }
我们发现主键一对一的。。。。
2，按照外键映射：
User2.java
package com.wishwzp.model;
public class User2 {
private int id;
private String name;
private Address2 address;
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 Address2 getAddress() {
return address;
}
public void setAddress(Address2 address) {
this.address = address;
}
}
Address2.java
package com.wishwzp.model;
public class Address2 {
private int id;
private String address;
private String zipcode;
private User2 user;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public String getZipcode() {
return zipcode;
}
public void setZipcode(String zipcode) {
this.zipcode = zipcode;
}
public User2 getUser() {
return user;
}
public void setUser(User2 user) {
this.user = user;
}
}
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.wishwzp.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.wishwzp.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.wishwzp.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.wishwzp.model.User2" property-ref="address"></one-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> <!--数据库连接设置 -->
<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/wishwzp/model/User2.hbm.xml"/>
<mapping resource="com/wishwzp/model/Address2.hbm.xml"/> </session-factory> </hibernate-configuration>
UserTest.java
package com.wishwzp.service; import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.junit.After;
import org.junit.Before;
import org.junit.Test; import com.wishwzp.model.Address;
import com.wishwzp.model.Address2;
import com.wishwzp.model.User;
import com.wishwzp.model.User2;
import com.wishwzp.util.HibernateUtil; 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 testSave2(){ } }
UserTest.java
package com.wishwzp.service; import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.junit.After;
import org.junit.Before;
import org.junit.Test; import com.wishwzp.model.Address;
import com.wishwzp.model.Address2;
import com.wishwzp.model.User;
import com.wishwzp.model.User2;
import com.wishwzp.util.HibernateUtil; 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 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);
} }
我们发现：t_User2表中的addressId对应着t_address2表中的主键addressId
第二节：Hibernate 多对多映射关系实现
1，多对多单向实现；
2，多对多双向实现；
1，多对多单向实现：
Course.java
package com.wishwzp.model;
public class Course {
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;
}
}
Student.java
package com.wishwzp.model; import java.util.HashSet;
import java.util.Set; public class Student { private int id;
private String name;
private Set<Course> courses=new HashSet<Course>(); 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 Set<Course> getCourses() {
return courses;
}
public void setCourses(Set<Course> courses) {
this.courses = courses;
} }
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.wishwzp.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.wishwzp.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.wishwzp.model.Course" column="course_id"></many-to-many>
</set>
</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> <!--数据库连接设置 -->
<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/wishwzp/model/Student.hbm.xml"/>
<mapping resource="com/wishwzp/model/Course.hbm.xml"/> </session-factory> </hibernate-configuration>
StudentTest.java
package com.wishwzp.service; import java.util.Iterator;
import java.util.Set; import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.junit.After;
import org.junit.Before;
import org.junit.Test; import com.wishwzp.model.Course;
import com.wishwzp.model.Course2;
import com.wishwzp.model.Student;
import com.wishwzp.model.Student2;
import com.wishwzp.util.HibernateUtil; 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(){ } }
StudentTest.java
package com.wishwzp.service; import java.util.Iterator;
import java.util.Set; import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.junit.After;
import org.junit.Before;
import org.junit.Test; import com.wishwzp.model.Course;
import com.wishwzp.model.Course2;
import com.wishwzp.model.Student;
import com.wishwzp.model.Student2;
import com.wishwzp.util.HibernateUtil; 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);
} }
我们现在查询一下数据：
StudentTest.java
package com.wishwzp.service; import java.util.Iterator;
import java.util.Set; import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.junit.After;
import org.junit.Before;
import org.junit.Test; import com.wishwzp.model.Course;
import com.wishwzp.model.Course2;
import com.wishwzp.model.Student;
import com.wishwzp.model.Student2;
import com.wishwzp.util.HibernateUtil; 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());
}
} }
我们这里是单向的，只能从学生这端去查找课程，无法从课程这端查找学生的，这就是单向的。
2，多对多双向实现：
Course2.java
package com.wishwzp.model; import java.util.HashSet;
import java.util.Set; public class Course2 { private int id;
private String name;
private Set<Student2> students=new HashSet<Student2>(); 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 Set<Student2> getStudents() {
return students;
}
public void setStudents(Set<Student2> students) {
this.students = students;
} }
Student2.java
package com.wishwzp.model; import java.util.HashSet;
import java.util.Set; public class Student2 { private int id;
private String name;
private Set<Course2> courses=new HashSet<Course2>(); 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 Set<Course2> getCourses() {
return courses;
}
public void setCourses(Set<Course2> courses) {
this.courses = courses;
} }
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.wishwzp.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.wishwzp.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.wishwzp.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.wishwzp.model.Course2" column="course_id"></many-to-many>
</set>
</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> <!--数据库连接设置 -->
<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/wishwzp/model/Student2.hbm.xml"/>
<mapping resource="com/wishwzp/model/Course2.hbm.xml"/> </session-factory> </hibernate-configuration>
StudentTest.java
package com.wishwzp.service; import java.util.Iterator;
import java.util.Set; import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.junit.After;
import org.junit.Before;
import org.junit.Test; import com.wishwzp.model.Course;
import com.wishwzp.model.Course2;
import com.wishwzp.model.Student;
import com.wishwzp.model.Student2;
import com.wishwzp.util.HibernateUtil; 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 testSave2(){ } }
StudentTest.java
package com.wishwzp.service; import java.util.Iterator;
import java.util.Set; import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.junit.After;
import org.junit.Before;
import org.junit.Test; import com.wishwzp.model.Course;
import com.wishwzp.model.Course2;
import com.wishwzp.model.Student;
import com.wishwzp.model.Student2;
import com.wishwzp.util.HibernateUtil; 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 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);
} }
我们现在查询一下数据：
StudentTest.java
package com.wishwzp.service; import java.util.Iterator;
import java.util.Set; import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.junit.After;
import org.junit.Before;
import org.junit.Test; import com.wishwzp.model.Course;
import com.wishwzp.model.Course2;
import com.wishwzp.model.Student;
import com.wishwzp.model.Student2;
import com.wishwzp.util.HibernateUtil; 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 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());
} } }
我们这里是双向的，既可以从学生这端去查找课程，又可以从课程这端查找学生的，这就是双向的。