hibernate快速学习(2) many to many (多对多关系)

大家一定知道关系数据库之间常用的两种关系 ,一对多,多对多,

一对多关系展开成数据库表是两张表,而多对多是三张表,有一张表存放的是关系,我想还是上学时的数据库原理说得很清楚,

下面就得来hibernate 来存储多对多关系,下面是eclipse项目结构,上一篇文章说了,类库是怎么引用的,怕里不说了,代码根目录有hibernate的主配置文件,两个实体包中有对应映射文件,根目录下还有个log4j的properties文件,

 

下面给出代码,

event.java

package events; import java.sql.Timestamp; import java.util.*; import com.sun.org.apache.bcel.internal.generic.NEW; public class Event { private Set persons=new HashSet(); public Set getPersons() { return persons; } public void setPersons(Set persons) { this.persons=persons; } private int id; private String title; private String dateString; public Event(){} public int getId() { return id; } public void setId(int id) { this.id=id; } public String getTitle() { return title; } public void setTitle(String title) { this.title=title; } public String getDateString() { return dateString; } public void setDateString(String timestampString) { this.dateString=timestampString; } }

person.java

package person; import java.util.HashSet; import java.util.Set; public class Person { //事件 private Set events=new HashSet(); public Set getEvents() { return events; } public void setEvents(Set events) { this.events=events; } private int id; private int age; private String firstname; private String lastname; public int getId() { return id; } public void setId(int id) { this.id=id; } public int getAge() { return age; } public void setAge(int age) { this.age=age; } public String getFirstname() { return firstname; } public void setFirstname(String firstname) { this.firstname=firstname; } public String getLastname() { return lastname; } public void setLastname(String lastname) { this.lastname=lastname; } }

HibernateUtil.java 这个类就写了个怎么得到sessionFactory,

package util; import org.hibernate.*; import org.hibernate.cfg.*; public class HibernateUtil { private static final SessionFactory sessionFactory; static { try{ sessionFactory=new Configuration().configure().buildSessionFactory(); }catch(Throwable ex) { System.err.println("initial sessionFactory cration failes"+ex.getMessage()); throw new ExceptionInInitializerError(ex); } } public static SessionFactory getSessionFactory(){ return sessionFactory; } }

HManage.java 这是来测试的,写了对象的持久化,和添加关系

package util; import org.hibernate.Session; import org.hibernate.Transaction; import events.Event; import person.Person; import java.io.IOException; import java.sql.Timestamp; import java.text.SimpleDateFormat; import java.util.*; public class HManager { /** * @param args * @throws IOException */ public static void main(String[] args) throws IOException { HManager mgrEventManager=new HManager(); /*Timestamp timestamp=new Timestamp(new Date().getTime()); Event event=new Event(); event.setDateString(timestamp.toString()); event.setTitle("add");*/ /*mgrEventManager.AddEvent(event); mgrEventManager.ListAllEvent();*/ Person person=new Person(); person.setAge(22); person.setFirstname("hibernate"); person.setLastname("hibernate"); //mgrEventManager.AddPerson(person); //mgrEventManager.AddPersonToEvent(personid, eventid) mgrEventManager.ListAllPerson(); mgrEventManager.ListAllEvent(); //我看了一下数据库,有personid=1,eventid=3的了, mgrEventManager.AddPersonToEvent(1, 3); mgrEventManager.AddEventToPerson(2, 3); mgrEventManager.ListAllPerson(); mgrEventManager.ListAllEvent(); } public void AddPersonToEvent(int personid,int eventid) { Session session=HibernateUtil.getSessionFactory().openSession(); Transaction transaction=null; try { transaction=session.beginTransaction(); //这个叫 automatic dirth checking Person person=(Person)session.load(Person.class, personid); Event event=(Event)session.load(Event.class, eventid); event.getPersons().add(person); transaction.commit(); } catch (Exception e) { // TODO: handle exception System.out.println(e.getMessage()); transaction.rollback(); } } public void AddEventToPerson(int personid,int eventid) { Session session=HibernateUtil.getSessionFactory().openSession(); Transaction transaction=null; try { transaction=session.beginTransaction(); Person person=(Person)session.load(Person.class, personid); Event event=(Event)session.load(Event.class, eventid); person.getEvents().add(event); transaction.commit(); } catch (Exception e) { // TODO: handle exception System.out.println(e.getMessage()); transaction.rollback(); } } public void AddEvent(Event event) { Session session=HibernateUtil.getSessionFactory().openSession(); Transaction transaction=null; try { transaction=session.beginTransaction(); session.save(event); transaction.commit(); } catch (Exception e) { // TODO: handle exception System.out.println(e.getMessage()); transaction.rollback(); } } public void AddPerson(Person person) { Session session=HibernateUtil.getSessionFactory().openSession(); Transaction transaction=null; try { transaction=session.beginTransaction(); session.save(person); transaction.commit(); } catch (Exception e) { // TODO: handle exception System.out.println(e.getMessage()); transaction.rollback(); } } public void ListAllEvent() { Session session=HibernateUtil.getSessionFactory().openSession(); Transaction transaction=null; try { transaction=session.beginTransaction(); List events=session.createQuery("From Event").list(); Iterator iterator=events.iterator(); while(iterator.hasNext()) { Event event=(Event)iterator.next(); System.out.println(event.getId()); System.out.println("person:"+ event.getPersons().size()); System.out.println(event.getTitle()); } transaction.commit(); } catch (Exception e) { // TODO: handle exception System.out.println(e.getMessage()); transaction.rollback(); } } public void ListAllPerson() { Session session=HibernateUtil.getSessionFactory().openSession(); Transaction transaction=null; try { transaction=session.beginTransaction(); List events=session.createQuery("From Person").list(); Iterator iterator=events.iterator(); while(iterator.hasNext()) { Person person=(Person)iterator.next(); System.out.println("PersonId:"+person.getId()); System.out.println("Eventsize:"+person.getEvents().size()); System.out.println(person.getFirstname()); } transaction.commit(); } catch (Exception e) { // TODO: handle exception System.out.println(e.getMessage()); transaction.rollback(); } } }

 

下面给出配置文件了,

Event.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>
  <class name="events.Event" table="EVENTS" >
  <id name="id" column="EVENT_ID">
    <generator class="native"></generator>
  </id>
 
  <property name="dateString" column="EVENT_DATE">
  </property>
  <property name="title" column="EVENT_TITLE"></property>
  <set name="persons" table="PERSON_EVENT">
      <key column="EVENT_ID">
      </key>
      <many-to-many column="PERSON_ID" class="person.Person"></many-to-many>
  </set>
  </class>
</hibernate-mapping>

 

Person.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>
  <class name="person.Person" table="Person" >
  <id name="id" column="PERSON_ID">
    <generator class="native"></generator>
  </id>
 
  <property name="age"></property>
  <property name="firstname"></property>
  <property name="lastname"></property>
 
  <set name="events" table="PERSON_EVENT">
      <key column="PERSON_ID">
      </key>
      <many-to-many column="EVENT_ID" class="events.Event"></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://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
       <!-- 是否显示SQL语句 -->
        <property name="show_sql">true</property>
        <!-- SQL数据库方言SQLServer -->
        <property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
        <!--   JDBC Driver -->
        <property name="connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
        <!-- JDBC URL -->
        <property name="connection.url">jdbc:sqlserver://TINY/SQLSERVER2005;DatabaseName=HibernateStudy;</property>
        <!-- 用户名-->
        <property name="connection.username">sa</property>
        <!-- 密码 -->
        <property name="connection.password">deng</property>
        <!--数据库连接池-->
       
        <property name="c3p0.min_size">5</property>
        <property name="c3p0.max_size">20</property>
        <property name="c3p0.timeout">1800</property>
        <property name="c3p0.max_statements">50</property>
        <!-- 配置每次提交SQL的数量  -->
        <property name=" hibernate.jdbc.batch_size">50</property>
       <mapping resource="events/Event.hbm.xml"/>
        <mapping resource="person/Person.hbm.xml"/>
    </session-factory>

</hibernate-configuration>

 

还有就是数据库结构,

下面是sql ,2005, 大意是两个实体,id是自增,还有个是关系表,就是这样,

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PERSON_EVENT](
 [PERSON_ID] [int] NOT NULL,
 [EVENT_ID] [int] NOT NULL
) ON [PRIMARY]

GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[EVENTS](
 [EVENT_ID] [int] IDENTITY(1,1) NOT NULL,
 [EVENT_DATE] [varchar](50) NULL,
 [EVENT_TITLE] [nchar](100) NULL,
 CONSTRAINT [PK_EVENTS] PRIMARY KEY CLUSTERED
(
 [EVENT_ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Person](
 [PERSON_ID] [int] IDENTITY(1,1) NOT NULL,
 [age] [int] NULL,
 [firstname] [nchar](20) NULL,
 [lastname] [nchar](20) NULL,
 CONSTRAINT [PK_Person] PRIMARY KEY CLUSTERED
(
 [PERSON_ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

 

--如此,已经行了,测试时我输出了person.events.size()和,enent.persons.size(),结果在代码中可以看到,上面这些输出很多,原因是输出了日志,输出了显示sql,不加log4j,和show_sql=false,可以看到简单结果,

多对多关系, 即是如此,当然hibernate中还有此问题等待我们,如 继承,map,set ,这些的持久化,以后文章会写出来,希望对后来的学习者有所帮助,文章是写得简单了一点,但已经交代了个主体,具体还得看一下hibernate的官方文档,