Hibernate的视图功能

Hibernate3增加了视图功能

1. 定义hbm

<classname="Customer"table="customer">
<idname="id"unsaved-value="0"column="id">
<generatorclass="hilo"/>
</id>
<propertyname="name"not-null="true"/>
</class>

<classname="Supplier"table="supplier">
<idname="id"unsaved-value="0"column="id">
<generatorclass="hilo"/>
</id>
<propertyname="name"not-null="true"/>
</class>

<classname="All"mutable="false">
<subselect>
selectid,namefromcustomer
union
selectid,namefromsupplier
</subselect>

<synchronizetable="customer"/>
<synchronizetable="supplier"/>

<idname="id"unsaved-value="0"column="id">
<generatorclass="hilo"/>
</id>
<propertyname="name"/>
</class>

2. 定义POJO

pulicclassCustomer{
publicIntegerid;
publicStringname;
}

pulicclassSupplier{
publicIntegerid;
publicStringname;
}

pulicclassAll{
publicIntegerid;
publicStringname;
}

3. 查询

Listall=session.createQuery("fromAll").list();