SpringBoot + Mybatis 批量修改操作

SpringBoot + Mybatis 批量修改操作测试用例

mybatils文件：

    <update id="updateAppGoodsDetailsByIds" parameterType="Map">
        update app_goods_details
        set goods_state = #{goodsState,jdbcType=VARCHAR}
        where goods_id in
        <foreach item="goodsId" collection="goodsId" open="(" separator="," close=")">
            #{goodsId}
        </foreach>
    </update>

mapper文件(dao层)：

	/**
     * 批量上下架商品
     * @return 结果
     */
    public int updateAppGoodsDetailsByIds(Map<String,Object> map);

#

service文件：

	/**
     * 批量上下架商品
     *
     * @return 结果
     */
    public int updateAppGoodsDetailsByIds(Map<String, Object> map);

serviceImpl文件：

	/**
     * 批量上下架商品
     *
     * @return 结果
     */
    public int updateAppGoodsDetailsByIds(Map<String, Object> map)
    {
        return appGoodsDetailsMapper.updateAppGoodsDetailsByIds(map);
    }

controller文件：

	/**
     * 商品上架下架
     */
    @PostMapping( "/updateState")
    @ResponseBody
    public AjaxResult updateState(Integer state, String ids)
    {
        Map<String, Object> map = new HashMap<>();
        List<String> idList= Arrays.asList(ids.split(","));
        map.put("goodsState",state);
        map.put("goodsId",idList);

        return toAjax(appGoodsDetailsService.updateAppGoodsDetailsByIds(map));
    }

效果