Hibernate3视图功能

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