- 一个简单示例:
- 一个雇员可以担任几个角色,一个角色可以拥有多个雇员,雇员和角色之间存在多对多的关联关系,
- 在这里我们建立多对多的双向关联...
- db schema:
- ==============================
- 雇员表:
- CREATE TABLE [employee] (
- [eid] [int] IDENTITY (1, 1) NOT NULL ,
- [ename] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
- [join_date] [datetime] NOT NULL ,
- PRIMARY KEY CLUSTERED
- (
- [eid]
- ) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- 角色表:
- CREATE TABLE [role] (
- [roleid] [int] IDENTITY (1, 1) NOT NULL ,
- [rolename] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
- PRIMARY KEY CLUSTERED
- (
- [roleid]
- ) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- 雇员角色表:
- CREATE TABLE [emp_role] (
- [er_id] [int] IDENTITY (1, 1) NOT NULL ,
- [er_eid] [int] NULL ,
- [er_roleid] [int] NULL ,
- PRIMARY KEY CLUSTERED
- (
- [er_id]
- ) ON [PRIMARY] ,
- FOREIGN KEY
- (
- [er_eid]
- ) REFERENCES [employee] (
- [eid]
- ),
- FOREIGN KEY
- (
- [er_roleid]
- ) REFERENCES [role] (
- [roleid]
- )
- ) ON [PRIMARY]
- GO
- Employee.java
- --------------------------
- package com.supersit.hibernate.bean;
- import java.util.Date;
- import java.util.Set;
- public class Employee implements java.io.Serializable,
- com.supersit.hibernate.Interface.ObjectIn {
- /**
- *
- */
- private static final long serialVersionUID = 1L;
- //雇员编号
- private Integer eid;
- //雇员姓名
- private String ename;
- //入职时间
- private java.util.Date join_date;
- //角色集合
- private java.util.Set<Role> roles = new java.util.HashSet<Role>();
- public Employee(Integer eid, String ename, Date join_date) {
- this.eid = eid;
- this.ename = ename;
- this.join_date = join_date;
- }
- public Employee(Integer eid, String ename, Date join_date, Set<Role> roles) {
- this.eid = eid;
- this.ename = ename;
- this.join_date = join_date;
- this.roles = roles;
- }
- public java.util.Set getRoles() {
- return roles;
- }
- public void setRoles(java.util.Set<Role> roles) {
- this.roles = roles;
- }
- public Employee() {
- }
- public Integer getEid() {
- return eid;
- }
- public void setEid(Integer eid) {
- this.eid = eid;
- }
- public String getEname() {
- return ename;
- }
- public void setEname(String ename) {
- this.ename = ename;
- }
- public java.util.Date getJoin_date() {
- return join_date;
- }
- public void setJoin_date(java.util.Date join_date) {
- this.join_date = join_date;
- }
- }
- Role.java
- ------------------------------------
- package com.supersit.hibernate.bean;
- import java.util.Set;
- public class Role implements java.io.Serializable,
- com.supersit.hibernate.Interface.ObjectIn {
- //角色编号
- private Integer roleid;
- //角色名称
- private String rolename;
- //此角色下的雇员集合
- private java.util.Set emps = new java.util.HashSet();
- public Role(Integer roleid, String rolename, Set emps) {
- this.roleid = roleid;
- this.rolename = rolename;
- this.emps = emps;
- }
- public java.util.Set getEmps() {
- return emps;
- }
- public void setEmps(java.util.Set emps) {
- this.emps = emps;
- }
- public Role() {
- }
- public Integer getRoleid() {
- return roleid;
- }
- public Role(Integer roleid, String rolename) {
- this.roleid = roleid;
- this.rolename = rolename;
- }
- public void setRoleid(Integer roleid) {
- this.roleid = roleid;
- }
- public String getRolename() {
- return rolename;
- }
- public void setRolename(String rolename) {
- this.rolename = rolename;
- }
- }
- 配置文件:
- 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="connection.username">sa</property>
- <property name="connection.url">
- jdbc:microsoft:sqlserver://localhost:1433;databasename=hibernate
- </property>
- <property name="dialect">
- org.hibernate.dialect.SQLServerDialect
- </property>
- <property name="connection.password">sa</property>
- <property name="connection.driver_class">
- com.microsoft.jdbc.sqlserver.SQLServerDriver
- </property>
- <property name="show_sql">true</property>
- <mapping resource="com/supersit/hibernate/mapping/Employee.hbm.xml" />
- <mapping resource="com/supersit/hibernate/mapping/Role.hbm.xml" />
- </session-factory>
- </hibernate-configuration>
- 映射文件:
- 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="com.supersit.hibernate.bean">
- <class name="Employee" table="employee" schema="dbo"
- catalog="hibernate">
- <id name="eid" column="eid" type="int">
- <generator class="identity"></generator>
- </id>
- <property name="ename" column="ename" type="string"
- not-null="true">
- </property>
- <property name="join_date" column="join_date" type="date"></property>
- <!-- 映射roles属性,和连接表emp_role进行关联,级联方式:保存更新,检索方式:立即检索 -->
- <set name="roles" cascade="save-update" lazy="false"
- table="emp_role">
- <!-- 连接表的字段er_eid作为外键依赖于employee表的主键eid -->
- <key column="er_eid"></key>
- <!-- many-to-many属性建立和Role的多对多关联关系,class指定关联的持久化类,连接表的字段er_roleid作为外键依赖于role表的主键roleid -->
- <many-to-many class="Role" column="er_roleid"></many-to-many>
- </set>
- </class>
- </hibernate-mapping>
- Role.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="com.supersit.hibernate.bean">
- <class name="Role" table="role" catalog="hibernate" schema="dbo">
- <id name="roleid" column="roleid" type="int">
- <generator class="identity"></generator>
- </id>
- <property name="rolename" column="rolename" type="string"
- not-null="true">
- </property>
- <set name="emps" table="emp_role" cascade="save-update"
- lazy="false" >
- <key column="er_roleid"></key>
- <many-to-many class="Employee" column="er_eid"></many-to-many>
- </set>
- </class>
- </hibernate-mapping>
- Dao
- ====================================
- EmployeeDao.java
- ----------------------------------
- package com.supersit.hibernate.dao;
- import java.text.ParseException;
- import java.text.SimpleDateFormat;
- import java.util.Date;
- import java.util.HashSet;
- import java.util.Iterator;
- import java.util.List;
- import java.util.Set;
- import org.hibernate.Hibernate;
- import org.hibernate.Session;
- import org.hibernate.Transaction;
- import com.supersit.hibernate.bean.Employee;
- import com.supersit.hibernate.bean.Role;
- import com.supersit.hibernate.exception.HibernateMsgException;
- public class EmployeeDao extends BaseDao {
- /**
- * <p>
- * 查询所有的雇员
- * </p>
- *
- * @author chenwei
- * @return java.util.List
- * @throws HibernateMsgException
- */
- public java.util.List getEmps() throws HibernateMsgException {
- java.util.List list = new java.util.ArrayList();
- org.hibernate.Session session = null;
- org.hibernate.Transaction tran = null;
- try {
- session = com.supersit.hibernate.factory.HibernateSessionFactory
- .getSession();
- tran = session.beginTransaction();
- list = session.createQuery("from Employee e order by e.eid").list();
- tran.commit();
- } catch (Exception e) {
- com.supersit.hibernate.factory.HibernateSessionFactory
- .rollbackTran(tran);
- } finally {
- com.supersit.hibernate.factory.HibernateSessionFactory
- .closeSession(session);
- }
- return list;
- }
- /**
- * <p>
- * 更改指定用户的角色
- * </p>
- *
- * @author chenwei
- * @param eid:用户ID
- * @param roleids:角色ID数组
- *
- */
- public static void opeRolesOfEmp(Integer eid, String[] roleids)
- throws HibernateMsgException {
- org.hibernate.Session session = null;
- org.hibernate.Transaction tran = null;
- try {
- session = com.supersit.hibernate.factory.HibernateSessionFactory
- .getSession();
- tran = session.beginTransaction();
- Employee emp = (Employee) session.load(Employee.class, eid);
- java.util.Set roles = new java.util.HashSet();
- for (int i = 0; i < roleids.length; i++) {
- // 查询角色(此处应传入一个Session对象,否则会抛出org.hibernate.NonUniqueObjectException)
- Role role = new RoleDao().getRoleById(session, new Integer(
- roleids[i]));
- System.out.println("rolename=" + role.getRolename());
- roles.add(role);
- }
- emp.setRoles(roles);
- session.saveOrUpdate(emp);
- tran.commit();
- } catch (Exception e) {
- e.printStackTrace();
- com.supersit.hibernate.factory.HibernateSessionFactory
- .rollbackTran(tran);
- } finally {
- com.supersit.hibernate.factory.HibernateSessionFactory
- .closeSession(session);
- }
- }
- public Employee initEmp(Employee emp) throws HibernateMsgException {
- Session session = null;
- Transaction tran = null;
- try {
- session = com.supersit.hibernate.factory.HibernateSessionFactory
- .getSession();
- tran = session.beginTransaction();
- org.hibernate.Hibernate.initialize(emp.getRoles());
- session.update(emp);
- tran.commit();
- } catch (Exception e) {
- com.supersit.hibernate.factory.HibernateSessionFactory
- .rollbackTran(tran);
- } finally {
- com.supersit.hibernate.factory.HibernateSessionFactory
- .closeSession(session);
- }
- return emp;
- }
- public static void main(String[] args) throws HibernateMsgException {
- // select();
- opeRolesOfEmp(new Integer(1), new String[] { "1", "3", "4" });
- }
- // 检索
- public static void select() throws HibernateMsgException {
- EmployeeDao dao = new EmployeeDao();
- List list = dao.getEmps();
- for (int i = 0; i < list.size(); i++) {
- Employee emp = (Employee) list.get(i);
- System.out.println("eid=" + emp.getEid());
- System.out.println("ename=" + emp.getEname());
- System.out.println("join_date=" + emp.getJoin_date()); //
- // 映射roles属性,lazy=false时,可以立即检索
- Set roles = emp.getRoles();
- java.util.Iterator ite = roles.iterator();
- while (ite.hasNext()) {
- Role role = (Role) ite.next();
- System.out.println("rolename=" + role.getRolename());
- }
- System.out.println("===========================================");
- }
- }
- // 保存对象
- public static void insert() throws HibernateMsgException {
- java.util.Date date = new java.util.Date();
- java.text.SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
- try {
- date = format.parse("2007-10-17");
- } catch (ParseException e) {
- e.printStackTrace();
- }
- Employee emp = new Employee(new Integer(1), "张信哲", date);
- Session session = null;
- Transaction tran = null;
- try {
- session = com.supersit.hibernate.factory.HibernateSessionFactory
- .getSession();
- tran = session.beginTransaction();
- boolean b = new EmployeeDao().saveObj(session, emp);
- if (b) {
- System.out.println("成功保存一个Employee对象");
- }
- tran.commit();
- } catch (Exception e) {
- com.supersit.hibernate.factory.HibernateSessionFactory
- .rollbackTran(tran);
- } finally {
- com.supersit.hibernate.factory.HibernateSessionFactory
- .closeSession(session);
- }
- }
- }
- RoleDao.java
- ------------------------
- package com.supersit.hibernate.dao;
- import org.hibernate.Session;
- import org.hibernate.Transaction;
- import com.supersit.hibernate.bean.Employee;
- import com.supersit.hibernate.bean.Role;
- import com.supersit.hibernate.exception.HibernateMsgException;
- public class RoleDao extends BaseDao {
- /**
- * <p>
- * 根据角色ID查找角色(传入一个Session对象)
- * </p>
- *
- * @param roleid:角色ID
- * @return com.supersit.hibernate.bean.Role
- * @throws HibernateMsgException
- */
- public com.supersit.hibernate.bean.Role getRoleById(Session session,
- Integer roleid) throws HibernateMsgException {
- Role role = new Role();
- try {
- java.util.List list = session.createQuery(
- "from Role r where r.roleid=:id").setInteger("id", roleid)
- .list();
- if (list != null && list.size() > 0)
- role = (Role) list.get(0);
- } catch (Exception e) {
- }
- return role;
- }
- /**
- * <p>
- * 根据角色ID查找角色(创建一个新的Session)
- * </p>
- *
- * @param roleid:角色ID
- * @return com.supersit.hibernate.bean.Role
- * @throws HibernateMsgException
- */
- public com.supersit.hibernate.bean.Role getRoleById(Integer roleid)
- throws HibernateMsgException {
- Role role = new Role();
- Session session = null;
- Transaction tran = null;
- try {
- session = com.supersit.hibernate.factory.HibernateSessionFactory
- .getSession();
- tran = session.beginTransaction();
- java.util.List list = session.createQuery(
- "from Role r where r.roleid=:id").setInteger("id", roleid)
- .list();
- if (list != null && list.size() > 0)
- role = (Role) list.get(0);
- tran.commit();
- } catch (Exception e) {
- com.supersit.hibernate.factory.HibernateSessionFactory
- .rollbackTran(tran);
- } finally {
- com.supersit.hibernate.factory.HibernateSessionFactory
- .closeSession(session);
- }
- return role;
- }
- public static void main(String[] args) throws HibernateMsgException {
- selectEmpsOfEachRole();
- }
- /**
- * <p>
- * 查询所有的角色
- * </p>
- *
- * @param session
- * @return java.util.List
- */
- public static java.util.List getAllRoles(org.hibernate.Session session) {
- java.util.List list = new java.util.ArrayList();
- list = session.createQuery("from Role r order by r.roleid asc").list();
- return list;
- }
- public static void selectEmpsOfEachRole() throws HibernateMsgException {
- org.hibernate.Session session = null;
- org.hibernate.Transaction tran = null;
- try {
- session = com.supersit.hibernate.factory.HibernateSessionFactory
- .getSession();
- tran = session.beginTransaction();
- java.util.List list = getAllRoles(session);
- for (int i = 0; i < list.size(); i++) {
- Role role = (Role) list.get(i);
- System.out.println("角色编号:" + role.getRoleid());
- System.out.println("角色名称:" + role.getRolename());
- System.out.println("此角色下的所有雇员>>>");
- java.util.Iterator ite = role.getEmps().iterator();
- while (ite.hasNext()) {
- Employee emp = (Employee) ite.next();
- System.out.println("雇员编号:" + emp.getEid());
- System.out.println("雇员姓名:" + emp.getEname());
- System.out.println("入职时间:" + emp.getJoin_date());
- }
- System.out
- .println("=======================================================");
- }
- tran.commit();
- } catch (Exception e) {
- com.supersit.hibernate.factory.HibernateSessionFactory
- .rollbackTran(tran);
- } finally {
- com.supersit.hibernate.factory.HibernateSessionFactory
- .closeSession(session);
- }
- }
- }
- /**
- *
- * <p>
- * 对于持久化类的添加,删除,修改可以通过继承这个类来实现 如果已开启Session缓存,可以传入这个Session对象进行相应的操作,当然也可以
- * 不调用此方法,直接调用Session对象相应的方法即可,在这里只是想实现面向接口编程
- * 对于没有开启Session缓存的情况,直接调用只有一个参数的方法,在方法体中会自动创建 Session对象,进行相关操作...
- * </p>
- *
- * @author chenwei
- * 2007-10-26
- *
- */
- BaseDao.java
- ----------------------------
- package com.supersit.hibernate.dao;
- import org.hibernate.Session;
- import com.supersit.hibernate.exception.HibernateMsgException;
- public class BaseDao {
- /**
- * <p>
- * 保存一个com.supersit.hibernate.Interface.ObjectIn对象
- * </p>
- *
- * @author chenwei
- * @param com.supersit.hibernate.Interface.ObjectIn
- * @return boolean
- * @throws HibernateMsgException
- */
- public boolean saveObj(com.supersit.hibernate.Interface.ObjectIn in)
- throws HibernateMsgException {
- org.hibernate.Session ses = null;
- org.hibernate.Transaction tran = null;
- boolean flag = true;
- try {
- ses = com.supersit.hibernate.factory.HibernateSessionFactory1
- .getSession();
- tran = ses.beginTransaction();
- ses.save(in);
- tran.commit();
- } catch (Exception e) {
- e.printStackTrace();
- flag = false;
- com.supersit.hibernate.factory.HibernateSessionFactory
- .rollbackTran(tran);
- } finally {
- com.supersit.hibernate.factory.HibernateSessionFactory
- .closeSession(ses);
- }
- return flag;
- }
- /**
- * <p>
- * 保存一个com.supersit.hibernate.Interface.ObjectIn对象
- * </p>
- *
- * @author chenwei
- * @param com.supersit.hibernate.Interface.ObjectIn
- * @return boolean
- * @throws HibernateMsgException
- */
- public boolean saveObj(Session session,
- com.supersit.hibernate.Interface.ObjectIn in) {
- boolean flag = true;
- try {
- session.save(in);
- } catch (Exception e) {
- e.printStackTrace();
- flag = false;
- }
- return flag;
- }
- /**
- * <p>
- * 修改一个com.supersit.hibernate.Interface.ObjectIn对象
- * </p>
- *
- * @author chenwei
- * @param com.supersit.hibernate.Interface.ObjectIn
- * @return boolean
- * @throws HibernateMsgException
- */
- public boolean updateObj(com.supersit.hibernate.Interface.ObjectIn in)
- throws HibernateMsgException {
- boolean flag = true;
- org.hibernate.Session ses = null;
- org.hibernate.Transaction tran = null;
- try {
- ses = com.supersit.hibernate.factory.HibernateSessionFactory
- .getSession();
- tran = ses.beginTransaction();
- ses.update(in);
- tran.commit();
- } catch (Exception e) {
- flag = false;
- com.supersit.hibernate.factory.HibernateSessionFactory
- .rollbackTran(tran);
- } finally {
- com.supersit.hibernate.factory.HibernateSessionFactory
- .closeSession(ses);
- }
- return flag;
- }
- /**
- * <p>
- * 修改一个com.supersit.hibernate.Interface.ObjectIn对象
- * </p>
- *
- * @author chenwei
- * @param com.supersit.hibernate.Interface.ObjectIn
- * @return boolean
- * @throws HibernateMsgException
- */
- public boolean updateObj(Session session,
- com.supersit.hibernate.Interface.ObjectIn in) {
- boolean flag = true;
- try {
- session.update(in);
- } catch (Exception e) {
- flag = false;
- }
- return flag;
- }
- /**
- * <p>
- * 删除一个com.supersit.hibernate.Interface.ObjectIn对象
- * </p>
- *
- * @author chenwei
- * @param com.supersit.hibernate.Interface.ObjectIn
- * @return boolean
- * @throws HibernateMsgException
- */
- public boolean deleteObj(com.supersit.hibernate.Interface.ObjectIn in)
- throws HibernateMsgException {
- boolean flag = true;
- org.hibernate.Session session = null;
- org.hibernate.Transaction tran = null;
- try {
- session = com.supersit.hibernate.factory.HibernateSessionFactory
- .getSession();
- tran = session.beginTransaction();
- session.delete(in);
- tran.commit();
- } catch (Exception e) {
- flag = false;
- com.supersit.hibernate.factory.HibernateSessionFactory
- .rollbackTran(tran);
- } finally {
- com.supersit.hibernate.factory.HibernateSessionFactory
- .closeSession(session);
- }
- return flag;
- }
- /**
- * <p>
- * 删除一个com.supersit.hibernate.Interface.ObjectIn对象
- * </p>
- *
- * @author chenwei
- * @param com.supersit.hibernate.Interface.ObjectIn
- * @return boolean
- * @throws HibernateMsgException
- */
- public boolean deleteObj(Session session,
- com.supersit.hibernate.Interface.ObjectIn in) {
- boolean flag = true;
- try {
- session.delete(in);
- } catch (Exception e) {
- flag = false;
- }
- return flag;
- }
- }
- ObjectIn.java
- ------------------------------
- package com.supersit.hibernate.Interface;
- public interface ObjectIn {
- }
多对多双向关联
最新推荐文章于 2019-02-17 10:51:39 发布