Hibernate3增加了视图功能
1. 定义hbm
1. 定义hbm
- <class name="Customer" table="customer">
- <id name="id" unsaved-value="0" column="id">
- <generator class="hilo"/>
- </id>
- <property name="name" not-null="true"/>
- </class>
- <class name="Supplier" table="supplier">
- <id name="id" unsaved-value="0" column="id">
- <generator class="hilo"/>
- </id>
- <property name="name" not-null="true"/>
- </class>
- <class name="All" mutable="false">
- <subselect>
- select id, name from customer
- union
- select id, name from supplier
- </subselect>
- <synchronize table="customer"/>
- <synchronize table="supplier"/>
- <id name="id" unsaved-value="0" column="id">
- <generator class="hilo"/>
- </id>
- <property name="name"/>
- </class>
2. 定义POJO
- pulic class Customer {
- public Integer id;
- public String name;
- }
- pulic class Supplier {
- public Integer id;
- public String name;
- }
- pulic class All {
- public Integer id;
- public String name;
- }
3. 查询
- List all = session.createQuery("from All").list();