瑞吉外卖项目实战Day03

一、查询分类

1.创建实体类Category与数据库相对应

@Data
public class Category implements Serializable {
    

    private static final long serialVersionUID = 1L;

    private Long id;


    //类型 1 菜品分类 2 套餐分类
    private Integer type;


    //分类名称
    private String name;


    //顺序
    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;
    }

2.创建CategoryMapper

3.创建CategoryService和CategoryServiceImpl

4.创建CategoryController

@RestController
@RequestMapping("/category")
public class CategoryController {
    
    @Autowired
   private CategoryService categoryService;

    //查询分类
    @GetMapping("/page")
    public R<Page> selectByPage(int page,int pageSize){
    
        Page<Category> pageInfo=new Page<>(page,pageSize);
        LambdaQueryWrapper<Category> lambdaQueryWrapper=new LambdaQueryWrapper<>();
        lambdaQueryWrapper.orderByAsc(Category::getSort);
        categoryService.page(pageInfo,lambdaQueryWrapper);
        return R.success(pageInfo);
    }

二、新增菜品分类和新增套餐分类

在CategoryController中添加

根据sort字段进行升序排序

//新增菜品or套餐分类
@PostMapping
public R<String> addCategory(@RequestBody Category category){
    
    categoryService.save(category);
    return R.success("添加成功");
}

三、修改和删除分类

在CategoryController中添加

//修改分类
@PutMapping
public R<String> updateCategory(@RequestBody Category category){
    
    categoryService.updateById(category);
    return R.success("修改成功");
    
}

//删除分类
@DeleteMapping
public R<String> deleteCategory(Long ids){
    
    categoryService.removeById(ids);
    return R.success("删除成功");
}