Hiberante的对象继承关系之--TPC一张表表示整个

系统 1497 0

数据库结构:

 

create   table  personTPC (id  varchar ( 32 ),name  varchar ( 32 ),personType  varchar ( 32 ),cardnum  varchar ( 32 ),salary  double );

 

<? 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"
>

<!--  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
&amp; 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/TPCSubclass/Person.hbm.xml"   />




</ session-factory >

</ hibernate-configuration >

 poj

 

package  Mapping.TPC;

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;
}

}

 

Person.hbm.xml

 

<? 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"
>
<!--  
    Mapping file autogenerated by MyEclipse - Hibernate Tools
-->
< hibernate-mapping >
< class  name ="Mapping.TPCSubclass.Person"  table ="personTPC"   >
    
< id  name ="id"  unsaved-value ="null" >
      
< generator  class ="uuid.hex" ></ generator >
    
</ id >
    
< discriminator  column ="personType"  type ="string" ></ discriminator >
    
< property  name ="name"  type ="string"  column ="name" ></ property >
    
< subclass  name ="Mapping.TPCSubclass.Student"  discriminator-value ="student" >
      
< property  name ="cardnum"  type ="string" ></ property >
    
</ subclass >
     
< subclass  name ="Mapping.TPCSubclass.Teacher"  discriminator-value ="teacher" >
      
< property  name ="salary"  type ="double" ></ property >
    
</ subclass >
</ class >

</ hibernate-mapping >

 

测试代码:

 

package  Mapping.TPCSubclass;


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/TPCSubclass " + 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);
        
// 单独查找student
        Query query = session.createQuery( " from Mapping.TPCSubclass.Student " );
        Iterator iter
= query.list().iterator();
        
while (iter.hasNext()) ... {
            Person person
= (Person)iter.next();
            System.out.println(person.getName());
        }

        t.commit();
        
    }


}

测试结果:

Hibernate: insert into personTPC (name, cardnum, personType, id) values (?, ?, 'student', ?)
Hibernate: insert into personTPC (name, salary, personType, id) values (?, ?, 'teacher', ?)
Hibernate: select student0_.id as id0_, student0_.name as name0_, student0_.cardnum as cardnum0_ from personTPC student0_ where student0_.personType='student'
tom1stu

Hiberante的对象继承关系之--TPC一张表表示整个继承关系


更多文章、技术交流、商务合作、联系博主

微信扫码或搜索:z360901061

微信扫一扫加我为好友

QQ号联系: 360901061

您的支持是博主写作最大的动力,如果您喜欢我的文章,感觉我的文章对您有帮助,请用微信扫描下面二维码支持博主2元、5元、10元、20元等您想捐的金额吧,狠狠点击下面给点支持吧,站长非常感激您!手机微信长按不能支付解决办法:请将微信支付二维码保存到相册,切换到微信,然后点击微信右上角扫一扫功能,选择支付二维码完成支付。

【本文对您有帮助就好】

您的支持是博主写作最大的动力,如果您喜欢我的文章,感觉我的文章对您有帮助,请用微信扫描上面二维码支持博主2元、5元、10元、自定义金额等您想捐的金额吧,站长会非常 感谢您的哦!!!

发表我的评论
最新评论 总共0条评论