数据库结构:
create table teacherTPC(id varchar ( 32 ), name varchar ( 32 ),salary double );
Hibernate.cfg.xml
<! 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" > root </ property >
< property name ="connection.url" >
jdbc:mysql://localhost:3306/schoolproject?characterEncoding=gb2312 & useUnicode=true
</ property >
< property name ="dialect" >
org.hibernate.dialect.MySQLDialect
</ property >
< property name ="myeclipse.connection.profile" > mysql </ property >
< property name ="connection.password" > 1234 </ property >
< property name ="connection.driver_class" >
com.mysql.jdbc.Driver
</ property >
< property name ="hibernate.dialect" >
org.hibernate.dialect.MySQLDialect
</ property >
< property name ="hibernate.show_sql" > true </ property >
< property name ="current_session_context_class" > thread </ property >
< property name ="jdbc.batch_size" > 15 </ property >
< mapping resource ="Mapping/TPC/Student.hbm.xml" />
< mapping resource ="Mapping/TPC/Teacher.hbm.xml" />
</ session-factory >
</ hibernate-configuration >
Pojo
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;
}
}
package Mapping.TPC;
public class Student extends Person {
private String cardnum;
public String getCardnum() {
return cardnum;
}
public void setCardnum(String cardnum) {
this .cardnum = cardnum;
}
}
package Mapping.TPC;
public class Teacher extends Person {
private Double salary;
public Double getSalary() {
return salary;
}
public void setSalary(Double salary) {
this .salary = salary;
}
}
Student.hbm.xml
<! DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
<!--
Mapping file autogenerated by MyEclipse - Hibernate Tools
-->
< hibernate-mapping >
< class name ="Mapping.TPC.Student" table ="stuTPC" select-before-update ="true" >
< id name ="id" unsaved-value ="null" >
< generator class ="uuid.hex" ></ generator >
</ id >
< property name ="name" type ="string" column ="name" ></ property >
< property name ="cardnum" type ="string" column ="cardnum" ></ property >
</ class >
</ hibernate-mapping >
Teacher.hbm.xml
<! DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
<!--
Mapping file autogenerated by MyEclipse - Hibernate Tools
-->
< hibernate-mapping >
< class name ="Mapping.TPC.Teacher" table ="teacherTPC" select-before-update ="true" >
< id name ="id" unsaved-value ="null" >
< generator class ="uuid.hex" ></ generator >
</ id >
< property name ="name" type ="string" column ="name" ></ property >
< property name ="salary" type ="double" column ="salary" ></ property >
</ class >
</ hibernate-mapping >
测试代码:
import java.io.File;
import java.util.Iterator;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
public class Test {
public static void main(String[] args) {
String filePath = System.getProperty( " user.dir " ) + File.separator + " src/Mapping/TPC " + File.separator + " hibernate.cfg.xml " ;
File file = new File(filePath);
System.out.println(filePath);
SessionFactory sessionFactory = new Configuration().configure(file).buildSessionFactory();
Session session = sessionFactory.openSession();
Transaction t = session.beginTransaction();
Student stu = new Student();
stu.setCardnum( " 11111 " );
stu.setName( " tom1stu " );
Teacher teacher = new Teacher();
teacher.setSalary( new Double( 12345 ));
teacher.setName( " tom1teacher " );
session.save(stu);
session.save(teacher);
// 用父类查询,因为没有Person的mapping文件,所以要用全路径包名写HQL
Query query = session.createQuery( " from Mapping.TPC.Person " );
Iterator iter = query.list().iterator();
while (iter.hasNext()) {
Person person = (Person)iter.next();
System.out.println(person.getName());
}
t.commit();
}
}
结果:
Hibernate: insert into stuTPC (name, cardnum, id) values (?, ?, ?)
Hibernate: insert into teacherTPC (name, salary, id) values (?, ?, ?)
Hibernate: select teacher0_.id as id1_, teacher0_.name as name1_, teacher0_.salary as salary1_ from teacherTPC teacher0_
Hibernate: select student0_.id as id0_, student0_.name as name0_, student0_.cardnum as cardnum0_ from stuTPC student0_
tom1teacher
tom1stu