hql 做外连接 查询全部数据

  String hql = "select a from  TWblrUser c, TEbookContract a left outer join a.TEbookProjects b "+
               "where "+
               "a.createUser = c.userId "+
               "and b is null "+
               "and c.companyId = "+companyId;

 

 

 private Long contractId;
 private String contractName;
 private Date createTime;
 private Long createUser;
 private Date lastUpdateTime;
 private Long lastUpdateUser;
 private Set TEbookProjects = new HashSet(0);

 

private TEbookContract TEbookContract;
 private String projectName;
 private Date createTime;
 private Long createUser;
 private Date lastUpdateTime;
 private Long lastUpdateUser;

 

<?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 Persistence Tools
-->
<hibernate-mapping>
    <class name="com.isoftstone.ebook.pojo.TEbookContract" table="T_EBOOK_CONTRACT" schema="EBOOKDB">
        <id name="contractId" type="java.lang.Long">
            <column name="CONTRACT_ID" precision="22" scale="0" />
            <generator class="sequence">
            <param name="sequence">T_EBOOK_CONTRACT_ID</param>
           </generator>
        </id>
        <property name="contractName" type="java.lang.String">
            <column name="CONTRACT_NAME" length="50" />
        </property>
        <property name="createTime" type="java.util.Date">
            <column name="CREATE_TIME" length="7" />
        </property>
        <property name="createUser" type="java.lang.Long">
            <column name="CREATE_USER" precision="10" scale="0" />
        </property>
        <property name="lastUpdateTime" type="java.util.Date">
            <column name="LAST_UPDATE_TIME" length="7" />
        </property>
        <property name="lastUpdateUser" type="java.lang.Long">
            <column name="LAST_UPDATE_USER" precision="10" scale="0" />
        </property>
        <set name="TEbookProjects" inverse="true">
            <key>
                <column name="CONTRACT_ID" precision="22" scale="0" />
            </key>
            <one-to-many class="com.isoftstone.ebook.pojo.TEbookProject" />
        </set>
    </class>
</hibernate-mapping>

<?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 Persistence Tools
-->
<hibernate-mapping>
    <class name="com.isoftstone.ebook.pojo.TEbookProject" table="T_EBOOK_PROJECT" schema="EBOOKDB">
        <id name="projectId" type="java.lang.Long">
            <column name="PROJECT_ID" precision="22" scale="0" />
             <generator class="sequence">
             <param name="sequence">t_ebook_batch_id</param>
            </generator>
        </id>
        <many-to-one name="TEbookContract" class="com.isoftstone.ebook.pojo.TEbookContract" fetch="select">
            <column name="CONTRACT_ID" precision="22" scale="0" />
        </many-to-one>
        <property name="projectName" type="java.lang.String">
            <column name="PROJECT_NAME" length="50" />
        </property>
        <property name="createTime" type="java.util.Date">
            <column name="CREATE_TIME" length="7" />
        </property>
        <property name="createUser" type="java.lang.Long">
            <column name="CREATE_USER" precision="10" scale="0" />
        </property>
        <property name="lastUpdateTime" type="java.util.Date">
            <column name="LAST_UPDATE_TIME" length="7" />
        </property>
        <property name="lastUpdateUser" type="java.lang.Long">
            <column name="LAST_UPDATE_USER" precision="10" scale="0" />
        </property>
        <set name="TEbookBatchs" inverse="true">
            <key>
                <column name="PROJECT_ID" precision="22" scale="0" />
            </key>
            <one-to-many class="com.isoftstone.ebook.pojo.TEbookBatch" />
        </set>
    </class>
</hibernate-mapping>