菜品模块

在HeidiSQL中新建一个名字为menu（菜单）的数据表

打开IDEA，在entity包下新建一个名为Menu的类，并添加与数据库相对应的数据类型

public class Menu {
    private Long id;
    private String name;
    private String desc;
    private int count;
    private Double price;
    private String picture;
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss",timezone = "Asia/Shanghai")
    private Date createTime;
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss",timezone = "Asia/Shanghai")
    private Date updateTime;

    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getDesc() {
        return desc;
    }

    public void setDesc(String desc) {
        this.desc = desc;
    }

    public int getCount() {
        return count;
    }

    public void setCount(int count) {
        this.count = count;
    }

    public Double getPrice() {
        return price;
    }

    public void setPrice(Double price) {
        this.price = price;
    }

    public String getPicture() {
        return picture;
    }

    public void setPicture(String picture) {
        this.picture = picture;
    }

    public Date getCreateTime() {
        return createTime;
    }

    public void setCreateTime(Date createTime) {
        this.createTime = createTime;
    }

    public Date getUpdateTime() {
        return updateTime;
    }

    public void setUpdateTime(Date updateTime) {
        this.updateTime = updateTime;
    }
}

为菜品模块编写增删改查接口，在mapper包下新增MenuMapper接口

@Mapper
public interface MenuMapper {
    //新增
    @Insert("INSERT INTO menu (name,`desc`,count,price,picture,create_time,update_time)VALUES(#{name},#{desc},#{count},#{price},#{picture},#{createTime},#{updateTime})")
    int save(Menu menu);

    //修改
    @Update("UPDATE user SET name=#{name},desc=#{desc},count=#{count},price=#{price},picture=#{picture},create_time=#{createTime},update_time=#{updateTime}")
    int update (Menu menu);
    //删除
    @Delete("DETELE FROM menu WHERE id=#{id}")
    int delete (long id);

    @Select("SELECT * FROM user WHERE name=#{name}")
    List<Menu> selectMenuByName(String name);

    @Select("SELECT * FROM user WHERE id = #{id}")
    Menu selectMenuById(Long id);
}

在controller包下新增菜品模块的controller，名为MenuController,并编写增删改查方法

@Controller
@ResponseBody
@RequestMapping("/menu")
public class MenuController {

    @Autowired
    private MenuMapper menuMapper;
    @PostMapping("/save")
    public ResponseMessage save(@RequestBody Menu menu){
        Date date = new Date();
        menu.setCreateTime(date);
        menu.setUpdateTime(date);
        return ResponseMessage.success(menuMapper.save(menu));
    }
    @DeleteMapping("/delete")
    public int delete(Long id) {
        return menuMapper.delete(id);
    }


    @PutMapping("/update")
    public ResponseMessage update(@RequestBody Menu menu) {
        menu.setUpdateTime(new Date());
        return ResponseMessage.success(menuMapper.update(menu));
    }

    @GetMapping("/getName")

    public List<Menu> getName(String name) {
        return menuMapper.selectMenuByName(name);
    }
    @GetMapping("/getId")
    public ResponseMessage getId(Long id) {
        return ResponseMessage.success(menuMapper.selectMenuById(id));
//        return ResponseMessage.fail();
    }


}

在Postman下的点餐系统文件下新建菜品文件夹，并添加如下，

新增模块

删除模块

修改模块

查看  根据id查看

根据name查看