Ibatis 删除

最新推荐文章于 2024-03-27 12:45:08 发布

IBelieveKDM

最新推荐文章于 2024-03-27 12:45:08 发布

阅读量1.1k

点赞数

分类专栏： ibatis

本文链接：https://blog.csdn.net/IBelieveKDM/article/details/8525848

版权

ibatis 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

Map map = new HashMap();
map.put("pathdylist", pathdylist);
map.put("FORGID", forgid);

getPathDyDAOImpl().deleteCpinf(map);

<delete id="deleteCpinf" parameterClass="java.util.Map">
      begin
         delete cp_base_pgdy t where t.pathid in (
            select t.pathid from cp_base_pathdy t
      where t.pathcode in
         <iterate property="pathdylist" conjunction="," open="(" close=")">
      #pathdylist[].PATHCODE#
      </iterate>
         and t.forgid = #FORGID#
         );
         delete cp_base_lcfa t where t.pathid in (
            select t.pathid from cp_base_pathdy t
      where t.pathcode in
         <iterate property="pathdylist" conjunction="," open="(" close=")">
      #pathdylist[].PATHCODE#
      </iterate>
         and t.forgid = #FORGID#
         );
         delete cp_base_lcdy t where t.pathid in (
            select t.pathid from cp_base_pathdy t
      where t.pathcode in
         <iterate property="pathdylist" conjunction="," open="(" close=")">
      #pathdylist[].PATHCODE#
      </iterate>
         and t.forgid = #FORGID#
         );
         delete cp_base_pathdy t where t.pathid in (
            select t.pathid from cp_base_pathdy t
      where t.pathcode in
         <iterate property="pathdylist" conjunction="," open="(" close=")">
      #pathdylist[].PATHCODE#
      </iterate>
         and t.forgid = #FORGID#
         );
      end;
</delete>