新增菜品涉及两张表的操作,一个新增菜品,一个是口味插入数据
多个数据表的操作,需要保证数据的一致性,serviceimpl加一个事务注解。
@transactional事务注解,保证整个方法的原子性。要么全成功,要么全失败。
需要开启注解方式的事务。在主函数上标注了@EnableTransactionManagement
dishDTO中不止菜品数据还有口味数据(动态数组),所以添加菜品的方法不能传进去DTO
而是一个实体类dish即可,在insert插入菜品方法中,下面验证flavor口味是否为null并且size()>0
拿到一个flavorMapper的bean调用insertBatch方法,意味批量增加传进flavors参数
关于配置文件xml的标签insert中,`useGeneratedKeys="true"`说明需要获得整个insert语句插入的时候所生成的主键值
DishController
```
@RestController
@RequestMapping("/admin/dish")
@Api(tags = "菜品相关接口")
@Slf4j
public class DishController {
//新增菜品
@Autowired
private DishService dishService;
@PostMapping
@ApiOperation("新增菜品")
public Result save(@RequestBody DishDTO dishDTO){
log.info("新增菜品{}",dishDTO);
dishService.saveWithFlavor(dishDTO);
return Result.success();
}
}
```
DishService
```plaintext
public interface DishService {
/**
* 新增菜品和对应的口味
* @param dishDTO
*/
public void saveWithFlavor(DishDTO dishDTO);
}
```
DishService包括容器里取出`dishrMapper和dishFlavorMapper`
```plaintext
@Service
@Slf4j
public class DishServiceimpl implements DishService {
@Autowired
private DishMapper dishMapper;
@Autowired
private DishFlavorMapper dishFlavorMapper;
/**
* 新增菜品,对应的口味数据
* @param dishDTO
*/
@Transactional
public void saveWithFlavor(DishDTO dishDTO){
//new的dish是空的,就用传进来的参数DTO传值
Dish dish = new Dish();
//这里的属性拷贝一定要保证属性的顺序是一致的
BeanUtils.copyProperties(dishDTO,dish);
//向菜品表插入一条数据
dishMapper.insert(dish);
Long dishId = dish.getId();
//向口味表插入N条数据
List<DishFlavor> flavors = dishDTO.getFlavors();
if (flavors != null && flavors.size()>0){
flavors.forEach(dishFlavor -> {
dishFlavor.setDishId(dishId);
});
dishFlavorMapper.insertBatch(flavors);
}
}
}
```
DishMapper
```plaintext
@Mapper
public interface DishMapper {
/**
* 根据分类id查询菜品数量
* @param categoryId
* @return
*/
@Select("select count(id) from dish where category_id = #{categoryId}")
Integer countByCategoryId(Long categoryId);
/**
* 插入菜品数据
* @param dish
*/
@AutoFill(value = OperationType.INSERT)
void insert(Dish dish);
}
```
DishFlavorMapper
```plaintext
@Mapper
public interface DishFlavorMapper {
void insertBatch(List<DishFlavor> flavors);
}
```
DishMapper.xml
```plaintext
<?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.sky.mapper.DishMapper">
<insert id="insert" useGeneratedKeys="true" keyProperty="id">
insert into dish(name,category_id,price,image,description,create_time,update_time,create_user,update_user,status)
values
(#{name},#{categoryId},#{price},#{image},#{description},#{createTime},#{updateTime},#{createUser},#{updateUser},#{status})
</insert>
</mapper>
```
DishFlavorMapper.xml
```plaintext
<?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.sky.mapper.DishFlavorMapper">
<insert id="insertBatch">
insert into dish_flavor(dish_id,name,value)
values
<foreach collection="flavors" item="df" separator=",">
(#{df.dishId},#{df.name},#{df.value}),
</foreach>
</insert>
</mapper>
```