一对多映射的测试

Grade.java

import java.util.HashSet;
import java.util.Set;

public class Grade{
private Integer gid;
private String gname;
private String gdesc;

private Set<Students> students = new HashSet<Students>();

public Grade() {
}



public Grade(String gname, String gdesc) {
this.gname = gname;
this.gdesc = gdesc;
}


public String getGname() {
return gname;
}
public void setGname(String gname) {
this.gname = gname;
}
public String getDesc() {
return gdesc;
}
public void setDesc(String desc) {
this.gdesc = desc;
}


public Set<Students> getStudents() {
return students;
}


public void setStudents(Set<Students> students) {
this.students = students;
}

public Integer getGid() {
return gid;
}


public void setGid(Integer gid) {
this.gid = gid;
}
}

Students.java

public class Students{
private Integer sid;
private String sname;
private String gender;

public Students() {
}


public Students(String sname, String gender) {
this.sname = sname;
this.gender = gender;
}


public String getSname() {
return sname;
}


public void setSname(String sname) {
this.sname = sname;
}


public String getGender() {
return gender;
}


public void setGender(String gender) {
this.gender = gender;
}


public Integer getSid() {
return sid;
}


public void setSid(Integer sid) {
this.sid = sid;
}
}

Grade.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">
<!-- Generated 2015-10-27 13:51:23 by Hibernate Tools 3.4.0.CR1 -->
<hibernate-mapping>
    <class name="Grade" table="GRADE">
        <id name="gid" type="java.lang.Integer">
            <column name="GID" />
            <generator class="native" />
        </id>
        <property name="gname" type="java.lang.String">
            <column name="GNAME" />
        </property>
        <property name="gdesc" type="java.lang.String" access="field">
            <column name="GDESC" />
        </property>
        <set name="students" table="STUDENTS">
            <key>
                <column name="GID" />
            </key>
            <one-to-many class="Students" />
        </set>
    </class>
</hibernate-mapping>

Students.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">
<!-- Generated 2015-10-27 13:51:23 by Hibernate Tools 3.4.0.CR1 -->
<hibernate-mapping>
    <class name="Students" table="STUDENTS">
        <id name="sid" type="java.lang.Integer">
            <column name="SID" />
            <generator class="native" />
        </id>
        <property name="sname" type="java.lang.String">
            <column name="SNAME" />
        </property>
        <property name="gender" type="java.lang.String">
            <column name="GENDER" />
        </property>
    </class>
</hibernate-mapping>

One2ManyTest.java

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.ServiceRegistry;
import org.hibernate.service.ServiceRegistryBuilder;
import org.junit.After;
import org.junit.Before;
import org.junit.Ignore;
import org.junit.Test;


//测试类
public class One2ManyTest {


private SessionFactory sessionFactory;
private Session session;
private Transaction transaction;


@Before
public void init(){
Configuration config = new Configuration().configure();
        ServiceRegistry serviceRegistry = new ServiceRegistryBuilder().applySettings(config.getProperties()).buildServiceRegistry();
sessionFactory = config.buildSessionFactory(serviceRegistry);
session = sessionFactory.openSession();
transaction = session.beginTransaction();
}

@After
public void destroy(){
transaction.commit();
session.close();
sessionFactory.close();
}


@Test
@Ignore
public void one2ManyTest(){
Students s1 = new Students("张三", "男");
Students s2 = new Students("李四","女");
Grade g = new Grade("JAVA 一班","JAVA软件开发一班");
g.getStudents().add(s1);
g.getStudents().add(s2);
session.save(g);
session.save(s1);
session.save(s2);
}

*******************************************************************

实际发出的sql语句

Hibernate: insert into GRADE (GNAME, GDESC) values (?, ?)
Hibernate: insert into STUDENTS (SNAME, GENDER) values (?, ?)
Hibernate: insert into STUDENTS (SNAME, GENDER) values (?, ?)
Hibernate: update STUDENTS set GID=? where SID=?
Hibernate: update STUDENTS set GID=? where SID=?

*******************************************************************

@Test
@Ignore
public void one2ManyUpdate(){//将第一条学生的班级改为2班
Students s = (Students) session.get(Students.class, 1);
Grade g2 = new Grade("JAVA二班","JAVA软件开发二班");
g2.getStudents().add(s);
session.save(g2);
}

*******************************************************************

实际发出的sql语句

Hibernate: select students0_.SID as SID1_1_0_, students0_.SNAME as SNAME2_1_0_, students0_.GENDER as GENDER3_1_0_ from STUDENTS students0_ where students0_.SID=?
Hibernate: insert into GRADE (GNAME, GDESC) values (?, ?)
Hibernate: update STUDENTS set GID=? where SID=?

*******************************************************************

@Test
//@Ignore
public void one2ManyDelete(){
Students s = (Students) session.get(Students.class,2);
session.delete(s);
}
}

*******************************************************************

实际发出的sql语句

Hibernate: select students0_.SID as SID1_1_0_, students0_.SNAME as SNAME2_1_0_, students0_.GENDER as GENDER3_1_0_ from STUDENTS students0_ where students0_.SID=?
Hibernate: delete from STUDENTS where SID=?

*******************************************************************