Hibernate many to many

用Hibernate来处理一些对象及其相互关系，使用得当的话，往往能让设计和实现简单、明了。 这里记录了一种多对多的实方式。

 

 

Hibernate是用于java的开源的对象/关系映射工具，她让我们对数据的处理更加抽象和简单。

 

这里假设一个CustChanl 可以属于多个CustChanlGrp， 一个CustChanlGrp可以包含多个CustChanl，即他们是many-to-many的关系。并且使用struts2、hibernate、spring。

1. 数据模型

 

WWMD_CUST_CHANL

Column Name	Key	Nulls	Format	Length	Definition / Comments
CUST_CHANL_ID	PK	No	VARCHAR2	15	Customer/Channel ID
CUST_CHANL		No	VARCHAR2	100	Customer/Channel Name

 

WWMD_CUST_CHANL_GRP

Column Name	Key	Nulls	Format	Length	Definition / Comments
CUST_CHANL_GRP_ID	PK	No	VARCHAR2	15	Customer/Channel group ID
CUST_CHANL_GRP		No	VARCHAR2	100	Customer/Channel group name

 

WWMD_CUST_CHANL_MAP

Column Name	Key	Nulls	Format	Length	Definition / Comments
CUST_CHANL_GRP_ID	PK	No	VARCHAR2	15	Customer/Channel group ID referencing WWMD_CUST_CHANL_GRP
CUST_CHANL_ID	PK	No	VARCHAR2	15	Customer/Channel ID referencing WWMD_CUST_CHANL

 

2.持久层对象（POJO）

 

CustChanl ------对应实体表

package XXX; import java.io.Serializable; import java.util.SortedSet; public class CustChanl extends BaseObject implements Comparable, Serializable{ private static final long serialVersionUID = -5701632595412350606L; //fields private String id; private String custChanl; private SortedSet belongToGrp;// //constructor public CustChanl() { } public CustChanl(String id, String custChanl) { super(); this.id = id; this.custChanl = custChanl; } public CustChanl(String id, String custChanl, SortedSet belongToGrp) { super(); this.id = id; this.custChanl = custChanl; this.belongToGrp = belongToGrp; } // Property access public String getId() { return id; } public void setId(String id) { this.id = id; } public String getCustChanl() { return custChanl; } public void setCustChanl(String custChanl) { this.custChanl = custChanl; } public SortedSet getBelongToGrp() { return belongToGrp; } public void setBelongToGrp(SortedSet belongToGrp) { this.belongToGrp = belongToGrp; } public int compareTo(Object o) { CustChanl other = (CustChanl) o; return id.compareTo(other.getId()); } }

package XXX; import java.io.Serializable; public class CustChanlMap extends BaseObject implements Serializable{ //fields private String custChanlId; private String custChanlGrpId; //constructor public CustChanlMap(String custChanlId, String custChanlGrpId) { super(); this.custChanlId = custChanlId; this.custChanlGrpId = custChanlGrpId; } //field access public String getCustChanlId() { return custChanlId; } public void setCustChanlId(String custChanlId) { this.custChanlId = custChanlId; } public String getCustChanlGrpId() { return custChanlGrpId; } public void setCustChanlGrpId(String custChanlGrpId) { this.custChanlGrpId = custChanlGrpId; } }  

 

 

CustChanlMap  ---对应关系表

package XXX; import java.io.Serializable; import java.util.SortedSet; public class CustChanlGrp extends BaseObject implements Comparable,Serializable{ /** * */ private static final long serialVersionUID = -2195174964227260189L; //fields private String id; private String custChanlGrp; private SortedSet custChanls; //constructor public CustChanlGrp() { } public CustChanlGrp(String id, String custChanlGrp) { this.id = id; this.custChanlGrp = custChanlGrp; } public CustChanlGrp(String id, String custChanlGrp, SortedSet custChanls) { this.id = id; this.custChanlGrp = custChanlGrp; this.custChanls = custChanls; } //field access public String getId() { return id; } public void setId(String id) { this.id = id; } public String getCustChanlGrp() { return custChanlGrp; } public void setCustChanlGrp(String custChanlGrp) { this.custChanlGrp = custChanlGrp; } public SortedSet getCustChanls() { return custChanls; } public void setCustChanls(SortedSet custChanls) { this.custChanls = custChanls; } public int compareTo(Object o) { CustChanlGrp other = (CustChanlGrp) o; return id.compareTo(other.getId()); } }

 

 

 

 

 

 

3. 映射文件（数据表和java对象的桥梁）

CustChanl.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="pl.com.source.wwmd.model"> <class name="CustChanl" table="${table.wwmd.cust.chanl}" > <meta attribute="extends">BaseObject</meta> <meta attribute="implement-equals">true</meta> <id name="id" column="CUST_CHANL_ID" type="string" unsaved-value="null"> <generator class="sequence"> <param name="sequence">wwmd_cust_chnl_seq</param> </generator> </id> <property name="custChanl" column="CUST_CHANL" type="string" not-null="true"/> <set name="belongToGrp" lazy="false" table="${table.wwmd.cust.chanl.map}" sort="natural"> <cache usage="read-write"/> <key column="CUST_CHANL_ID" not-null="true" /> <many-to-many class="CustChanlGrp" column="CUST_CHANL_GRP_ID"/> </set> </class> </hibernate-mapping>

CustChanlGrp.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="pl.com.source.wwmd.model"> <class name="CustChanlGrp" table="${table.wwmd.cust.chanl.grp}" > <meta attribute="extends">BaseObject</meta> <meta attribute="implement-equals">true</meta> <id name="id" column="CUST_CHANL_GRP_ID" type="string" unsaved-value="null"> <generator class="sequence"> <param name="sequence">wwmd_cust_chnl_grp_seq</param> </generator> </id> <property name="custChanlGrp" column="CUST_CHANL_GRP" type="string" not-null="true"/> <set name="custChanls" lazy="false" table="${table.wwmd.cust.chanl.map}" sort="natural"> <cache usage="read-write"/> <key column="CUST_CHANL_GRP_ID" not-null="true" /> <many-to-many class="CustChanl" column="CUST_CHANL_ID"/> </set> </class> </hibernate-mapping>

 CustChanlMap.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="pl.com.source.wwmd.model"> <class name="CustChanlMap" table="${table.wwmd.cust.chanl.map}" mutable="false"> <meta attribute="extends">BaseObject</meta> <meta attribute="implement-equals">true</meta> <cache usage="read-write"/> <composite-id> <key-property name="custChanlId" column="CUST_CHANL_ID" type="string" /> <key-property name="custChanlGrpId" column="CUST_CHANL_GRP_ID" type="string" /> </composite-id> </class> </hibernate-mapping>

 

4.分别创建CustChanl和CustChanlGrp的DAO的实现类和接口（略），实现对数据库的操作。

CustChanlDaoImpl

package pl.com.source.wwmd.dao.hibernate; import java.util.List; import org.springframework.dao.DataAccessException; import pl.com.source.wwmd.dao.CustChanlDao; import pl.com.source.wwmd.dao.impl.SourceHibernateDaoSupport; import pl.com.source.wwmd.model.CustChanl; public class CustChanlDaoHibernate extends SourceHibernateDaoSupport implements CustChanlDao { public List getCustChanls() { return this.getHibernateTemplate().find("from CustChanl where id!='1' "); } public CustChanl addCustChanl(CustChanl custChanl){ try { getHibernateTemplate().save(custChanl); return custChanl; } catch (DataAccessException e) { e.printStackTrace(); } return null; } public CustChanl updateCustChanl(CustChanl custChanl){ try { getHibernateTemplate().update(custChanl); return custChanl; } catch (DataAccessException e) { e.printStackTrace(); } return null; } public Boolean deleteCustChanl(CustChanl custChanl){ try { getHibernateTemplate().delete(custChanl); getHibernateTemplate().flush(); return true; } catch (DataAccessException e) { e.printStackTrace(); } return false; } public CustChanl getCustChanlById(String id) { return (CustChanl)this.getHibernateTemplate().get(CustChanl.class, id); } }

 

CustChanlGrpDaoImpl

package pl.com.source.wwmd.dao.hibernate; import java.util.List; import org.springframework.dao.DataAccessException; import pl.com.source.wwmd.dao.CustChanlGrpDao; import pl.com.source.wwmd.dao.impl.SourceHibernateDaoSupport; import pl.com.source.wwmd.model.CustChanlGrp; public class CustChanlGrpDaoHibernate extends SourceHibernateDaoSupport implements CustChanlGrpDao { public List getCustChanlGrps() { return getHibernateTemplate().find("from CustChanlGrp"); } public CustChanlGrp addCustChanlGrp(CustChanlGrp custChanlGrp) { try { getHibernateTemplate().save(custChanlGrp); return custChanlGrp; } catch (Exception e) { e.printStackTrace(); } return null; } public CustChanlGrp updateCustChanlGrp(CustChanlGrp custChanlGrp) { try { getHibernateTemplate().update(custChanlGrp); return custChanlGrp; } catch (Exception e) { e.printStackTrace(); } return null; } public Boolean deleteCustChanlGrp(CustChanlGrp custChanlGrp) { try { getHibernateTemplate().delete(custChanlGrp); return true; } catch (Exception e) { e.printStackTrace(); } return false; } public CustChanlGrp getCustChanlGrpById(String id){ return (CustChanlGrp)this.getHibernateTemplate().get(CustChanlGrp.class, id); } }

 

5.设置Hibernate SessionFactory

<!-- Hibernate SessionFactory --> <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> <property name="dataSource"><ref local="dataSource"/></property> <property name="mappingResources"> <list> <!-- Add list of .hbm.xml files here --> <value>com/source/CustChanl.hbm.xml</value> <value>com/source/CustChanlGrp.hbm.xml</value> <value>com/source/CustChanlMap.hbm.xml</value> </list> </property>

 

6.spring容器中，定义好相应的Dao

custChanlGrpDao and custChanlDao

<bean id="custChanlDao" class="pl.com.source.wwmd.dao.hibernate.CustChanlDaoHibernate"> <property name="sessionFactory"><ref local="sessionFactory"/></property> <property name="placeholderResolver"><ref local="placeholderResolver"/></property> </bean> <bean id="custChanlGrpDao" class="pl.com.source.wwmd.dao.hibernate.CustChanlGrpDaoHibernate"> <property name="sessionFactory"><ref local="sessionFactory"/></property> <property name="placeholderResolver"><ref local="placeholderResolver"/></property> </bean>

 

7. Dao在业务层的定义（定义要直接设为null，不能使用new的方式，并且要定义好相应的get和set方法，dao有spring容器管理）

/* * Changes history: * Author Date Description * --------------------------------------------------------------------------- * ye.ji.1 Dec 15, 2009 Creation. */ package XXX; import XXX.BaseAction; import XXX.CustChanlDao; import XXX.CustChanlGrpDao; public class CustChanlMaintenanceBaseAction extends BaseAction { CustChanlDao custChanlDao = null; CustChanlGrpDao custChanlGrpDao = null; public CustChanlDao getCustChanlDao() { return custChanlDao; } public void setCustChanlDao(CustChanlDao custChanlDao) { this.custChanlDao = custChanlDao; } public CustChanlGrpDao getCustChanlGrpDao() { return custChanlGrpDao; } public void setCustChanlGrpDao(CustChanlGrpDao custChanlGrpDao) { this.custChanlGrpDao = custChanlGrpDao; } }

 

8. 使用，Action继承该base类，直接调用定义好了的dao就行了。

 

9. 总结

在设计CustChanl对象的时候，添加一个Set类型的属性用来存放他所属的group，配置好hbm文件，这样在对CustChanl对象操作时，他与他所属的group的关系会有hibernate自动维护，这里把对象的关系转换成了对象的一个属性进行操作，并且有有hibernate自动维护；CustChanlGrp对象也同理。

 

 

CustChanlGrp ----------对应实体表