多对多删除问题 Spring+Hibernate

用户与群组多对多删除问题,中间表要删除还有群组要删除,(相当于解散群),用户记录不变

-----------------------------------User.hbm.xml文件---------------------------

<?xml version="1.0"?>
<!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.DonSoft.InstantChat.model.User" table="t_user">
  <id name="userId" type="int">
   <column name="userID" />
   <generator class="native" />
  </id>
  <property name="employeeNo" type="string">
   <column name="employeeNO" length="50" not-null="true" />
  </property>
  <property name="password" type="string">
   <column name="password" length="50" not-null="true" />
  </property>
  <property name="name" type="string">
   <column name="name" length="50" not-null="true" />
  </property>
  <property name="sex" type="string">
   <column name="sex" length="20" not-null="true" />
  </property>
  <property name="age" type="java.lang.Integer">
   <column name="age" />
  </property>
  <property name="role" type="string">
   <column name="role" length="50" not-null="true" />
  </property>
  <property name="phone" type="string">
   <column name="phone" length="50" />
  </property>
  <property name="address" type="string">
   <column name="address" length="100" />
  </property>
  <set name="managers" inverse="true">
   <key>
    <column name="userID" />
   </key>
   <one-to-many class="com.DonSoft.InstantChat.model.Manager" />
  </set>
  <set name="groups" inverse="false" table="t_user_group" cascade="all" >
   <key>
    <column name="userID" />
   </key>
   <many-to-many class="com.DonSoft.InstantChat.model.Group">
    <column name="groupID"  />
   </many-to-many>
  </set>
  <set name="positions" inverse="true" table="t_user_position" cascade="all">
   <key>
    <column name="userID" />
   </key>
   <many-to-many class="com.DonSoft.InstantChat.model.Position">
    <column name="positionID" />
   </many-to-many>
  </set>
  <set name="acceptMessages" inverse="true">
   <key>
    <column name="targetID" not-null="true" />
   </key>
   <one-to-many class="com.DonSoft.InstantChat.model.Message" />
  </set>
  <set name="sentMessages" inverse="true">
   <key>
    <column name="sourceID" not-null="true" />
   </key>
   <one-to-many class="com.DonSoft.InstantChat.model.Message" />
  </set>
 </class>
</hibernate-mapping>

-----------------------------Group.hbm.xml---------------------

<?xml version="1.0"?>
<!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.DonSoft.InstantChat.model.Group" table="t_group">
        <id name="groupId" type="int">
            <column name="groupID" />
            <generator class="native" />
        </id>
        <property name="groupName" type="string">
            <column name="groupName" length="50" not-null="true" />
        </property>
        <property name="type" type="string">
            <column name="type" length="50" not-null="true" />
        </property>
        <property name="placard" type="string">
            <column name="placard" length="150" />
        </property>
        <set name="users" inverse="true" table="t_user_group" cascade="none" >
            <key>
                <column name="groupID" />
            </key>
            <many-to-many class="com.DonSoft.InstantChat.model.User">
                <column name="userID" />
            </many-to-many>
        </set>
        <set name="groupMessages" inverse="true">
            <key>
                <column name="groupID" />
            </key>
            <one-to-many class="com.DonSoft.InstantChat.model.Message" />
        </set>
        <one-to-one name="manager"></one-to-one>
        <set name="positions" inverse="true">
            <key>
                <column name="departmentID" />
            </key>
            <one-to-many class="com.DonSoft.InstantChat.model.Position" />
        </set>
    </class>
</hibernate-mapping>
删除方法:

public void delGroup(Group group) {
  Group groupInDB = this.getGroupByID(group.getGroupId());
  Set<Position> positions = groupInDB.getPositions();
  Manager manager = (Manager) this.getSession().createQuery(
    "from Manager where group.groupId=?").setParameter(0,
    groupInDB.getGroupId()).uniqueResult();
   Set<User> users = groupInDB.getUsers();
  if (users != null && users.size() > 0) {
   for (Iterator<User> iterator = users.iterator(); iterator.hasNext();) {
    User user = iterator.next();
    if (manager != null) {
     user.getManagers().remove(manager);
     this.getHibernateTemplate().delete(manager);
    }
    user.getGroups().remove(groupInDB);
    iterator.remove();
   }
  }
  this.getHibernateTemplate().delete(groupInDB);
 }

 

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值