瑞吉外卖项目实战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("删除成功");
}