Hibernate 多对多关联映射, 中间表加查询条件


package
com.coracle.yk.xpo.po.base; import java.util.Date; import java.util.HashSet; import java.util.Set;public class YkAction { private static final long serialVersionUID = 1L; private Integer id;private Set<YkColumn> ykColumns = new HashSet<>(); public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public Set<YkColumn> getYkColumns() { return ykColumns; } public void setYkColumns(Set<YkColumn> ykColumns) { this.ykColumns = ykColumns; } }

YkAction.hbm.xml

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<!-- 
    Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
    <class name="com.coracle.yk.xpo.po.base.YkAction" table="yk_action" catalog="youkee_base">
        <id name="id" type="java.lang.Integer">
            <column name="ID" />
            <generator class="com.coracle.yk.xframework.common.db.HibernateIncrementGenerator">
                <param name="catalog">youkee_base</param>
            </generator>
        </id>

        <!-- 行为动作多对多映射 -->
        <set name="ykColumns" table="yk_action_column" order-by="sort_order asc">
            <key column="ACTION_ID"></key>
            <many-to-many class="com.coracle.yk.xpo.po.base.YkColumn" column="COLUMN_ID" where="remove_flag=0"/>
        </set>
    </class>
</hibernate-mapping>

 使用子查询.

<set name="stores"
             subselect="org_id in (select ID
             from yk_org org where org.id = org_id and org.remove_flag=0)">
            <key column="mall_id"></key>
            <one-to-many class="com.coracle.yk.xpo.po.base.YkStore"></one-to-many>
        </set>

 

转载于:https://www.cnblogs.com/cocoat/p/5310790.html

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值