springboot结合mybatis实现根据id批量修改（删除）

左手的ㄟ右手 2023-07-11 08:55 76阅读 0赞

实现根据图片id批量修改选中的图片

1.  mapper.java

// 根据图片id批量删除图片
    void batchDelete(List<Integer> list);

1.  service.java

/** * 根据图片id批量删除图片 * @param list */
        void batchDelete(List<Integer> list);

1.  serviceImpl.java

@Override
        public void batchDelete(List<Integer> list) { 
            goodsPictureMapper.batchDelete(list);
        }

1.  mapper.xml

<select id="batchDelete" resultMap="BaseResultMap">
            update goods_picture set gp_status=0 where gp_id in
            <foreach collection="list" open="(" close=")" item="item" separator="," index="index">
                #{item}
            </foreach>
        </select>

1.  controller.java

/** * 根据图片id批量删除图片 * @param gpId */
        @RequestMapping("/batchDelete")
        public void batchDelete(@RequestParam(value = "gpId") String gpId) { 
            String[] gpIds = gpId.split(",");
            List<Integer> list = new ArrayList<>();
            for(String str:gpIds){ 
                list.add(Integer.parseInt(str));
            }
            goodsPictureService.batchDelete(list);
        }

1.  使用 postman 测试  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4MTU3ODI1_size_16_color_FFFFFF_t_70]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4MTU3ODI1_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200304233124678.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4MTU3ODI1,size_16,color_FFFFFF,t_70