hql 做外连接查询全部数据

最新推荐文章于 2025-12-24 10:49:21 发布

原创最新推荐文章于 2025-12-24 10:49:21 发布 · 435 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#ebook #myeclipse #generator #class #encoding #date

hibernate 专栏收录该内容

4 篇文章

订阅专栏

本文详细介绍了电子书合同（TEbookContract）与电子书项目（TEbookProject）之间的对象关系映射（ORM）配置过程，包括Hibernate映射文件的具体设置，如ID生成策略、属性映射及多对一、一对多的关系处理。

  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">

<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">

<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>