SpringBoot根据id批量修改接口

最新推荐文章于 2024-05-24 08:29:09 发布

长头发的程序猿

最新推荐文章于 2024-05-24 08:29:09 发布

阅读量1.1k

点赞数

文章标签： spring boot java mybatis

本文链接：https://blog.csdn.net/weixin_55076626/article/details/126548431

版权

entity：

package com.dongdong.dingdong.entity;

import com.baomidou.mybatisplus.annotation.FieldFill;
import com.baomidou.mybatisplus.annotation.TableField;
import lombok.Data;

import java.io.Serializable;
import java.math.BigDecimal;
import java.time.LocalDateTime;

/**
 菜品
 */
@Data
public class Dish implements Serializable {

    private static final long serialVersionUID = 1L;

    private Long id;


    //菜品名称
    private String name;


    //菜品分类id
    private Long categoryId;


    //菜品价格
    private BigDecimal price;


    //商品码
    private String code;


    //图片
    private String image;


    //描述信息
    private String description;


    //0 停售 1 起售
    private Integer status;


    //顺序
    private Integer sort;


    @TableField(fill = FieldFill.INSERT)
    private LocalDateTime createTime;


    @TableField(fill = FieldFill.INSERT_UPDATE)
    private LocalDateTime updateTime;


    @TableField(fill = FieldFill.INSERT)
    private Long createUser;


    @TableField(fill = FieldFill.INSERT_UPDATE)
    private Long updateUser;


    //是否删除
    private Integer isDeleted;

}

mapper：

package com.dongdong.dingdong.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.dongdong.dingdong.entity.Dish;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface DishMapper extends BaseMapper<Dish> {

    /**
     * 根据id批量修改status
     * @param ids
     * @param status
     * @return
     */
    int updateByIds(@Param(value = "ids") List<Long> ids,
                    @Param(value = "status") Integer status);
}

mapper.xml：

<?xml version="1.0" encoding="UTF-8"?>
        <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.dongdong.dingdong.mapper.DishMapper">

    <!--    根据id批量修改status-->
    <update id="updateByIds">
        UPDATE dish SET status = #{status}
        WHERE id IN (
        <foreach collection="ids" item="id" index="index" open="" close="" separator="," >
            #{id}
        </foreach>
        )
    </update>
</mapper>

server：

package com.dongdong.dingdong.server;


import com.baomidou.mybatisplus.extension.service.IService;
import com.dongdong.dingdong.entity.Dish;

import java.util.List;

public interface DishService extends IService<Dish> {

    /**
     * 根据id批量修改status
     * @param ids
     * @param status
     * @return
     */
    int updateByIds(List<Long> ids, Integer status);
}

serverImpl：

package com.dongdong.dingdong.server.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.dongdong.dingdong.entity.Dish;
import com.dongdong.dingdong.mapper.DishMapper;
import com.dongdong.dingdong.server.DishService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.util.List;

@Slf4j
@Service
public class DishServiceImpl extends ServiceImpl<DishMapper, Dish> implements DishService {

    @Resource
    private DishMapper dishMapper;

    @Override
    public int updateByIds(List<Long> ids, Integer status) {
        return dishMapper.updateByIds(ids,status);
    }
}

controller：

/**
     * 根据id批量修改
     * @param ids
     * @param status
     * @return
     */
    @PostMapping("/status/{status}")
    public R<String> update(@RequestParam List<Long> ids,
    @PathVariable Integer status){
        log.info("进入菜品状态修改接口...");

        dishService.updateByIds(ids,status);

        return R.success("菜品状态修改成功！！！");
    }