传参（三）

菜单模块

在MySQL中新建一个menu（菜单）数据库；创建表；
在java中新建MenuController、Menu、MenuMapper文件
首先在Menu文件中定义各种属性生成get和set方式
其次在MenuMapper接口文件中写入MySQL命令

package com.sdcet.mapper;

import com.sdcet.entity.Menu;
import com.sdcet.entity.User;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface MenuMapper {
//    @Insert
    @Insert("INSERT INTO" + " menu (name, `desc`, count, picture, price, create_time, update_time) VALUES (#{name}, #{desc}, #{count}, #{picture}, #{price}, #{createTime}, #{updateTime})")
    int save(Menu menu);
//    @Delete
    @Delete("DELETE FROM menu WHERE id = #{id}")
    int delete(Long id);
//    @Update
    @Update("UPDATE menu SET name=#{name},`desc`=#{desc},count=#{count},picture=#{picture},price=#{price},create_time=#{createTime},update_time=#{updateTime} WHERE id=#{id}")
    int update(Menu menu);
//    @Select
    @Select("SELECT * FROM menu WHERE id = #{id}")
    User selectMenuById(Long id);//查看全部信息
    @Select("SELECT * FROM menu WHERE name = #{name}")
//    @Select("SELECT id , name, sex,password,phone_num,create_time,updata_time FROM user WHERE name = #{name}")  指定输出内容
    List<Menu> selectMenuByName(String name);//以name为条件查看
}

在去MenuController文件中写入访问网站的接口链接

import java.util.Date;

@Controller
@ResponseBody
@RequestMapping("/menu")
public class MenuController {
    @Autowired
    private MenuMapper menuMapper;

    @PostMapping("/save")
    public ResponseMessage save(@RequestBody Menu menu){
        if (menu.getName() == null || "".equals(menu.getName())){
            return ResponseMessage.fail("Column 'name' cannot be null");
        }
        if (menu.getDesc() == null || "".equals(menu.getDesc())){
            return ResponseMessage.fail("Column 'name' cannot be null");
        }
        Date date = new Date();
        menu.setCreateTime(date);
        menu.setUpdateTime(date);
        return ResponseMessage.success(menuMapper.save(menu));
    }
    @DeleteMapping("/delete")//删除
    public ResponseMessage delete(Long id){
        return ResponseMessage.success(menuMapper.delete(id));
    }
    @PostMapping("/update")//修改
    public ResponseMessage update(@RequestBody Menu menu){
        if (menu.getName() == null || "".equals(menu.getName())){
            return ResponseMessage.fail("Column 'name' cannot be null");
        }
        if (menu.getDesc() == null || "".equals(menu.getDesc())){
            return ResponseMessage.fail("Column 'name' cannot be null");
        }
        menu.setUpdateTime(new Date());
        return ResponseMessage.success(menuMapper.update(menu));
    }
    @RequestMapping("/select")//查询全部信息
    public ResponseMessage selectMenuById(Long id){
        return ResponseMessage.success(menuMapper.selectMenuById(id));
    }

    @RequestMapping("/selectName")//以name为条件进行查询
    public ResponseMessage selectName(String name){
        return ResponseMessage.success(menuMapper.selectMenuByName(name));
    }
}

运行之后到Postman软件中建好对应的增删改查模块。