复合主键映射（联合主键） .

最新推荐文章于 2023-07-20 15:09:00 发布
最新推荐文章于 2023-07-20 15:09:00 发布
阅读量2.5k 收藏
点赞数

联合主键的映射

1、类中的每个主键属性都对应到数据表中的每个主键的列

Hibernate要求具有联合主键的类首先要实现Serializable接口，其次要重写hashCode和equals方法，这两个方法可以使用Myeclipse帮助我们自动生成。重写这两个方法的原因在于Hibernate要根据数据库的联合主键来判断某两行记录是否是一样的，如果一样那么就认为是同一个对象，如果不一样，那么就认为是不同的对象。这反映到程序领域中就是根据hashCode与equals方法来判断某两个对象是否能够放到诸如set这样的集合当中。

2、举例：

[java] view plain copy print ?
  1. import java.io.Serializable;  
  2.   
  3. public class Student implements Serializable  
  4. {  
  5.     private String cardId;  
  6.       
  7.     private String name;  
  8.       
  9.     private int age;  
  10.   
  11.     public String getCardId()  
  12.     {  
  13.         return cardId;  
  14.     }  
  15.   
  16.     public void setCardId(String cardId)  
  17.     {  
  18.         this.cardId = cardId;  
  19.     }  
  20.   
  21.     public String getName()  
  22.     {  
  23.         return name;  
  24.     }  
  25.   
  26.     public void setName(String name)  
  27.     {  
  28.         this.name = name;  
  29.     }  
  30.   
  31.     public int getAge()  
  32.     {  
  33.         return age;  
  34.     }  
  35.   
  36.     public void setAge(int age)  
  37.     {  
  38.         this.age = age;  
  39.     }  
  40.   
  41.     @Override  
  42.     public int hashCode()  
  43.     {  
  44.         final int prime = 31;  
  45.         int result = 1;  
  46.         result = prime * result + ((cardId == null) ? 0 : cardId.hashCode());  
  47.         result = prime * result + ((name == null) ? 0 : name.hashCode());  
  48.         return result;  
  49.     }  
  50.   
  51.     @Override  
  52.     public boolean equals(Object obj)  
  53.     {  
  54.         if (this == obj)  
  55.             return true;  
  56.         if (obj == null)  
  57.             return false;  
  58.         if (getClass() != obj.getClass())  
  59.             return false;  
  60.         Student other = (Student) obj;  
  61.         if (cardId == null)  
  62.         {  
  63.             if (other.cardId != null)  
  64.                 return false;  
  65.         } else if (!cardId.equals(other.cardId))  
  66.             return false;  
  67.         if (name == null)  
  68.         {  
  69.             if (other.name != null)  
  70.                 return false;  
  71.         } else if (!name.equals(other.name))  
  72.             return false;  
  73.         return true;  
  74.     }  
  75.           
  76. }  
import java.io.Serializable;

public class Student implements Serializable
{
	private String cardId;
	
	private String name;
	
	private int age;

	public String getCardId()
	{
		return cardId;
	}

	public void setCardId(String cardId)
	{
		this.cardId = cardId;
	}

	public String getName()
	{
		return name;
	}

	public void setName(String name)
	{
		this.name = name;
	}

	public int getAge()
	{
		return age;
	}

	public void setAge(int age)
	{
		this.age = age;
	}

	@Override
	public int hashCode()
	{
		final int prime = 31;
		int result = 1;
		result = prime * result + ((cardId == null) ? 0 : cardId.hashCode());
		result = prime * result + ((name == null) ? 0 : name.hashCode());
		return result;
	}

	@Override
	public boolean equals(Object obj)
	{
		if (this == obj)
			return true;
		if (obj == null)
			return false;
		if (getClass() != obj.getClass())
			return false;
		Student other = (Student) obj;
		if (cardId == null)
		{
			if (other.cardId != null)
				return false;
		} else if (!cardId.equals(other.cardId))
			return false;
		if (name == null)
		{
			if (other.name != null)
				return false;
		} else if (!name.equals(other.name))
			return false;
		return true;
	}
		
}

这个类实现了serializable，并且重写了hashCode和equals方法，这两个方法是根据cardId和name来计算的，这两个属性是联合主键。

对应的映射文件：

[html] view plain copy print ?
  1. <?xml version="1.0" encoding="UTF-8"?>  
  2. <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"  
  3. "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">  
  4.   
  5. <hibernate-mapping>  
  6.       
  7.     <class name="com.cdtax.hibernate.Student" table="student">  
  8.       
  9.         <<SPAN style="COLOR: #ff0000">composite-id></SPAN>  
  10.             <key-property name="cardId" column="cardid" type="string"></key-property>  
  11.             <key-property name="name" column="name" type="string"></key-property>  
  12.         </composite-id>  
  13.         <property name="age" column="age" type="integer"></property>  
  14.           
  15.     </class>  
  16. </hibernate-mapping>  
<?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>
	
	<class name="com.cdtax.hibernate.Student" table="student">
	
		<<span style="color:#ff0000;">composite-id></span>
			<key-property name="cardId" column="cardid" type="string"></key-property>
			<key-property name="name" column="name" type="string"></key-property>
		</composite-id>
		<property name="age" column="age" type="integer"></property>
		
	</class>
</hibernate-mapping>
这里使用了<composite-id>联合id，这就是联合主键映射使用的标签。

创建数据库表

create table student (cardid varchar(255) not null, name varchar(255) not null, age integer, primary key (cardid, name))

注意primary key，是两个字段
保存测试：

[java] view plain copy print ?
  1. try  
  2.         {  
  3.             tx = session.beginTransaction();  
  4.               
  5.             Student st = new Student();  
  6.             st.setName("zhangda");  
  7.             st.setCardId("123456");  
  8.             st.setAge(20);  
  9.             session.save(st);  
  10.             tx.commit();  
  11.         }  
try
		{
			tx = session.beginTransaction();
			
			Student st = new Student();
			st.setName("zhangda");
			st.setCardId("123456");
			st.setAge(20);
			session.save(st);
			tx.commit();
		}

执行结果：

Hibernate: insert into student (age, cardid, name) values (?, ?, ?)

如果再次执行：

Hibernate: insert into student (age, cardid, name) values (?, ?, ?)
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1028)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:366)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
at com.cdtax.hibernate.HibernateTest.main(HibernateTest.java:42)
Caused by: java.sql.BatchUpdateException: Duplicate entry '123456-zhangda' for key 1
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1269)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:955)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
... 8 more

出现了异常，因为主键重复了。

3、取数据

因为主键是两列了，就不能简单使用以前的get()或load()fang方法了，需要使用get或load的第二种方法

联合主键的实体类实现了serializable接口的原因在于使用get或load方法的时候需要先构建出来该实体的对象，并且将查询依据（联合主键）设置进去，然后作为get或load方法的第二个参数传进去即可。

[java] view plain copy print ?
  1.         try  
  2.         {  
  3.             tx = session.beginTransaction();  
  4.               
  5. //          Student st = new Student();   
  6. //          st.setName("zhangda");   
  7. //          st.setCardId("123456");   
  8. //          st.setAge(20);   
  9. //          session.save(st);   
  10.               
  11.             Student studentPrimaryKey = new Student();  
  12.             studentPrimaryKey.setCardId("123456");  
  13.             studentPrimaryKey.setName("zhangda");  
  14.               
  15.             Student student = (Student)session.get(Student.class, studentPrimaryKey);  
  16.               
  17.             System.out.println(student.getAge());  
  18.             System.out.println(studentPrimaryKey.getAge());  
  19.               
  20.             tx.commit();  
  21.         }  
		try
		{
			tx = session.beginTransaction();
			
//			Student st = new Student();
//			st.setName("zhangda");
//			st.setCardId("123456");
//			st.setAge(20);
//			session.save(st);
			
			Student studentPrimaryKey = new Student();
			studentPrimaryKey.setCardId("123456");
			studentPrimaryKey.setName("zhangda");
			
			Student student = (Student)session.get(Student.class, studentPrimaryKey);
			
			System.out.println(student.getAge());
			System.out.println(studentPrimaryKey.getAge());
			
			tx.commit();
		}

执行结果：

Hibernate: select student0_.cardid as cardid0_0_, student0_.name as name0_0_, student0_.age as age0_0_ from student student0_ where student0_.cardid=? and student0_.name=?
20
20

对于studentPrimaryKey.getAge()，我们没有为studentPrimaryKey的age赋值，hibernate也为我们设置进去了。

4、实现联合主键的另一种方法，将主键所对应的属性提取出一个类（称之为主键类），并且主键类需要实现Serializable接口，重写equals方法与hashCode方法，原因与上面一样。

[java] view plain copy print ?
  1. import java.io.Serializable;  
  2.   
  3. public class StudentPrimaryKey implements Serializable  
  4. {  
  5.     private String cardId;  
  6.     private String name;  
  7.     public String getCardId()  
  8.     {  
  9.         return cardId;  
  10.     }  
  11.     public void setCardId(String cardId)  
  12.     {  
  13.         this.cardId = cardId;  
  14.     }  
  15.     public String getName()  
  16.     {  
  17.         return name;  
  18.     }  
  19.     public void setName(String name)  
  20.     {  
  21.         this.name = name;  
  22.     }  
  23.     @Override  
  24.     public int hashCode()  
  25.     {  
  26.         final int prime = 31;  
  27.         int result = 1;  
  28.         result = prime * result + ((cardId == null) ? 0 : cardId.hashCode());  
  29.         result = prime * result + ((name == null) ? 0 : name.hashCode());  
  30.         return result;  
  31.     }  
  32.     @Override  
  33.     public boolean equals(Object obj)  
  34.     {  
  35.         if (this == obj)  
  36.             return true;  
  37.         if (obj == null)  
  38.             return false;  
  39.         if (getClass() != obj.getClass())  
  40.             return false;  
  41.         StudentPrimaryKey other = (StudentPrimaryKey) obj;  
  42.         if (cardId == null)  
  43.         {  
  44.             if (other.cardId != null)  
  45.                 return false;  
  46.         } else if (!cardId.equals(other.cardId))  
  47.             return false;  
  48.         if (name == null)  
  49.         {  
  50.             if (other.name != null)  
  51.                 return false;  
  52.         } else if (!name.equals(other.name))  
  53.             return false;  
  54.         return true;  
  55.     }  
  56.       
  57. }  
import java.io.Serializable;

public class StudentPrimaryKey implements Serializable
{
	private String cardId;
	private String name;
	public String getCardId()
	{
		return cardId;
	}
	public void setCardId(String cardId)
	{
		this.cardId = cardId;
	}
	public String getName()
	{
		return name;
	}
	public void setName(String name)
	{
		this.name = name;
	}
	@Override
	public int hashCode()
	{
		final int prime = 31;
		int result = 1;
		result = prime * result + ((cardId == null) ? 0 : cardId.hashCode());
		result = prime * result + ((name == null) ? 0 : name.hashCode());
		return result;
	}
	@Override
	public boolean equals(Object obj)
	{
		if (this == obj)
			return true;
		if (obj == null)
			return false;
		if (getClass() != obj.getClass())
			return false;
		StudentPrimaryKey other = (StudentPrimaryKey) obj;
		if (cardId == null)
		{
			if (other.cardId != null)
				return false;
		} else if (!cardId.equals(other.cardId))
			return false;
		if (name == null)
		{
			if (other.name != null)
				return false;
		} else if (!name.equals(other.name))
			return false;
		return true;
	}
	
}

[java] view plain copy print ?
  1. import java.io.Serializable;  
  2.   
  3. public class Student  
  4. {  
  5.     private StudentPrimaryKey studentPrimaryKey;       
  6.     private int age;  
  7.   
  8.     public int getAge()  
  9.     {  
  10.         return age;  
  11.     }  
  12.   
  13.     public void setAge(int age)  
  14.     {  
  15.         this.age = age;  
  16.     }  
  17.   
  18.     public StudentPrimaryKey getStudentPrimaryKey()  
  19.     {  
  20.         return studentPrimaryKey;  
  21.     }  
  22.   
  23.     public void setStudentPrimaryKey(StudentPrimaryKey studentPrimaryKey)  
  24.     {  
  25.         this.studentPrimaryKey = studentPrimaryKey;  
  26.     }  
  27.   
  28. }  
import java.io.Serializable;

public class Student
{
	private StudentPrimaryKey studentPrimaryKey; 	 
	private int age;

	public int getAge()
	{
		return age;
	}

	public void setAge(int age)
	{
		this.age = age;
	}

	public StudentPrimaryKey getStudentPrimaryKey()
	{
		return studentPrimaryKey;
	}

	public void setStudentPrimaryKey(StudentPrimaryKey studentPrimaryKey)
	{
		this.studentPrimaryKey = studentPrimaryKey;
	}

}

映射文件：

[html] view plain copy print ?
  1. <?xml version="1.0" encoding="UTF-8"?>  
  2. <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"  
  3. "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">  
  4.   
  5. <hibernate-mapping>  
  6.       
  7.     <class name="com.cdtax.hibernate.Student" table="student">  
  8.       
  9.         <composite-id <SPAN style="COLOR: #ff0000">name="studentPrimaryKey" class="com.cdtax.hibernate.StudentPrimaryKey"</SPAN>>  
  10.             <key-property name="cardId" column="cardid" type="string"></key-property>  
  11.             <key-property name="name" column="name" type="string"></key-property>  
  12.         </composite-id>  
  13.         <property name="age" column="age" type="integer"></property>  
  14.           
  15.     </class>  
  16. </hibernate-mapping>  
<?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>
	
	<class name="com.cdtax.hibernate.Student" table="student">
	
		<composite-id <span style="color:#ff0000;">name="studentPrimaryKey" class="com.cdtax.hibernate.StudentPrimaryKey"</span>>
			<key-property name="cardId" column="cardid" type="string"></key-property>
			<key-property name="name" column="name" type="string"></key-property>
		</composite-id>
		<property name="age" column="age" type="integer"></property>
		
	</class>
</hibernate-mapping>

映射文件在composite-id上增加了name和class属相，其他不变

生成表：

drop table if exists student
create table student (cardid varchar(255) not null, name varchar(255) not null, age integer, primary key (cardid, name))

[java] view plain copy print ?
  1. try  
  2.         {  
  3.             tx = session.beginTransaction();  
  4.               
  5.             Student st = new Student();  
  6.               
  7.             st.setAge(20);  
  8.               
  9.             StudentPrimaryKey spk = new StudentPrimaryKey();  
  10.               
  11.             spk.setCardId("1234567");  
  12.             spk.setName("zhangsan");  
  13.               
  14.             st.setStudentPrimaryKey(spk);  
  15.               
  16.             session.save(st);  
  17.               
  18.             tx.commit();  
  19.         }  
try
		{
			tx = session.beginTransaction();
			
			Student st = new Student();
			
			st.setAge(20);
			
			StudentPrimaryKey spk = new StudentPrimaryKey();
			
			spk.setCardId("1234567");
			spk.setName("zhangsan");
			
			st.setStudentPrimaryKey(spk);
			
			session.save(st);
			
			tx.commit();
		}

查询

[java] view plain copy print ?
  1. try  
  2. {  
  3.     tx = session.beginTransaction();  
  4.       
  5.   
  6.       
  7.     StudentPrimaryKey spk = new StudentPrimaryKey();  
  8.       
  9.     spk.setCardId("1234567");  
  10.     spk.setName("zhangsan");  
  11.       
  12.     Student student = (Student)session.get(Student.class, spk);  
  13.   
  14.     System.out.println(student.getAge());  
  15.     tx.commit();  
  16. }  
		try
		{
			tx = session.beginTransaction();
			

			
			StudentPrimaryKey spk = new StudentPrimaryKey();
			
			spk.setCardId("1234567");
			spk.setName("zhangsan");
			
			Student student = (Student)session.get(Student.class, spk);

			System.out.println(student.getAge());
			tx.commit();
		}

Hibernate: select student0_.cardid as cardid0_0_, student0_.name as name0_0_, student0_.age as age0_0_ from student student0_ where student0_.cardid=? and student0_.name=?

20

5、采用component（组件）标签进行映射，这种方式适用于类的成员变量还有另一个类，如学生Student有一个Address属性

[java] view plain copy print ?
  1. import java.io.Serializable;  
  2.   
  3. public class Student  
  4. {  
  5.     private String id;  
  6.     private String name;  
  7.     private Address address;  
  8.       
  9.     public String getId()  
  10.     {  
  11.         return id;  
  12.     }  
  13.     public void setId(String id)  
  14.     {  
  15.         this.id = id;  
  16.     }  
  17.     public String getName()  
  18.     {  
  19.         return name;  
  20.     }  
  21.     public void setName(String name)  
  22.     {  
  23.         this.name = name;  
  24.     }  
  25.     public Address getAddress()  
  26.     {  
  27.         return address;  
  28.     }  
  29.     public void setAddress(Address address)  
  30.     {  
  31.         this.address = address;  
  32.     }  
  33.       
  34.       
  35. }  
import java.io.Serializable;

public class Student
{
	private String id;
	private String name;
	private Address address;
	
	public String getId()
	{
		return id;
	}
	public void setId(String 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;
	}
	
	
}

[java] view plain copy print ?
  1. public class Address  
  2. {  
  3.     private String homeAddress;  
  4.     private String schoolAddress;  
  5.       
  6.     public String getHomeAddress()  
  7.     {  
  8.         return homeAddress;  
  9.     }  
  10.     public void setHomeAddress(String homeAddress)  
  11.     {  
  12.         this.homeAddress = homeAddress;  
  13.     }  
  14.     public String getSchoolAddress()  
  15.     {  
  16.         return schoolAddress;  
  17.     }  
  18.     public void setSchoolAddress(String schoolAddress)  
  19.     {  
  20.         this.schoolAddress = schoolAddress;  
  21.     }  
  22. }  
public class Address
{
	private String homeAddress;
	private String schoolAddress;
	
	public String getHomeAddress()
	{
		return homeAddress;
	}
	public void setHomeAddress(String homeAddress)
	{
		this.homeAddress = homeAddress;
	}
	public String getSchoolAddress()
	{
		return schoolAddress;
	}
	public void setSchoolAddress(String schoolAddress)
	{
		this.schoolAddress = schoolAddress;
	}
}

映射文件：

[html] view plain copy print ?
  1. <?xml version="1.0" encoding="UTF-8"?>  
  2. <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"  
  3. "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">  
  4.   
  5. <hibernate-mapping>  
  6.       
  7.     <class name="com.cdtax.hibernate.Student" table="student">  
  8.       
  9.         <id name="id" column="id" type="string">  
  10.             <generator class="uuid"></generator>  
  11.         </id>  
  12.           
  13.         <property name="name" column="name" type="string"></property>  
  14.       
  15.         <<SPAN style="COLOR: #ff0000">component</SPAN> name="address" class="com.cdtax.hibernate.Address">  
  16.             <property name="homeAddress" type="string"></property>  
  17.             <property name="schoolAddress" type="string"></property>          
  18.         <<SPAN style="COLOR: #ff0000">/component</SPAN>>  
  19.     </class>  
  20. </hibernate-mapping>  
<?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>
	
	<class name="com.cdtax.hibernate.Student" table="student">
	
		<id name="id" column="id" type="string">
			<generator class="uuid"></generator>
		</id>
		
		<property name="name" column="name" type="string"></property>
	
		<<span style="color:#ff0000;">component</span> name="address" class="com.cdtax.hibernate.Address">
			<property name="homeAddress" type="string"></property>
			<property name="schoolAddress" type="string"></property>		
		<<span style="color:#ff0000;">/component</span>>
	</class>
</hibernate-mapping>
对于address的映射，采用了component标签

生成数据库表：

create table student (id varchar(255) not null, name varchar(255), homeAddress varchar(255), schoolAddress varchar(255), primary key (id))

注意homeAddress和schoolAddress在一张表中

测试：保存

[java] view plain copy print ?
  1. try  
  2.         {  
  3.             tx = session.beginTransaction();  
  4.               
  5.             Student student = new Student();  
  6.             Address address = new Address();  
  7.               
  8.             address.setHomeAddress("beijing");  
  9.             address.setSchoolAddress("shanghai");  
  10.               
  11.             student.setName("zhangsan");  
  12.             student.setAddress(address);  
  13.               
  14.             session.save(student);  
  15.   
  16.             tx.commit();  
  17.         }  
try
		{
			tx = session.beginTransaction();
			
			Student student = new Student();
			Address address = new Address();
			
			address.setHomeAddress("beijing");
			address.setSchoolAddress("shanghai");
			
			student.setName("zhangsan");
			student.setAddress(address);
			
			session.save(student);

			tx.commit();
		}

查询：

[java] view plain copy print ?
  1. try  
  2.         {  
  3.             tx = session.beginTransaction();  
  4.               
  5.   
  6.             Student student = (Student)session.get(Student.class, "402881c0424a0d3101424a0d32930001");  
  7.               
  8.             System.out.println(student.getName());  
  9.             System.out.println(student.getAddress().getHomeAddress());  
  10.             System.out.println(student.getAddress().getSchoolAddress());  
  11.             tx.commit();  
  12.         }  
try
		{
			tx = session.beginTransaction();
			

			Student student = (Student)session.get(Student.class, "402881c0424a0d3101424a0d32930001");
			
			System.out.println(student.getName());
			System.out.println(student.getAddress().getHomeAddress());
			System.out.println(student.getAddress().getSchoolAddress());
			tx.commit();
		}

6、Set类型使用component组件进行映射

[java] view plain copy print ?
  1. import java.util.HashSet;  
  2. import java.util.Set;  
  3.   
  4. public class Student  
  5. {  
  6.     private String id;  
  7.     private String name;  
  8.     private <SPAN style="COLOR: #ff0000">Set contacts = new HashSet()</SPAN>;  
  9.       
  10.     public String getId()  
  11.     {  
  12.         return id;  
  13.     }  
  14.     public void setId(String id)  
  15.     {  
  16.         this.id = id;  
  17.     }  
  18.     public String getName()  
  19.     {  
  20.         return name;  
  21.     }  
  22.     public void setName(String name)  
  23.     {  
  24.         this.name = name;  
  25.     }  
  26.     public Set getContacts()  
  27.     {  
  28.         return contacts;  
  29.     }  
  30.     public void setContacts(Set contacts)  
  31.     {  
  32.         this.contacts = contacts;  
  33.     }  
  34.       
  35. }  
import java.util.HashSet;
import java.util.Set;

public class Student
{
	private String id;
	private String name;
	private <span style="color:#ff0000;">Set contacts = new HashSet()</span>;
	
	public String getId()
	{
		return id;
	}
	public void setId(String id)
	{
		this.id = id;
	}
	public String getName()
	{
		return name;
	}
	public void setName(String name)
	{
		this.name = name;
	}
	public Set getContacts()
	{
		return contacts;
	}
	public void setContacts(Set contacts)
	{
		this.contacts = contacts;
	}
	
}

[java] view plain copy print ?
  1. public class Contact  
  2. {  
  3.     <SPAN style="COLOR: #ff0000">private String student_id;</SPAN>  
  4.     private String method;  
  5.     private String address;  
  6.       
  7.       
  8.     public String getStudent_id()  
  9.     {  
  10.         return student_id;  
  11.     }  
  12.     public void setStudent_id(String student_id)  
  13.     {  
  14.         this.student_id = student_id;  
  15.     }  
  16.     public String getMethod()  
  17.     {  
  18.         return method;  
  19.     }  
  20.     public void setMethod(String method)  
  21.     {  
  22.         this.method = method;  
  23.     }  
  24.     public String getAddress()  
  25.     {  
  26.         return address;  
  27.     }  
  28.     public void setAddress(String address)  
  29.     {  
  30.         this.address = address;  
  31.     }  
  32.       
  33.       
  34. }  
public class Contact
{
	<span style="color:#ff0000;">private String student_id;</span>
	private String method;
	private String address;
	
	
	public String getStudent_id()
	{
		return student_id;
	}
	public void setStudent_id(String student_id)
	{
		this.student_id = student_id;
	}
	public String getMethod()
	{
		return method;
	}
	public void setMethod(String method)
	{
		this.method = method;
	}
	public String getAddress()
	{
		return address;
	}
	public void setAddress(String address)
	{
		this.address = address;
	}
	
	
}

映射文件：

[html] view plain copy print ?
  1. <?xml version="1.0" encoding="UTF-8"?>  
  2. <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"  
  3. "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">  
  4.   
  5. <hibernate-mapping>  
  6.       
  7.     <class name="com.cdtax.hibernate.Student" table="student">  
  8.       
  9.         <id name="id" column="id" type="string">  
  10.             <generator class="uuid"></generator>  
  11.         </id>  
  12.           
  13.         <property name="name" column="name" type="string"></property>  
  14.       
  15.         <<SPAN style="COLOR: #ff0000">set name="contacts" table="contact">  
  16.             <key column="student_id"></key>  
  17.               
  18.             <composite-element class="com.cdtax.hibernate.Contact">  
  19.                 <property name="method" type="string"></property>  
  20.                 <property name="address" type="string"></property>  
  21.             </composite-element>  
  22.         </set></SPAN>  
  23.           
  24.     </class>  
  25. </hibernate-mapping>  
<?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>
	
	<class name="com.cdtax.hibernate.Student" table="student">
	
		<id name="id" column="id" type="string">
			<generator class="uuid"></generator>
		</id>
		
		<property name="name" column="name" type="string"></property>
	
		<<span style="color:#ff0000;">set name="contacts" table="contact">
			<key column="student_id"></key>
			
			<composite-element class="com.cdtax.hibernate.Contact">
				<property name="method" type="string"></property>
				<property name="address" type="string"></property>
			</composite-element>
		</set></span>
		
	</class>
</hibernate-mapping>
Set是一对多关系，使用以前的配置要使用one-to-many，并且要使用两个配置文件，建议使用，关系看着明晰，这里使用composite-element标签，组合元素
生成数据库表：

create table contact (student_id varchar(255) not null, method varchar(255), address varchar(255))
create table student (id varchar(255) not null, name varchar(255), primary key (id))
alter table contact add index FK38B7242045A3E36D (student_id), add constraint FK38B7242045A3E36D foreign key (student_id) references student (id)

插入数据

[java] view plain copy print ?
  1. try  
  2.         {  
  3.             tx = session.beginTransaction();  
  4.               
  5.             Student student = new Student();  
  6.             student.setName("zhangsan11");  
  7.               
  8.             Contact contact1 = new Contact();  
  9.             contact1.setMethod("telphone");  
  10.             contact1.setAddress("123456");  
  11.               
  12.             Contact contact2 = new Contact();  
  13.             contact2.setMethod("address");  
  14.             contact2.setAddress("beijing");  
  15.               
  16.             student.getContacts().add(contact1);  
  17.             student.getContacts().add(contact2);  
  18.               
  19.             session.save(student);  
  20.   
  21.             tx.commit();  
  22.         }  
try
		{
			tx = session.beginTransaction();
			
			Student student = new Student();
			student.setName("zhangsan11");
			
			Contact contact1 = new Contact();
			contact1.setMethod("telphone");
			contact1.setAddress("123456");
			
			Contact contact2 = new Contact();
			contact2.setMethod("address");
			contact2.setAddress("beijing");
			
			student.getContacts().add(contact1);
			student.getContacts().add(contact2);
			
			session.save(student);

			tx.commit();
		}

结果：

Hibernate: insert into student (name, id) values (?, ?)
Hibernate: insert into contact (student_id, method, address) values (?, ?, ?)
Hibernate: insert into contact (student_id, method, address) values (?, ?, ?)

7、继承映射

（1）、每个子类一张表

[java] view plain copy print ?
  1. public class Person  
  2. {  
  3.     private String id;  
  4.     private String name;  
  5.     public String getId()  
  6.     {  
  7.         return id;  
  8.     }  
  9.     public void setId(String id)  
  10.     {  
  11.         this.id = id;  
  12.     }  
  13.     public String getName()  
  14.     {  
  15.         return name;  
  16.     }  
  17.     public void setName(String name)  
  18.     {  
  19.         this.name = name;  
  20.     }  
  21.       
  22.       
  23. }  
public class Person
{
	private String id;
	private String name;
	public String getId()
	{
		return id;
	}
	public void setId(String id)
	{
		this.id = id;
	}
	public String getName()
	{
		return name;
	}
	public void setName(String name)
	{
		this.name = name;
	}
	
	
}

[java] view plain copy print ?
  1. public class Student extends Person  
  2. {  
  3.     private String cardId;  
  4.   
  5.     public String getCardId()  
  6.     {  
  7.         return cardId;  
  8.     }  
  9.   
  10.     public void setCardId(String cardId)  
  11.     {  
  12.         this.cardId = cardId;  
  13.     }  
  14.       
  15. }  
public class Student extends Person
{
	private String cardId;

	public String getCardId()
	{
		return cardId;
	}

	public void setCardId(String cardId)
	{
		this.cardId = cardId;
	}
	
}

[java] view plain copy print ?
  1. public class Teacher extends Person  
  2. {  
  3.     private int salary;  
  4.   
  5.     public int getSalary()  
  6.     {  
  7.         return salary;  
  8.     }  
  9.   
  10.     public void setSalary(int salary)  
  11.     {  
  12.         this.salary = salary;  
  13.     }  
  14.       
  15. }  
public class Teacher extends Person
{
	private int salary;

	public int getSalary()
	{
		return salary;
	}

	public void setSalary(int salary)
	{
		this.salary = salary;
	}
	
}

Student和Teacher继承了Person

映射文件：

[html] view plain copy print ?
  1. <?xml version="1.0" encoding="UTF-8"?>  
  2. <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"  
  3. "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">  
  4.   
  5. <hibernate-mapping>  
  6.       
  7.     <class name="com.cdtax.hibernate.Student" table="student">  
  8.       
  9.         <id name="id" column="id" type="string">  
  10.             <generator class="uuid"></generator>  
  11.         </id>  
  12.           
  13.         <property name="name" column="name" type="string"></property>  
  14.       
  15.         <property name="cardId" column="cardid" type="string"></property>     
  16.     </class>  
  17. </hibernate-mapping>  
<?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>
	
	<class name="com.cdtax.hibernate.Student" table="student">
	
		<id name="id" column="id" type="string">
			<generator class="uuid"></generator>
		</id>
		
		<property name="name" column="name" type="string"></property>
	
		<property name="cardId" column="cardid" type="string"></property>	
	</class>
</hibernate-mapping>

[html] view plain copy print ?
  1. <?xml version="1.0" encoding="UTF-8"?>  
  2. <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"  
  3. "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">  
  4.   
  5. <hibernate-mapping>  
  6.       
  7.     <class name="com.cdtax.hibernate.Teacher" table="teacher">  
  8.       
  9.         <id name="id" column="id" type="string">  
  10.             <generator class="uuid"></generator>  
  11.         </id>  
  12.           
  13.         <property name="name" column="name" type="string"></property>  
  14.       
  15.         <property name="salary" column="salary" type="int"></property>    
  16.     </class>  
  17. </hibernate-mapping>  
<?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>
	
	<class name="com.cdtax.hibernate.Teacher" table="teacher">
	
		<id name="id" column="id" type="string">
			<generator class="uuid"></generator>
		</id>
		
		<property name="name" column="name" type="string"></property>
	
		<property name="salary" column="salary" type="int"></property>	
	</class>
</hibernate-mapping>

创建表：

create table student (id varchar(255) not null, name varchar(255), cardid varchar(255), primary key (id))
create table teacher (id varchar(255) not null, name varchar(255), salary integer, primary key (id))

保存测试：

[java] view plain copy print ?
  1. try  
  2.         {  
  3.             tx = session.beginTransaction();  
  4.               
  5.             Student student = new Student();  
  6.             student.setCardId("123456");  
  7.             student.setName("zhangsan");  
  8.               
  9.             Teacher teacher = new Teacher();  
  10.             teacher.setSalary(100);  
  11.             teacher.setName("lisi");  
  12.               
  13.               
  14.             session.save(student);  
  15.             session.save(teacher);  
  16.   
  17.             tx.commit();  
  18.         }  
try
		{
			tx = session.beginTransaction();
			
			Student student = new Student();
			student.setCardId("123456");
			student.setName("zhangsan");
			
			Teacher teacher = new Teacher();
			teacher.setSalary(100);
			teacher.setName("lisi");
			
			
			session.save(student);
			session.save(teacher);

			tx.commit();
		}
查询：

[java] view plain copy print ?
  1. try  
  2.         {  
  3.             tx = session.beginTransaction();  
  4.               
  5.   
  6.   
  7.             Query query = session.createQuery("from<SPAN style="COLOR: #ff0000"> com.cdtax.hibernate.Person</SPAN>");//多态查询，父类，会查询所有子类   
  8.               
  9.             Iterator iter = query.iterate();  
  10.               
  11.             while(iter.hasNext())  
  12.             {  
  13.                 Person p = (Person)iter.next();  
  14.                 System.out.println(p.getName());  
  15.             }  
  16.             tx.commit();  
  17.         }  
try
		{
			tx = session.beginTransaction();
			


			Query query = session.createQuery("from<span style="color:#ff0000;"> com.cdtax.hibernate.Person</span>");//多态查询，父类，会查询所有子类
			
			Iterator iter = query.iterate();
			
			while(iter.hasNext())
			{
				Person p = (Person)iter.next();
				System.out.println(p.getName());
			}
			tx.commit();
		}
我们使用HQL进行查询，查询使用的是父类，这是多态查询，hibernate会查询所有继承了Person的子类，这里要注意写上类的全称，就是加上包的名字，如果不加，这样：

from Person，就会出现异常：因为没有Person的映射文件，在没有映射文件的时候，就要写类的全称。

org.hibernate.hql.ast.QuerySyntaxException: Person is not mapped [from Person]
at org.hibernate.hql.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:181)
at org.hibernate.hql.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:110)
at org.hibernate.hql.ast.tree.FromClause.addFromElement(FromClause.java:94)
at org.hibernate.hql.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:316)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3228)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:3112)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:720)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:571)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:288)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:231)
at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:254)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:185)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1651)
at com.cdtax.hibernate.HibernateTest.main(HibernateTest.java:49)
执行的结果：

Hibernate: select teacher0_.id as col_0_0_ from teacher teacher0_
Hibernate: select student0_.id as col_0_0_ from student student0_
Hibernate: select teacher0_.id as id1_0_, teacher0_.name as name1_0_, teacher0_.salary as salary1_0_ from teacher teacher0_ where teacher0_.id=?
lisi
Hibernate: select student0_.id as id0_0_, student0_.name as name0_0_, student0_.cardid as cardid0_0_ from student student0_ where student0_.id=?
zhangsan

打印出类的名称：

[java] view plain copy print ?
  1. try  
  2.         {  
  3.             tx = session.beginTransaction();  
  4.               
  5.   
  6.   
  7.             Query query = session.createQuery("from java.lang.Object");//多态查询，父类，会查询所有子类   
  8.               
  9.             Iterator iter = query.iterate();  
  10.               
  11.             while(iter.hasNext())  
  12.             {  
  13.                 Person p = (Person)iter.next();  
  14.                   
  15.                 System.out.println(p.getClass().getName());  
  16.                 System.out.println(p.getName());  
  17.             }  
  18.             tx.commit();  
  19.         }  
try
		{
			tx = session.beginTransaction();
			


			Query query = session.createQuery("from java.lang.Object");//多态查询，父类，会查询所有子类
			
			Iterator iter = query.iterate();
			
			while(iter.hasNext())
			{
				Person p = (Person)iter.next();
				
				System.out.println(p.getClass().getName());
				System.out.println(p.getName());
			}
			tx.commit();
		}
结果：

Hibernate: select teacher0_.id as col_0_0_ from teacher teacher0_
Hibernate: select student0_.id as col_0_0_ from student student0_
com.cdtax.hibernate.Teacher_$$_javassist_0
Hibernate: select teacher0_.id as id1_0_, teacher0_.name as name1_0_, teacher0_.salary as salary1_0_ from teacher teacher0_ where teacher0_.id=?
lisi
com.cdtax.hibernate.Student_$$_javassist_1
Hibernate: select student0_.id as id0_0_, student0_.name as name0_0_, student0_.cardid as cardid0_0_ from student student0_ where student0_.id=?
zhangsan

可以使用一种极端的情况，HQL中查询Object：from java.lang.Object

结果：

Hibernate: select teacher0_.id as col_0_0_ from teacher teacher0_
Hibernate: select student0_.id as col_0_0_ from student student0_
com.cdtax.hibernate.Teacher_$$_javassist_0
com.cdtax.hibernate.Student_$$_javassist_1

一样查询出来了。

也可以使用接口来查询，所有实现了给定接口的类都会被查询出来。

（2）、一张表存储继承体系中所有类的信息（数据库表实际上是继承体系中所有类的属性的并集所构成的字段）



需要在HBM文件中增加如下一行：

<discriminator column="personType" type="string"></discriminator>

这样在生成的表中增加这样一列。这一列来表明这一行是Teacher或Student。

最后表的结构：


举例：

Person、Student、Teacher类如上不变

对应的映射文件：

[html] view plain copy print ?
  1. <?xml version="1.0" encoding="UTF-8"?>  
  2. <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"  
  3. "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">  
  4.   
  5. <hibernate-mapping>  
  6.       
  7.     <class name="com.cdtax.hibernate.Person" table="person">  
  8.       
  9.         <id name="id" column="id" type="string">  
  10.             <generator class="uuid"></generator>  
  11.         </id>  
  12.         <SPAN style="COLOR: #ff0000"><discriminator column="personType" type="string"></discriminator></SPAN>  
  13.           
  14.         <property name="name" column="name" type="string"></property>  
  15.   
  16.         <SPAN style="COLOR: #ff0000"><subclass name="com.cdtax.hibernate.Student" discriminator-value="student">  
  17.             <property name="cardId" type="string"></property>  
  18.         </subclass>             
  19.           
  20.         <subclass name="com.cdtax.hibernate.Teacher" discriminator-value="teacher">  
  21.             <property name="salary" type="int"></property>  
  22.         </subclass></SPAN>  
  23.           
  24.     </class>  
  25. </hibernate-mapping>  
<?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>
	
	<class name="com.cdtax.hibernate.Person" table="person">
	
		<id name="id" column="id" type="string">
			<generator class="uuid"></generator>
		</id>
		<span style="color:#ff0000;"><discriminator column="personType" type="string"></discriminator></span>
		
		<property name="name" column="name" type="string"></property>

		<span style="color:#ff0000;"><subclass name="com.cdtax.hibernate.Student" discriminator-value="student">
			<property name="cardId" type="string"></property>
		</subclass>			
		
		<subclass name="com.cdtax.hibernate.Teacher" discriminator-value="teacher">
			<property name="salary" type="int"></property>
		</subclass></span>
		
	</class>
</hibernate-mapping>
discriminator标签用来标明增加一列来对每一行是学生还是教师进行区别。

然后要增加subclass标签，来指明Person类的子类，有多少子类就要配置几个。subclasss标签的要有一个discriminator-value属性，其值标明这个子类在数据库表中discriminator字段的值。

产生的数据表：

create table person (id varchar(255) not null, personType varchar(255) not null, name varchar(255), cardId varchar(255), salary integer, primary key (id))
保存数据：

[java] view plain copy print ?
  1. try  
  2.         {  
  3.             tx = session.beginTransaction();  
  4.               
  5.             Student student = new Student();  
  6.             student.setCardId("123456");  
  7.             student.setName("zhzdsafds");  
  8.               
  9.             Teacher teacher = new Teacher();  
  10.             teacher.setSalary(100);  
  11.             teacher.setName("lisi");  
  12.               
  13.             session.save(student);  
  14.             session.save(teacher);  
  15.   
  16.   
  17.             tx.commit();  
  18.         }  
try
		{
			tx = session.beginTransaction();
			
			Student student = new Student();
			student.setCardId("123456");
			student.setName("zhzdsafds");
			
			Teacher teacher = new Teacher();
			teacher.setSalary(100);
			teacher.setName("lisi");
			
			session.save(student);
			session.save(teacher);


			tx.commit();
		}

结果：

Hibernate: insert into person (name, cardId, personType, id) values (?, ?, 'student', ?)
Hibernate: insert into person (name, salary, personType, id) values (?, ?, 'teacher', ?)

数据库数据：

idpersonTypenamecardIdsalary
402881c0424b61fd01424b61fdec0001studentzhzdsafds123456null
402881c0424b61fd01424b61fdfc0002teacherlisinull100
查询数据：

[java] view plain copy print ?
  1. try  
  2.         {  
  3.             tx = session.beginTransaction();  
  4.   
  5.             // Student student = new Student();   
  6.             // student.setCardId("123456");   
  7.             // student.setName("zhzdsafds");   
  8.             //   
  9.             // Teacher teacher = new Teacher();   
  10.             // teacher.setSalary(100);   
  11.             // teacher.setName("lisi");   
  12.             //   
  13.             // session.save(student);   
  14.             // session.save(teacher);   
  15.   
  16.             Query query = session.createQuery("from Person");  
  17.               
  18.             Iterator iter = query.iterate();  
  19.   
  20.             while (iter.hasNext())  
  21.             {  
  22.                 Person p = (Person) iter.next();  
  23.   
  24.                 System.out.println(p.getClass().getName());  
  25.                 System.out.println(p.getName());  
  26.             }  
  27.   
  28.             tx.commit();  
  29.         }   
try
		{
			tx = session.beginTransaction();

			// Student student = new Student();
			// student.setCardId("123456");
			// student.setName("zhzdsafds");
			//
			// Teacher teacher = new Teacher();
			// teacher.setSalary(100);
			// teacher.setName("lisi");
			//
			// session.save(student);
			// session.save(teacher);

			Query query = session.createQuery("from Person");
			
			Iterator iter = query.iterate();

			while (iter.hasNext())
			{
				Person p = (Person) iter.next();

				System.out.println(p.getClass().getName());
				System.out.println(p.getName());
			}

			tx.commit();
		}

结果：

Hibernate: select person0_.id as col_0_0_ from person person0_
com.cdtax.hibernate.Person_$$_javassist_0
Hibernate: select person0_.id as id0_0_, person0_.name as name0_0_, person0_.cardId as cardId0_0_, person0_.salary as salary0_0_, person0_.personType as personType0_0_ from person person0_ where person0_.id=?
zhzdsafds
com.cdtax.hibernate.Person_$$_javassist_0
Hibernate: select person0_.id as id0_0_, person0_.name as name0_0_, person0_.cardId as cardId0_0_, person0_.salary as salary0_0_, person0_.personType as personType0_0_ from person person0_ where person0_.id=?
lisi

上面的查询统一转换为Person，不能取得特定子类的特有信息，所以修改一下：

[java] view plain copy print ?
  1. try  
  2.         {  
  3.             tx = session.beginTransaction();  
  4.   
  5.             // Student student = new Student();   
  6.             // student.setCardId("123456");   
  7.             // student.setName("zhzdsafds");   
  8.             //   
  9.             // Teacher teacher = new Teacher();   
  10.             // teacher.setSalary(100);   
  11.             // teacher.setName("lisi");   
  12.             //   
  13.             // session.save(student);   
  14.             // session.save(teacher);   
  15.   
  16.             Query query = session.createQuery("from Person");  
  17.               
  18.             Iterator iter = query.iterate();  
  19.   
  20. //          while (iter.hasNext())   
  21. //          {   
  22. //              Person p = (Person) iter.next();   
  23. //   
  24. //              System.out.println(p.getClass().getName());   
  25. //              System.out.println(p.getName());   
  26.                   
  27. //              Object object = iter.next();   
  28. //                 
  29. //              if(object instanceof Student)   
  30. //              {   
  31. //                  System.out.println(((Student)object).getCardId());   
  32. //              }   
  33. //          }   
  34.               
  35.             List list = query.list();  
  36.               
  37.             for(int i = 0;i < list.size();i++)  
  38.             {  
  39.                 if(list.get(i) instanceof Student)  
  40.                 {  
  41.                     System.out.println(((Student)list.get(i)).getCardId());  
  42.                 }  
  43.                 if(list.get(i) instanceof Teacher)  
  44.                 {  
  45.                     System.out.println(((Teacher)list.get(i)).getSalary());  
  46.                 }  
  47.             }  
  48.   
  49.             tx.commit();  
  50.         }   
try
		{
			tx = session.beginTransaction();

			// Student student = new Student();
			// student.setCardId("123456");
			// student.setName("zhzdsafds");
			//
			// Teacher teacher = new Teacher();
			// teacher.setSalary(100);
			// teacher.setName("lisi");
			//
			// session.save(student);
			// session.save(teacher);

			Query query = session.createQuery("from Person");
			
			Iterator iter = query.iterate();

//			while (iter.hasNext())
//			{
//				Person p = (Person) iter.next();
//
//				System.out.println(p.getClass().getName());
//				System.out.println(p.getName());
				
//				Object object = iter.next();
//				
//				if(object instanceof Student)
//				{
//					System.out.println(((Student)object).getCardId());
//				}
//			}
			
			List list = query.list();
			
			for(int i = 0;i < list.size();i++)
			{
				if(list.get(i) instanceof Student)
				{
					System.out.println(((Student)list.get(i)).getCardId());
				}
				if(list.get(i) instanceof Teacher)
				{
					System.out.println(((Teacher)list.get(i)).getSalary());
				}
			}

			tx.commit();
		}

执行结果：

Hibernate: select person0_.id as col_0_0_ from person person0_
Hibernate: select person0_.id as id0_, person0_.name as name0_, person0_.cardId as cardId0_, person0_.salary as salary0_, person0_.personType as personType0_ from person person0_
123456
100

这里将Iterator查询方式屏蔽了是因为使用Iterator延迟加载：

[java] view plain copy print ?
  1. try  
  2.         {  
  3.             tx = session.beginTransaction();  
  4.   
  5.               
  6.   
  7.             Query query = session.createQuery("from Person");  
  8.               
  9.             Iterator iter = query.iterate();  
  10.   
  11.             while (iter.hasNext())  
  12.             {  
  13.                 Object object = iter.next();  
  14.                   
  15.                 if(object instanceof Student)  
  16.                 {  
  17.                     System.out.println(((Student)object).getCardId());  
  18.                 }  
  19.                 if(object instanceof Teacher)  
  20.                     {  
  21.                         System.out.println(((Teacher)object).getSalary());  
  22.                     }  
  23.             }  
try
		{
			tx = session.beginTransaction();

			

			Query query = session.createQuery("from Person");
			
			Iterator iter = query.iterate();

			while (iter.hasNext())
			{
				Object object = iter.next();
				
				if(object instanceof Student)
				{
					System.out.println(((Student)object).getCardId());
				}
				if(object instanceof Teacher)
					{
						System.out.println(((Teacher)object).getSalary());
					}
			}

结果：

Hibernate: select person0_.id as col_0_0_ from person person0_

（3）公共信息放在父类表中，独有信息放在子类表中，每个子类对应一张表。

类不变

配置信息：

[html] view plain copy print ?
  1. <?xml version="1.0" encoding="UTF-8"?>  
  2. <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"  
  3. "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">  
  4.   
  5. <hibernate-mapping>  
  6.       
  7.     <class name="com.cdtax.hibernate.Person" table="person">  
  8.       
  9.         <id name="id" column="id" type="string">  
  10.             <generator class="uuid"></generator>  
  11.         </id>  
  12.           
  13.         <property name="name" column="name" type="string"></property>  
  14.   
  15.         <SPAN style="COLOR: #ff0000"><joined-subclass name="com.cdtax.hibernate.Student" table="student">  
  16.             <key column="id"></key>  
  17.             <property name="cardId" type="string"></property>  
  18.               
  19.         </joined-subclass>  
  20.           
  21.         <joined-subclass name="com.cdtax.hibernate.Teacher" table="teacher">  
  22.         <key column="id"></key>  
  23.         <property name="salary" type="int"></property>  
  24.         </joined-subclass></SPAN>  
  25.     </class>  
  26. </hibernate-mapping>  
<?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>
	
	<class name="com.cdtax.hibernate.Person" table="person">
	
		<id name="id" column="id" type="string">
			<generator class="uuid"></generator>
		</id>
		
		<property name="name" column="name" type="string"></property>

		<span style="color:#ff0000;"><joined-subclass name="com.cdtax.hibernate.Student" table="student">
			<key column="id"></key>
			<property name="cardId" type="string"></property>
			
		</joined-subclass>
		
		<joined-subclass name="com.cdtax.hibernate.Teacher" table="teacher">
		<key column="id"></key>
		<property name="salary" type="int"></property>
		</joined-subclass></span>
	</class>
</hibernate-mapping>
这里使用了joined-subclass，因为是多张表，所以操作时要进行表的连接操作才能完成，所以叫做joined-subclass，对于joined-subclass，需要有key子标签，指明表的外键关联，然后是子类独有的属性映射。

生成的数据库表：

create table person (id varchar(255) not null, name varchar(255), primary key (id))
create table student (id varchar(255) not null, cardId varchar(255), primary key (id))
create table teacher (id varchar(255) not null, salary integer, primary key (id))
alter table student add index FK8FFE823B61610A7D (id), add constraint FK8FFE823B61610A7D foreign key (id) references person (id)
alter table teacher add index FKAA31CBE261610A7D (id), add constraint FKAA31CBE261610A7D foreign key (id) references person (id)
保存数据：

[java] view plain copy print ?
  1. try  
  2.         {  
  3.             tx = session.beginTransaction();  
  4.   
  5.              Student student = new Student();  
  6.              student.setCardId("123456");  
  7.              student.setName("zhzdsafds");  
  8.               
  9.              Teacher teacher = new Teacher();  
  10.              teacher.setSalary(100);  
  11.              teacher.setName("lisi");  
  12.               
  13.              session.save(student);  
  14.              session.save(teacher);  
  15.   
  16.             tx.commit();  
  17.         }   
try
		{
			tx = session.beginTransaction();

			 Student student = new Student();
			 student.setCardId("123456");
			 student.setName("zhzdsafds");
			
			 Teacher teacher = new Teacher();
			 teacher.setSalary(100);
			 teacher.setName("lisi");
			
			 session.save(student);
			 session.save(teacher);

			tx.commit();
		}

结果：

Hibernate: insert into person (name, id) values (?, ?)
Hibernate: insert into student (cardId, id) values (?, ?)
Hibernate: insert into person (name, id) values (?, ?)
Hibernate: insert into teacher (salary, id) values (?, ?)


查询：

[java] view plain copy print ?
  1. try  
  2.         {  
  3.             tx = session.beginTransaction();  
  4. //   
  5. //           Student student = new Student();   
  6. //           student.setCardId("123456");   
  7. //           student.setName("zhzdsafds");   
  8. //             
  9. //           Teacher teacher = new Teacher();   
  10. //           teacher.setSalary(100);   
  11. //           teacher.setName("lisi");   
  12. //             
  13. //           session.save(student);   
  14. //           session.save(teacher);   
  15.   
  16.             Query query = session.createQuery("from Person");  
  17.               
  18.             Iterator iter = query.iterate();  
  19.               
  20.             while(iter.hasNext())  
  21.             {  
  22.                 Person p = (Person)iter.next();  
  23.                   
  24.                 System.out.println(p.getName());  
  25.             }  
  26.             tx.commit();  
  27.         }   
try
		{
			tx = session.beginTransaction();
//
//			 Student student = new Student();
//			 student.setCardId("123456");
//			 student.setName("zhzdsafds");
//			
//			 Teacher teacher = new Teacher();
//			 teacher.setSalary(100);
//			 teacher.setName("lisi");
//			
//			 session.save(student);
//			 session.save(teacher);

			Query query = session.createQuery("from Person");
			
			Iterator iter = query.iterate();
			
			while(iter.hasNext())
			{
				Person p = (Person)iter.next();
				
				System.out.println(p.getName());
			}
			tx.commit();
		}

结果：

Hibernate: select person0_.id as col_0_0_ from person person0_
Hibernate: select person0_.id as id0_0_, person0_.name as name0_0_, person0_1_.cardId as cardId1_0_, person0_2_.salary as salary2_0_, case when person0_1_.id is not null then 1 when person0_2_.id is not null then 2 when person0_.id is not null then 0 end as clazz_0_ from person person0_ left outer join student person0_1_ on person0_.id=person0_1_.id left outer join teacher person0_2_ on person0_.id=person0_2_.id where person0_.id=?
zhzdsafds
Hibernate: select person0_.id as id0_0_, person0_.name as name0_0_, person0_1_.cardId as cardId1_0_, person0_2_.salary as salary2_0_, case when person0_1_.id is not null then 1 when person0_2_.id is not null then 2 when person0_.id is not null then 0 end as clazz_0_ from person person0_ left outer join student person0_1_ on person0_.id=person0_1_.id left outer join teacher person0_2_ on person0_.id=person0_2_.id where person0_.id=?
lisi
Hibernate: select person0_.id as id0_0_, person0_.name as name0_0_, person0_1_.cardId as cardId1_0_, person0_2_.salary as salary2_0_, case when person0_1_.id is not null then 1 when person0_2_.id is not null then 2 when person0_.id is not null then 0 end as clazz_0_ from person person0_ left outer join student person0_1_ on person0_.id=person0_1_.id left outer join teacher person0_2_ on person0_.id=person0_2_.id where person0_.id=?
zhzdsafds
Hibernate: select person0_.id as id0_0_, person0_.name as name0_0_, person0_1_.cardId as cardId1_0_, person0_2_.salary as salary2_0_, case when person0_1_.id is not null then 1 when person0_2_.id is not null then 2 when person0_.id is not null then 0 end as clazz_0_ from person person0_ left outer join student person0_1_ on person0_.id=person0_1_.id left outer join teacher person0_2_ on person0_.id=person0_2_.id where person0_.id=?
lisi

穹劲天空
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
hibernate复合主键映射
07-18
复合主键映射 <br>通常将复合主键相关属性，单独抽取出来，建立一个独立的类 * 必须实现序列化接口 * 必须实现equals和hashcode方法 采用标签进行映射，其它属性采用正常映射
13、复合主键映射（联合主键）
kaoa000的专栏——非淡泊无以明志，非宁静无以致远
11-12 5091
联合主键的映射 1、类中的每个主键属性都对应到数据表中的每个主键的列 Hibernate要求具有联合主键的类首先要实现Serializable接口，其次要重写hashCode和equals方法，这两个方法可以使用Myeclipse帮助我们自动生成。重写这两个方法的原因在于Hibernate要根据数据库的联合主键来判断某两行记录是否是一样的，如果一样那么就认为是同一个对象，如果不一样，那么就认为
java复合主键注解_Java进阶知识06 Hibernate联合主键之Annotation（注解）和XML实现方式...
weixin_42220669的博客
02-16 290
1、Hibernate联合主键(Annotation实现)1.1、单列主键1.1.1、为什么要有主键？ //唯一确定一条记录1.1.2、一个表能否有多个主键？//不能1.1.3、为什么把id设为主键？ //如果有其他的方式可以作为主键，id可以不要1.1.4、主键生成策略：identity：自增长，对DB2,MySQL, MS SQL Server, Sybase和HypersonicSQL的内置...
Hibernate注解映射联合主键的三种主要方式
justlpf的专栏
02-25 800
参考文章： Hibernate注解映射联合主键的三种主要方式 今天在做项目的时候，一个中间表没有主键，所有在创建实体的时候也未加组件，结果报以下错误： org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateSessionFactory' define...
Hibernate复合主键映射
~琥珀@志~
12-21 92
Hibernate复合主键映射 2012-02-03 10:07 音①晓 音①晓的博客 我要评论(0) 字号：T | T 在日常开发中会遇到这样一种情况，数据库中的某张表需要多个字段列才能唯一确定一行记录，这时表需要使用复合主键。面对这样的情况Hibernate为我们提供了两种方式来解决复合主键问题。 AD：   目 录： 1. 实现方式一：将复合...
联合主键在java中的使用方法（实体类）
Methun
12-27 4202
两个主键：courseId和coursePeriod为一对联合主键@Embeddable public class CoursePlanPK implements Serializable{ private static final long serialVersionUID = 1L; @Column(name="course_id") private String cour
精通 Hibernate：Java 对象持久化技术详解(第2版).part4
06-12
　15.1.2 按照主键映射 　15.2 映射单向多对多关联 　15.3 映射双向多对多关联关系 　15.3.1 关联两端使用元素 　15.3.2 在inverse端使用元素 　15.3.3 使用组件类集合 　15.3.4 把多对多关联分解为两个一对多关联 ...
精通 Hibernate：Java 对象持久化技术详解(第2版).part3
06-12
　15.1.2 按照主键映射 　15.2 映射单向多对多关联 　15.3 映射双向多对多关联关系 　15.3.1 关联两端使用元素 　15.3.2 在inverse端使用元素 　15.3.3 使用组件类集合 　15.3.4 把多对多关联分解为两个一对多关联 ...
精通 Hibernate：Java 对象持久化技术详解(第2版).part2
06-12
　15.1.2 按照主键映射 　15.2 映射单向多对多关联 　15.3 映射双向多对多关联关系 　15.3.1 关联两端使用元素 　15.3.2 在inverse端使用元素 　15.3.3 使用组件类集合 　15.3.4 把多对多关联分解为两个一对多关联 ...
精通 Hibernate：Java 对象持久化技术详解(第2版).part1.rar
06-12
　15.1.2 按照主键映射 　15.2 映射单向多对多关联 　15.3 映射双向多对多关联关系 　15.3.1 关联两端使用元素 　15.3.2 在inverse端使用元素 　15.3.3 使用组件类集合 　15.3.4 把多对多关联分解为两个一对多关联 ...
JPA注解实现联合主键
11-21
本文档简单描述了注解实现联合主键类的生成
Jpa联合主键
m0_70448456的博客
02-03 551
Jpa联合主键 配置
java jdbc 复合主键_JPA复合主键
weixin_30430517的博客
02-24 240
1、JPA简介JPA是Java Persistence API的简称。JPA作为 Java EE 5.0 平台标准的对象关系映射(ORM)，规范将得到所有 JavaEE 服务器的支持。 Sun 这次吸取了之前 EJB 规范惨痛失败的经历，在充分吸收现有 ORM 框架(如Hibernate)的基础上，得到了一个易于使用、伸缩性强的 ORM 规范。随着注解使用方式普及，从目前的开发社区的反应上看 J...
java jdbc 复合主键_javaWeb_JDBC_JDBC获取数据库自动生成的主键值
weixin_36399495的博客
02-16 197
JDBC_JDBC获取数据库自动生成主键值1.意义:在操作比较复杂的数据库表以及相关信息的时候，我们需要获取一条记录中的主键值，以便于别的业务逻辑操作该条记录，那么这一个时候如果是数据库自己生成主键值，那么我们就有必要获取这一个主键值。2.实现:使用重载的 prepareStatement(sql, flag)来生成 PreparedStatement 对象，并调用ResultSet rs = p...
Spring JPA Group By，联合主键（多主键）
skylike_sh的博客
07-20 1169
一定要注意构造方法里面的参数顺序，一定要跟上面的query.multiselect中的参数顺序一致。注意 query.multiselect 中参数的排列顺序。（select中的参数必须满足上面的三个联合主键，不能少）上面省略了很多settter/getter。最上面三个字段组成联合主键。
JPA五：联合主键和动态SQL
青衫忆笙的博客
01-09 1117
Spring Data JPA 联合主键和动态SQL。联合主键使用两种方式实现，第一种为 `@IdClass + @Id ` 注解，第二种为 `@Embeddable + @EmbeddedId` 注解 。动态SQL有详细实操步骤以及常用样例总结，如 A and (B or C)、@Query 实现动态SQL、手动拼接SQL等。文末附源码
spring jdbc 复合主键
最新发布
01-31
Spring JDBC是Spring框架提供的一种用于简化数据库访问的技术。复合主键是指一个表中的主键由多个列组成的情况。在Spring JDBC中，处理复合主键的方式如下： 1. 定义实体类：创建一个Java类来表示数据库表中的每一行数据，并在该类中定义与表中列对应的属性。 2. 定义主键类：创建一个Java类来表示复合主键，并在该类中定义与表中复合主键对应的属性。 3. 实现RowMapper接口：创建一个实现RowMapper接口的类，用于将查询结果集中的每一行数据映射到实体类对象中。 4. 编写DAO层代码：在DAO层中使用Spring JDBC提供的JdbcTemplate来执行SQL语句，通过设置参数和返回类型来实现对复合主键的操作。 5. 使用复合主键：在业务逻辑层或其他地方使用DAO层提供的方法来操作复合主键。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值