mybatise+oracle使用sql语句实现级联批量删除

设置数据库级联删除比较麻烦，所以直接用sql语句控制，传入mybatise一个map对象包含需要删除的表名，和需要删除的code

public int deleteBatchs(List<String> list){
        Map<String,Object> map = new HashMap<String,Object>();
        List<String> newlist = new ArrayList<String>();
        newlist.add("这里写需要删除的表名");
        newlist.add("这里写需要删除的表名");
        map.put("newlist", newlist);
        map.put("list", list);
        return mapperImpl.deleteBatchs(map);
    }

mybatise的xml文件

 <update id="deleteBatchs" parameterType="Map">
     <foreach collection="newlist" item="item" open="begin" close="end;" >
        <if test="item == '表名'">
        UPDATE ${item} SET FLAG_DEL=1 WHERE CODE IN 
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <foreach collection="list" item="code" separator=",">
                #{code}
            </foreach>
        </trim>
        ;
        </if>
        <if test="item == '表名'">
        UPDATE ${item} SET FLAG_DEL=1 WHERE 表_CODE IN 
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <foreach collection="list" item="code" separator=",">
                #{code}
            </foreach>
        </trim>
        ;
        </if>
     </foreach>
    </update>