Hiberante的对象继承关系之--TPC一张表表示整个
系统
1666 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
&
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元等您想捐的金额吧,狠狠点击下面给点支持吧,站长非常感激您!手机微信长按不能支付解决办法:请将微信支付二维码保存到相册,切换到微信,然后点击微信右上角扫一扫功能,选择支付二维码完成支付。
【本文对您有帮助就好】元