Hibernate的视图功能

Hibernate3增加了视图功能

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();