• 【java】【项目实战】[外卖九]项目优化（缓存）

    目录

    一、问题说明

    二、环境搭建

    2.1 Git管理代码

    2.1.1 创建本地仓库

    2.1.2 创建远程仓库

    2.1.3 创建分支--》推送到远程仓库

    2.2 maven坐标

    2.3 配置文件application.yml

    2.4 配置类RedisConfig

    三、缓存短信验证码

    3.1 实现思路

    3.2 代码改造

    3.2.1 UserController

    3.3 功能测试

    四、缓存菜品数据

    4.1 实现思路

    4.2 代码改造

    4.2.1 第一步改造DishController 中list方法

    4.2.2 第三步改造DishController中的save和update方法 

    4.3 功能测试

    五、Spring Cache

    5.1 Spring Cache介绍

    5.2 Spring Cache常用注解

    5.3 Spring Cache使用方式

     5.3.1 pom

    六、缓存套餐数据

    6.1 实现思路

    6.2 代码改造

     6.2.1 pom 坐标

    6.2.2 application.yml配置缓存数据过期时间

    6.2.3 开启缓存注解功能 ReggieApplication

     6.2.4  R实现 Serializable 接口

     6.2.5 在SetmealController的list方法加入@Cacheable注解

    6.2.6 在SetmealController的delete方法加入@CacheEvict注解

    6.2.7 在SetmealController的save方法加入@CacheEvict注解

    6.3 功能测试

    前言：使用缓存进行项目优化

    一、问题说明

    二、环境搭建

    2.1 Git管理代码

    2.1.1 创建本地仓库

    2.1.2 创建远程仓库

    略。。后续都省略

    2.1.3 创建分支--》推送到远程仓库

    略

    2.2 maven坐标

    1.     
    2.     <dependency>
    3.       <groupId>org.springframework.bootgroupId>
    4.       <artifactId>spring-boot-starter-data-redisartifactId>
    5.     dependency>

    2.3 配置文件application.yml

    1. server:
    2.   port: 8080
    3. spring:
    4.   application:
    5.     # 应用名称 可选
    6.     name: reggie_take_out_spuer
    7.   datasource:
    8.     druid:
    9.       driver-class-name: com.mysql.cj.jdbc.Driver
    10.       url: jdbc:mysql://localhost:3306/reggie?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowPublicKeyRetrieval=true
    11.       username: rot
    12.       password: ru
    13.   redis:
    14.     host: 127.0.0.1
    15.     port: 6379
    16.     password: 123
    17.     database: 0
    18. mybatis-plus:
    19.   configuration:
    20.     #在映射实体或者属性时，将数据库中表名和字段名中的下划线去掉，按照驼峰命名法映射
    21.     map-underscore-to-camel-case: true
    22.     log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
    23.   global-config:
    24.     db-config:
    25.       id-type: ASSIGN_ID
    26. # 文件上传目录
    27. reggie:
    28.   path: D:\images\

    2.4 配置类RedisConfig

    1. package com.runa.reggie.config;
    2.  
    3. import org.springframework.cache.annotation.CachingConfigurerSupport;
    4. import org.springframework.context.annotation.Bean;
    5. import org.springframework.context.annotation.Configuration;
    6. import org.springframework.data.redis.connection.RedisConnectionFactory;
    7. import org.springframework.data.redis.core.RedisTemplate;
    8. import org.springframework.data.redis.serializer.StringRedisSerializer;
    9.  
    10. @Configuration
    11. public class RedisConfig extends CachingConfigurerSupport {
    12.     @Bean
    13.     public RedisTemplate redisTemplate(RedisConnectionFactory connectionFactory) {
    14.         RedisTemplate redisTemplate = new RedisTemplate<>();
    15.         //默认的Key序列化器为：JdkSerializationRedisSerializer
    16.         redisTemplate.setKeySerializer(new StringRedisSerializer());
    17.         redisTemplate.setConnectionFactory(connectionFactory);
    18.         return redisTemplate;
    19.     }
    20. }

    三、缓存短信验证码

    3.1 实现思路

    3.2 代码改造

    3.2.1 UserController

    1. package com.runa.reggie.controller;
    2.  
    3. import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
    4. import com.runa.reggie.common.R;
    5. import com.runa.reggie.entity.User;
    6. import com.runa.reggie.service.UserService;
    7. import com.runa.reggie.utils.SMSUtils;
    8. import com.runa.reggie.utils.ValidateCodeUtils;
    9. import lombok.extern.slf4j.Slf4j;
    10. import org.apache.commons.lang.StringUtils;
    11. import org.springframework.beans.factory.annotation.Autowired;
    12. import org.springframework.data.redis.core.RedisTemplate;
    13. import org.springframework.web.bind.annotation.PostMapping;
    14. import org.springframework.web.bind.annotation.RequestBody;
    15. import org.springframework.web.bind.annotation.RequestMapping;
    16. import org.springframework.web.bind.annotation.RestController;
    17.  
    18. import javax.servlet.http.HttpSession;
    19. import java.util.Map;
    20. import java.util.concurrent.TimeUnit;
    21.  
    22. @RestController
    23. @RequestMapping("/user")
    24. @Slf4j
    25. public class UserController {
    26.  
    27.     @Autowired
    28.     private UserService userService;
    29.  
    30.     @Autowired
    31.     private RedisTemplate redisTemplate;
    32.  
    33.     /**
    34.      * 发送手机短信验证码
    35.      * @param user
    36.      * @return
    37.      */
    38.     @PostMapping("/sendMsg")
    39.     public R sendMsg(@RequestBody User user, HttpSession session){
    40.         //获取手机号
    41.         String phone = user.getPhone();
    42.  
    43.         if(StringUtils.isNotEmpty(phone)){
    44.             //生成随机的4位验证码
    45.             String code = ValidateCodeUtils.generateValidateCode(4).toString();
    46.             log.info("code={}",code);
    47.  
    48.             //调用阿里云提供的短信服务API完成发送短信
    49.             //SMSUtils.sendMessage("瑞吉外卖","",phone,code);
    50.  
    51.             //需要将生成的验证码保存到Session
    52. //            session.setAttribute(phone,code);
    53.  
    54.             // 将生成的验证码缓存到Redis中,并且设置有效期为5分钟
    55.             redisTemplate.opsForValue().set(phone,code,5, TimeUnit.MINUTES);
    56.  
    57.             return R.success("手机验证码短信发送成功");
    58.         }
    59.  
    60.         return R.error("短信发送失败");
    61.     }
    62.  
    63.     /**
    64.      * 移动端用户登录
    65.      * @param map
    66.      * @param session
    67.      * @return
    68.      */
    69.     @PostMapping("/login")
    70.     public R login(@RequestBody Map map, HttpSession session){
    71.         log.info(map.toString());
    72.  
    73.         //获取手机号
    74.         String phone = map.get("phone").toString();
    75.  
    76.         //获取验证码
    77.         String code = map.get("code").toString();
    78.  
    79.         //从Session中获取保存的验证码
    80. //        Object codeInSession = session.getAttribute(phone);
    81.  
    82.         //从redis中获取缓存的验证码
    83.         Object codeInSession = redisTemplate.opsForValue().get(phone);
    84.  
    85.         //进行验证码的比对（页面提交的验证码和Session中保存的验证码比对）
    86.         if(codeInSession != null && codeInSession.equals(code)){
    87.             //如果能够比对成功，说明登录成功
    88.  
    89.             LambdaQueryWrapper queryWrapper = new LambdaQueryWrapper<>();
    90.             queryWrapper.eq(User::getPhone,phone);
    91.  
    92.             User user = userService.getOne(queryWrapper);
    93.             if(user == null){
    94.                 //判断当前手机号对应的用户是否为新用户，如果是新用户就自动完成注册
    95.                 user = new User();
    96.                 user.setPhone(phone);
    97.                 user.setStatus(1);
    98.                 userService.save(user);
    99.             }
    100.             session.setAttribute("user",user.getId());
    101.  
    102.             // 如果用户登录成功，删除redis缓存的验证码
    103.             redisTemplate.delete(phone);
    104.  
    105.             return R.success(user);
    106.         }
    107.         return R.error("登录失败");
    108.     }
    109.  
    110. }

    3.3 功能测试

    启动后端服务、启动redis

    http://localhost:8080/front/page/login.html

    四、缓存菜品数据

    4.1 实现思路

    4.2 代码改造

    4.2.1 第一步改造DishController 中list方法

    1. package com.runa.reggie.controller;
    2.  
    3. import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
    4. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
    5. import com.runa.reggie.common.R;
    6. import com.runa.reggie.dto.DishDto;
    7. import com.runa.reggie.entity.Category;
    8. import com.runa.reggie.entity.Dish;
    9. import com.runa.reggie.entity.DishFlavor;
    10. import com.runa.reggie.service.CategoryService;
    11. import com.runa.reggie.service.DishFlavorService;
    12. import com.runa.reggie.service.DishService;
    13. import lombok.extern.slf4j.Slf4j;
    14. import org.springframework.beans.BeanUtils;
    15. import org.springframework.beans.factory.annotation.Autowired;
    16. import org.springframework.data.redis.core.RedisTemplate;
    17. import org.springframework.web.bind.annotation.*;
    18.  
    19. import java.util.List;
    20. import java.util.concurrent.TimeUnit;
    21. import java.util.stream.Collectors;
    22.  
    23. /**
    24.  * 菜品管理
    25.  */
    26. @RestController
    27. @RequestMapping("/dish")
    28. @Slf4j
    29. public class DishController {
    30.  
    31.     @Autowired
    32.     private DishService dishService;
    33.  
    34.     @Autowired
    35.     private DishFlavorService dishFlavorService;
    36.  
    37.     @Autowired
    38.     private CategoryService categoryService;
    39.  
    40.     @Autowired
    41.     private RedisTemplate redisTemplate;
    42.  
    43.     /**
    44.      * 新增菜品
    45.      * @param dishDto
    46.      * @return
    47.      */
    48.     @PostMapping
    49.     public R save(@RequestBody DishDto dishDto){
    50.         log.info(dishDto.toString());
    51.         dishService.saveWithFlavor(dishDto);
    52.       return R.success("新增菜品成功");
    53.     }
    54.  
    55.     @GetMapping("/page")
    56.     public R page(int page, int pageSize, String name){
    57.         // 构造分页构造器对象
    58.         Page pageInfo = new Page<>(page, pageSize);
    59.         Page dishDtoPage = new Page<>();
    60.  
    61.         //条件构造器
    62.         LambdaQueryWrapper queryWrapper = new LambdaQueryWrapper<>();
    63.         // 添加过滤条件
    64.         queryWrapper.like(name != null,Dish::getName,name);
    65.         // 添加排序条件
    66.         queryWrapper.orderByDesc(Dish::getUpdateTime);
    67.  
    68.         //执行分页查询
    69.         dishService.page(pageInfo,queryWrapper);
    70.  
    71.         // 对象拷贝
    72.         BeanUtils.copyProperties(pageInfo, dishDtoPage,"records");
    73.         List records = pageInfo.getRecords();
    74.         List list = records.stream().map((item) -> {
    75.             DishDto dishDto = new DishDto();
    76.  
    77.             BeanUtils.copyProperties(item,dishDto);
    78.             Long categoryId = item.getCategoryId();// 分类id
    79.             Category category = categoryService.getById(categoryId);
    80.             String categoryName = category.getName();
    81.             dishDto.setCategoryName(categoryName);
    82.             return dishDto;
    83.         }).collect(Collectors.toList());
    84.  
    85.  
    86.         dishDtoPage.setRecords(list);
    87.         return R.success(dishDtoPage);
    88.     }
    89.  
    90.  
    91.     /**
    92.      * 根据ID 查询菜品和对应口味信息 回显
    93.      * @param id
    94.      * @return
    95.      */
    96.     @GetMapping("/{id}")
    97.     public R get(@PathVariable Long id){
    98.         log.info("要查询显示的菜品信息是：{}",id);
    99.         DishDto dishDto = dishService.getByIdWithFlavor(id);
    100.         return R.success(dishDto);
    101.     }
    102.  
    103.     /**
    104.      * 修改菜品
    105.      * @param dishDto
    106.      * @return
    107.      */
    108.     @PutMapping
    109.     public R update(@RequestBody DishDto dishDto){
    110.         log.info(dishDto.toString());
    111.         dishService.updateWithFlavor(dishDto);
    112.         return R.success("修改菜品成功");
    113.     }
    114.  
    115.  
    116.  
    117.  
    118. //    /**
    119. //     * 根据条件查询对于菜品数据
    120. //     * @param dish
    121. //     * @return
    122. //     */
    123. //    @GetMapping("/list")
    124. //    public R> list(Dish dish){
    125. //
    126. //        // 构造查询条件
    127. //        LambdaQueryWrapper queryWrapper =new LambdaQueryWrapper<>();
    128. //        queryWrapper.eq(dish.getCategoryId() != null,Dish::getCategoryId,dish.getCategoryId());
    129. //        // 添加条件，查询状态为1（起售状态）的菜品
    130. //        queryWrapper.eq(Dish::getStatus,1);
    131. //        // 天添加排序条件
    132. //        queryWrapper.orderByAsc(Dish::getSort).orderByDesc(Dish::getUpdateTime);
    133. //        List list = dishService.list(queryWrapper);
    134. //        return R.success(list);
    135. //    }
    136. //}
    137.  
    138.     /**
    139.      * 根据条件查询对于菜品数据
    140.      * @param dish
    141.      * @return
    142.      */
    143.     @GetMapping("/list")
    144.     public R> list(Dish dish){
    145.         List dishDtoList = null;
    146.         // 动态构造key
    147.         String key = "dish_" + dish.getCategoryId() + "_" + dish.getStatus();
    148.  
    149.         // 先从redis获取缓存数据
    150.  
    151.         dishDtoList = (List) redisTemplate.opsForValue().get(key);
    152.  
    153.         if(dishDtoList != null){
    154.             // 1 如果存在，直接返回，无需查询数据库
    155.             return R.success(dishDtoList);
    156.  
    157.         }
    158.  
    159.         // 2 如果不存在，需要查询数据库，
    160.  
    161.         // 构造查询条件
    162.         LambdaQueryWrapper queryWrapper =new LambdaQueryWrapper<>();
    163.         queryWrapper.eq(dish.getCategoryId() != null,Dish::getCategoryId,dish.getCategoryId());
    164.         // 添加条件，查询状态为1（起售状态）的菜品
    165.         queryWrapper.eq(Dish::getStatus,1);
    166.         // 天添加排序条件
    167.         queryWrapper.orderByAsc(Dish::getSort).orderByDesc(Dish::getUpdateTime);
    168.         List list = dishService.list(queryWrapper);
    169.  
    170.         dishDtoList = list.stream().map((item) -> {
    171.             DishDto dishDto = new DishDto();
    172.  
    173.             BeanUtils.copyProperties(item,dishDto);
    174.             Long categoryId = item.getCategoryId();// 分类id
    175.             //根据id查询分类对象
    176.             Category category = categoryService.getById(categoryId);
    177.             if(category != null){
    178.                 String categoryName = category.getName();
    179.                 dishDto.setCategoryName(categoryName);
    180.             }
    181.             // 当前菜品的id
    182.             Long dishId = item.getId();
    183.  
    184.             LambdaQueryWrapper lambdaQueryWrapper = new LambdaQueryWrapper<>();
    185.             lambdaQueryWrapper.eq(DishFlavor::getDishId,dishId);
    186.             List dishFlavorList = dishFlavorService.list(lambdaQueryWrapper);
    187.             dishDto.setFlavors(dishFlavorList);
    188.  
    189.             return dishDto;
    190.         }).collect(Collectors.toList());
    191.  
    192.         // 2-1 不存在，将查询到的菜品数据缓存到redis
    193.         redisTemplate.opsForValue().set(key,dishDtoList,60, TimeUnit.MINUTES);
    194.  
    195.         return R.success(dishDtoList);
    196.     }
    197. }

    4.2.2 第三步改造DishController中的save和update方法 

    1. package com.runa.reggie.controller;
    2.  
    3. import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
    4. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
    5. import com.runa.reggie.common.R;
    6. import com.runa.reggie.dto.DishDto;
    7. import com.runa.reggie.entity.Category;
    8. import com.runa.reggie.entity.Dish;
    9. import com.runa.reggie.entity.DishFlavor;
    10. import com.runa.reggie.service.CategoryService;
    11. import com.runa.reggie.service.DishFlavorService;
    12. import com.runa.reggie.service.DishService;
    13. import lombok.extern.slf4j.Slf4j;
    14. import org.springframework.beans.BeanUtils;
    15. import org.springframework.beans.factory.annotation.Autowired;
    16. import org.springframework.data.redis.core.RedisTemplate;
    17. import org.springframework.web.bind.annotation.*;
    18.  
    19. import java.util.List;
    20. import java.util.Set;
    21. import java.util.concurrent.TimeUnit;
    22. import java.util.stream.Collectors;
    23.  
    24. /**
    25.  * 菜品管理
    26.  */
    27. @RestController
    28. @RequestMapping("/dish")
    29. @Slf4j
    30. public class DishController {
    31.  
    32.     @Autowired
    33.     private DishService dishService;
    34.  
    35.     @Autowired
    36.     private DishFlavorService dishFlavorService;
    37.  
    38.     @Autowired
    39.     private CategoryService categoryService;
    40.  
    41.     @Autowired
    42.     private RedisTemplate redisTemplate;
    43.  
    44.     /**
    45.      * 新增菜品
    46.      * @param dishDto
    47.      * @return
    48.      */
    49.     @PostMapping
    50.     public R save(@RequestBody DishDto dishDto){
    51.         log.info(dishDto.toString());
    52.         dishService.saveWithFlavor(dishDto);
    53.  
    54.         // 清理Redis所有菜品的缓存数据
    55. //        Set keys = redisTemplate.keys("dish_*");
    56.         // 清理Redis某个分类下的菜品的缓存数据
    57.         // 动态构造key
    58.         String key = "dish_" + dishDto.getCategoryId() + "_1";
    59.         redisTemplate.delete(key);
    60.         
    61.       return R.success("新增菜品成功");
    62.     }
    63.  
    64.     @GetMapping("/page")
    65.     public R page(int page, int pageSize, String name){
    66.         // 构造分页构造器对象
    67.         Page pageInfo = new Page<>(page, pageSize);
    68.         Page dishDtoPage = new Page<>();
    69.  
    70.         //条件构造器
    71.         LambdaQueryWrapper queryWrapper = new LambdaQueryWrapper<>();
    72.         // 添加过滤条件
    73.         queryWrapper.like(name != null,Dish::getName,name);
    74.         // 添加排序条件
    75.         queryWrapper.orderByDesc(Dish::getUpdateTime);
    76.  
    77.         //执行分页查询
    78.         dishService.page(pageInfo,queryWrapper);
    79.  
    80.         // 对象拷贝
    81.         BeanUtils.copyProperties(pageInfo, dishDtoPage,"records");
    82.         List records = pageInfo.getRecords();
    83.         List list = records.stream().map((item) -> {
    84.             DishDto dishDto = new DishDto();
    85.  
    86.             BeanUtils.copyProperties(item,dishDto);
    87.             Long categoryId = item.getCategoryId();// 分类id
    88.             Category category = categoryService.getById(categoryId);
    89.             String categoryName = category.getName();
    90.             dishDto.setCategoryName(categoryName);
    91.             return dishDto;
    92.         }).collect(Collectors.toList());
    93.  
    94.  
    95.         dishDtoPage.setRecords(list);
    96.         return R.success(dishDtoPage);
    97.     }
    98.  
    99.  
    100.     /**
    101.      * 根据ID 查询菜品和对应口味信息 回显
    102.      * @param id
    103.      * @return
    104.      */
    105.     @GetMapping("/{id}")
    106.     public R get(@PathVariable Long id){
    107.         log.info("要查询显示的菜品信息是：{}",id);
    108.         DishDto dishDto = dishService.getByIdWithFlavor(id);
    109.         return R.success(dishDto);
    110.     }
    111.  
    112.     /**
    113.      * 修改菜品
    114.      * @param dishDto
    115.      * @return
    116.      */
    117.     @PutMapping
    118.     public R update(@RequestBody DishDto dishDto){
    119.         log.info(dishDto.toString());
    120.         dishService.updateWithFlavor(dishDto);
    121.  
    122.         // 清理Redis所有菜品的缓存数据
    123. //        Set keys = redisTemplate.keys("dish_*");
    124.         // 清理Redis某个分类下的菜品的缓存数据
    125.         // 动态构造key
    126.         String key = "dish_" + dishDto.getCategoryId() + "_1";
    127.         redisTemplate.delete(key);
    128.  
    129.         return R.success("修改菜品成功");
    130.     }
    131.  
    132.  
    133.  
    134.  
    135. //    /**
    136. //     * 根据条件查询对于菜品数据
    137. //     * @param dish
    138. //     * @return
    139. //     */
    140. //    @GetMapping("/list")
    141. //    public R> list(Dish dish){
    142. //
    143. //        // 构造查询条件
    144. //        LambdaQueryWrapper queryWrapper =new LambdaQueryWrapper<>();
    145. //        queryWrapper.eq(dish.getCategoryId() != null,Dish::getCategoryId,dish.getCategoryId());
    146. //        // 添加条件，查询状态为1（起售状态）的菜品
    147. //        queryWrapper.eq(Dish::getStatus,1);
    148. //        // 天添加排序条件
    149. //        queryWrapper.orderByAsc(Dish::getSort).orderByDesc(Dish::getUpdateTime);
    150. //        List list = dishService.list(queryWrapper);
    151. //        return R.success(list);
    152. //    }
    153. //}
    154.  
    155.     /**
    156.      * 根据条件查询对于菜品数据
    157.      * @param dish
    158.      * @return
    159.      */
    160.     @GetMapping("/list")
    161.     public R> list(Dish dish){
    162.         List dishDtoList = null;
    163.         // 动态构造key
    164.         String key = "dish_" + dish.getCategoryId() + "_" + dish.getStatus();
    165.  
    166.         // 先从redis获取缓存数据
    167.  
    168.         dishDtoList = (List) redisTemplate.opsForValue().get(key);
    169.  
    170.         if(dishDtoList != null){
    171.             // 1 如果存在，直接返回，无需查询数据库
    172.             return R.success(dishDtoList);
    173.  
    174.         }
    175.  
    176.         // 2 如果不存在，需要查询数据库，
    177.  
    178.         // 构造查询条件
    179.         LambdaQueryWrapper queryWrapper =new LambdaQueryWrapper<>();
    180.         queryWrapper.eq(dish.getCategoryId() != null,Dish::getCategoryId,dish.getCategoryId());
    181.         // 添加条件，查询状态为1（起售状态）的菜品
    182.         queryWrapper.eq(Dish::getStatus,1);
    183.         // 天添加排序条件
    184.         queryWrapper.orderByAsc(Dish::getSort).orderByDesc(Dish::getUpdateTime);
    185.         List list = dishService.list(queryWrapper);
    186.  
    187.         dishDtoList = list.stream().map((item) -> {
    188.             DishDto dishDto = new DishDto();
    189.  
    190.             BeanUtils.copyProperties(item,dishDto);
    191.             Long categoryId = item.getCategoryId();// 分类id
    192.             //根据id查询分类对象
    193.             Category category = categoryService.getById(categoryId);
    194.             if(category != null){
    195.                 String categoryName = category.getName();
    196.                 dishDto.setCategoryName(categoryName);
    197.             }
    198.             // 当前菜品的id
    199.             Long dishId = item.getId();
    200.  
    201.             LambdaQueryWrapper lambdaQueryWrapper = new LambdaQueryWrapper<>();
    202.             lambdaQueryWrapper.eq(DishFlavor::getDishId,dishId);
    203.             List dishFlavorList = dishFlavorService.list(lambdaQueryWrapper);
    204.             dishDto.setFlavors(dishFlavorList);
    205.  
    206.             return dishDto;
    207.         }).collect(Collectors.toList());
    208.  
    209.         // 2-1 不存在，将查询到的菜品数据缓存到redis
    210.         redisTemplate.opsForValue().set(key,dishDtoList,60, TimeUnit.MINUTES);
    211.  
    212.         return R.success(dishDtoList);
    213.     }
    214. }

    4.3 功能测试

    1. http://localhost:8080/front/page/login.html
    2.  
    3. http://localhost:8080/backend/index.html
    4.

     

    五、Spring Cache

    5.1 Spring Cache介绍

    5.2 Spring Cache常用注解

    5.3 Spring Cache使用方式

     5.3.1 pom

    1. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    2.   xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    3.   <modelVersion>4.0.0modelVersion>
    4.  
    5.   <groupId>com.runagroupId>
    6.   <artifactId>reggie_take_out_spuerartifactId>
    7.   <version>1.0-SNAPSHOTversion>
    8.   <packaging>jarpackaging>
    9.  
    10.   <parent>
    11.     <groupId>org.springframework.bootgroupId>
    12.     <artifactId>spring-boot-starter-parentartifactId>
    13.     <version>2.4.5version>
    14.     <relativePath/> 
    15.   parent>
    16.  
    17.   <name>reggie_take_out_spuername>
    18.   <url>http://maven.apache.orgurl>
    19.  
    20.   <properties>
    21.     <project.build.sourceEncoding>UTF-8project.build.sourceEncoding>
    22.     <java.version>1.8java.version>
    23.   properties>
    24.  
    25.   <dependencies>
    26.     
    27.     <dependency>
    28.       <groupId>com.aliyungroupId>
    29.       <artifactId>aliyun-java-sdk-coreartifactId>
    30.       <version>4.5.16version>
    31.     dependency>
    32.     <dependency>
    33.       <groupId>com.aliyungroupId>
    34.       <artifactId>aliyun-java-sdk-dysmsapiartifactId>
    35.       <version>2.1.0version>
    36.     dependency>
    37.     <dependency>
    38.       <groupId>org.springframework.bootgroupId>
    39.       <artifactId>spring-boot-starterartifactId>
    40.     dependency>
    41.  
    42.     <dependency>
    43.       <groupId>org.springframework.bootgroupId>
    44.       <artifactId>spring-boot-starter-testartifactId>
    45.       <scope>testscope>
    46.     dependency>
    47.  
    48.     <dependency>
    49.       <groupId>org.springframework.bootgroupId>
    50.       <artifactId>spring-boot-starter-webartifactId>
    51.       <scope>compilescope>
    52.     dependency>
    53.  
    54.     <dependency>
    55.       <groupId>com.baomidougroupId>
    56.       <artifactId>mybatis-plus-boot-starterartifactId>
    57.       <version>3.4.2version>
    58.     dependency>
    59.  
    60.     <dependency>
    61.       <groupId>org.projectlombokgroupId>
    62.       <artifactId>lombokartifactId>
    63.       <version>1.18.20version>
    64.     dependency>
    65.  
    66.     <dependency>
    67.       <groupId>com.alibabagroupId>
    68.       <artifactId>fastjsonartifactId>
    69.       <version>1.2.76version>
    70.     dependency>
    71.  
    72.     <dependency>
    73.       <groupId>commons-langgroupId>
    74.       <artifactId>commons-langartifactId>
    75.       <version>2.6version>
    76.     dependency>
    77.  
    78.     <dependency>
    79.       <groupId>mysqlgroupId>
    80.       <artifactId>mysql-connector-javaartifactId>
    81.       <scope>runtimescope>
    82.     dependency>
    83.  
    84.     <dependency>
    85.       <groupId>com.alibabagroupId>
    86.       <artifactId>druid-spring-boot-starterartifactId>
    87.       <version>1.1.23version>
    88.     dependency>
    89.  
    90.     <dependency>
    91.       <groupId>junitgroupId>
    92.       <artifactId>junitartifactId>
    93.       <version>3.8.1version>
    94.       <scope>testscope>
    95.     dependency>
    96.  
    97.     
    98.     <dependency>
    99.       <groupId>org.springframework.bootgroupId>
    100.       <artifactId>spring-boot-starter-data-redisartifactId>
    101.     dependency>
    102.  
    103.     
    104.     <dependency>
    105.       <groupId>org.springframework.bootgroupId>
    106.       <artifactId>spring-boot-starter-cacheartifactId>
    107.     dependency>
    108.  
    109.  
    110.   dependencies>
    111.  
    112.   <build>
    113.     <plugins>
    114.       <plugin>
    115.         <groupId>org.springframework.bootgroupId>
    116.         <artifactId>spring-boot-maven-pluginartifactId>
    117.         <version>2.4.5version>
    118.       plugin>
    119.     plugins>
    120.   build>
    121. project>

    六、缓存套餐数据

    6.1 实现思路

    6.2 代码改造

     6.2.1 pom 坐标

    1. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    2.   xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    3.   <modelVersion>4.0.0modelVersion>
    4.  
    5.   <groupId>com.runagroupId>
    6.   <artifactId>reggie_take_out_spuerartifactId>
    7.   <version>1.0-SNAPSHOTversion>
    8.   <packaging>jarpackaging>
    9.  
    10.   <parent>
    11.     <groupId>org.springframework.bootgroupId>
    12.     <artifactId>spring-boot-starter-parentartifactId>
    13.     <version>2.4.5version>
    14.     <relativePath/> 
    15.   parent>
    16.  
    17.   <name>reggie_take_out_spuername>
    18.   <url>http://maven.apache.orgurl>
    19.  
    20.   <properties>
    21.     <project.build.sourceEncoding>UTF-8project.build.sourceEncoding>
    22.     <java.version>1.8java.version>
    23.   properties>
    24.  
    25.   <dependencies>
    26.     
    27.     <dependency>
    28.       <groupId>com.aliyungroupId>
    29.       <artifactId>aliyun-java-sdk-coreartifactId>
    30.       <version>4.5.16version>
    31.     dependency>
    32.     <dependency>
    33.       <groupId>com.aliyungroupId>
    34.       <artifactId>aliyun-java-sdk-dysmsapiartifactId>
    35.       <version>2.1.0version>
    36.     dependency>
    37.     <dependency>
    38.       <groupId>org.springframework.bootgroupId>
    39.       <artifactId>spring-boot-starterartifactId>
    40.     dependency>
    41.  
    42.     <dependency>
    43.       <groupId>org.springframework.bootgroupId>
    44.       <artifactId>spring-boot-starter-testartifactId>
    45.       <scope>testscope>
    46.     dependency>
    47.  
    48.     <dependency>
    49.       <groupId>org.springframework.bootgroupId>
    50.       <artifactId>spring-boot-starter-webartifactId>
    51.       <scope>compilescope>
    52.     dependency>
    53.  
    54.     <dependency>
    55.       <groupId>com.baomidougroupId>
    56.       <artifactId>mybatis-plus-boot-starterartifactId>
    57.       <version>3.4.2version>
    58.     dependency>
    59.  
    60.     <dependency>
    61.       <groupId>org.projectlombokgroupId>
    62.       <artifactId>lombokartifactId>
    63.       <version>1.18.20version>
    64.     dependency>
    65.  
    66.     <dependency>
    67.       <groupId>com.alibabagroupId>
    68.       <artifactId>fastjsonartifactId>
    69.       <version>1.2.76version>
    70.     dependency>
    71.  
    72.     <dependency>
    73.       <groupId>commons-langgroupId>
    74.       <artifactId>commons-langartifactId>
    75.       <version>2.6version>
    76.     dependency>
    77.  
    78.     <dependency>
    79.       <groupId>mysqlgroupId>
    80.       <artifactId>mysql-connector-javaartifactId>
    81.       <scope>runtimescope>
    82.     dependency>
    83.  
    84.     <dependency>
    85.       <groupId>com.alibabagroupId>
    86.       <artifactId>druid-spring-boot-starterartifactId>
    87.       <version>1.1.23version>
    88.     dependency>
    89.  
    90.     <dependency>
    91.       <groupId>junitgroupId>
    92.       <artifactId>junitartifactId>
    93.       <version>3.8.1version>
    94.       <scope>testscope>
    95.     dependency>
    96.  
    97.     
    98.     <dependency>
    99.       <groupId>org.springframework.bootgroupId>
    100.       <artifactId>spring-boot-starter-data-redisartifactId>
    101.     dependency>
    102.  
    103.     
    104.     <dependency>
    105.       <groupId>org.springframework.bootgroupId>
    106.       <artifactId>spring-boot-starter-cacheartifactId>
    107.     dependency>
    108.  
    109.  
    110.   dependencies>
    111.  
    112.   <build>
    113.     <plugins>
    114.       <plugin>
    115.         <groupId>org.springframework.bootgroupId>
    116.         <artifactId>spring-boot-maven-pluginartifactId>
    117.         <version>2.4.5version>
    118.       plugin>
    119.     plugins>
    120.   build>
    121. project>

    6.2.2 application.yml配置缓存数据过期时间

    1. server:
    2.   port: 8080
    3. spring:
    4.   application:
    5.     # 应用名称 可选
    6.     name: reggie_take_out_spuer
    7.   datasource:
    8.     druid:
    9.       driver-class-name: com.mysql.cj.jdbc.Driver
    10.       url: jdbc:mysql://localhost:3306/reggie?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowPublicKeyRetrieval=true
    11.       username: root
    12.       password: runa#2050
    13.   redis:
    14.     host: 127.0.0.1
    15.     port: 6379
    16.     password: 123456
    17.     database: 0
    18.   cache:
    19.     redis:
    20.       time-to-live: 1800000  # 设置缓存数据的过期时间
    21. mybatis-plus:
    22.   configuration:
    23.     #在映射实体或者属性时，将数据库中表名和字段名中的下划线去掉，按照驼峰命名法映射
    24.     map-underscore-to-camel-case: true
    25.     log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
    26.   global-config:
    27.     db-config:
    28.       id-type: ASSIGN_ID
    29. # 文件上传目录
    30. reggie:
    31.   path: D:\images\

    6.2.3 开启缓存注解功能 ReggieApplication

     

    1. package com.runa.reggie;
    2.  
    3. import lombok.extern.slf4j.Slf4j;
    4. import org.springframework.boot.SpringApplication;
    5. import org.springframework.boot.autoconfigure.SpringBootApplication;
    6. import org.springframework.boot.web.servlet.ServletComponentScan;
    7. import org.springframework.cache.annotation.EnableCaching;
    8. import org.springframework.transaction.annotation.EnableTransactionManagement;
    9.  
    10. @Slf4j
    11. @SpringBootApplication
    12. @ServletComponentScan
    13. @EnableTransactionManagement
    14. @EnableCaching  // 开启spring Cache注解方式的缓存功能
    15. public class ReggieApplication {
    16.     public static void main(String[] args) {
    17.         SpringApplication.run(ReggieApplication.class,args);
    18.         log.info("项目启动成功~~~");
    19.     }
    20. }

     6.2.4  R实现 Serializable 接口

    1. package com.runa.reggie.common;
    2.  
    3. import lombok.Data;
    4.  
    5. import java.io.Serializable;
    6. import java.util.HashMap;
    7. import java.util.Map;
    8.  
    9.  
    10. /**
    11.  * 通用返回结果，服务端响应的数据最终都会封装成此对象
    12.  * @param 
    13.  */
    14. @Data
    15. public class R implements Serializable {
    16.  
    17.     private Integer code; //编码：1成功，0和其它数字为失败
    18.  
    19.     private String msg; //错误信息
    20.  
    21.     private T data; //数据
    22.  
    23.     private Map map = new HashMap(); //动态数据
    24.  
    25.     public static  R success(T object) {
    26.         R r = new R();
    27.         r.data = object;
    28.         r.code = 1;
    29.         return r;
    30.     }
    31.  
    32.     public static  R error(String msg) {
    33.         R r = new R();
    34.         r.msg = msg;
    35.         r.code = 0;
    36.         return r;
    37.     }
    38.  
    39.     public R add(String key, Object value) {
    40.         this.map.put(key, value);
    41.         return this;
    42.     }
    43.  
    44. }

     6.2.5 在SetmealController的list方法加入@Cacheable注解

    1. package com.runa.reggie.controller;
    2.  
    3.  
    4. import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
    5. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
    6. import com.runa.reggie.common.R;
    7. import com.runa.reggie.dto.SetmealDto;
    8. import com.runa.reggie.entity.Category;
    9. import com.runa.reggie.entity.Setmeal;
    10. import com.runa.reggie.service.CategoryService;
    11. import com.runa.reggie.service.SetmealDishService;
    12. import com.runa.reggie.service.SetmealService;
    13. import lombok.extern.slf4j.Slf4j;
    14. import org.springframework.beans.BeanUtils;
    15. import org.springframework.beans.factory.annotation.Autowired;
    16. import org.springframework.cache.annotation.Cacheable;
    17. import org.springframework.web.bind.annotation.*;
    18.  
    19. import java.util.List;
    20. import java.util.stream.Collectors;
    21.  
    22. @RestController
    23. @RequestMapping("/setmeal")
    24. @Slf4j
    25. public class SetmealController {
    26.  
    27.     @Autowired
    28.     private SetmealService setmealService;
    29.  
    30.     @Autowired
    31.     private CategoryService categoryService;
    32.  
    33.     @Autowired
    34.     private SetmealDishService setmealDishService;
    35.  
    36.     /**
    37.      * 新增套餐
    38.      * @param setmealDto
    39.      * @return
    40.      */
    41.     @PostMapping
    42.     public R save(@RequestBody SetmealDto setmealDto){
    43.         log.info("套餐信息：{}",setmealDto);
    44.  
    45.         setmealService.saveWithDish(setmealDto);
    46.  
    47.         return R.success("新增套餐成功");
    48.     }
    49.  
    50.     /**
    51.      * 套餐分页查询
    52.      * @param page
    53.      * @param pageSize
    54.      * @param name
    55.      * @return
    56.      */
    57.     @GetMapping("/page")
    58.     public R page(int page, int pageSize, String name){
    59.         //分页构造器对象
    60.         Page pageInfo = new Page<>(page,pageSize);
    61.         Page dtoPage = new Page<>();
    62.  
    63.         LambdaQueryWrapper queryWrapper = new LambdaQueryWrapper<>();
    64.         //添加查询条件，根据name进行like模糊查询
    65.         queryWrapper.like(name != null,Setmeal::getName,name);
    66.         //添加排序条件，根据更新时间降序排列
    67.         queryWrapper.orderByDesc(Setmeal::getUpdateTime);
    68.  
    69.         setmealService.page(pageInfo,queryWrapper);
    70.  
    71.         //对象拷贝
    72.         BeanUtils.copyProperties(pageInfo,dtoPage,"records");
    73.         List records = pageInfo.getRecords();
    74.  
    75.         List list = records.stream().map((item) -> {
    76.             SetmealDto setmealDto = new SetmealDto();
    77.             //对象拷贝
    78.             BeanUtils.copyProperties(item,setmealDto);
    79.             //分类id
    80.             Long categoryId = item.getCategoryId();
    81.             //根据分类id查询分类对象
    82.             Category category = categoryService.getById(categoryId);
    83.             if(category != null){
    84.                 //分类名称
    85.                 String categoryName = category.getName();
    86.                 setmealDto.setCategoryName(categoryName);
    87.             }
    88.             return setmealDto;
    89.         }).collect(Collectors.toList());
    90.  
    91.         dtoPage.setRecords(list);
    92.         return R.success(dtoPage);
    93.     }
    94.  
    95.     /**
    96.      * 删除套餐
    97.      * @param ids
    98.      * @return
    99.      */
    100.     @DeleteMapping
    101.     public R delete(@RequestParam List ids){
    102.         log.info("ids:{}",ids);
    103.  
    104.         setmealService.removeWithDish(ids);
    105.  
    106.         return R.success("套餐数据删除成功");
    107.     }
    108.  
    109.     /**
    110.      * 根据条件查询套餐数据
    111.      * @param setmeal
    112.      * @return
    113.      */
    114.     @GetMapping("/list")
    115.     @Cacheable(value = "setmealCache", key = "#setmeal.categoryId + '_' + #setmeal.status")
    116.     public R> list(Setmeal setmeal){
    117.         LambdaQueryWrapper queryWrapper = new LambdaQueryWrapper<>();
    118.         queryWrapper.eq(setmeal.getCategoryId() != null,Setmeal::getCategoryId,setmeal.getCategoryId());
    119.         queryWrapper.eq(setmeal.getStatus() != null,Setmeal::getStatus,setmeal.getStatus());
    120.         queryWrapper.orderByDesc(Setmeal::getUpdateTime);
    121.         List list = setmealService.list(queryWrapper);
    122.         return R.success(list);
    123.  
    124.     }
    125.  
    126. }

    6.2.6 在SetmealController的delete方法加入@CacheEvict注解

    1. package com.runa.reggie.controller;
    2.  
    3.  
    4. import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
    5. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
    6. import com.runa.reggie.common.R;
    7. import com.runa.reggie.dto.SetmealDto;
    8. import com.runa.reggie.entity.Category;
    9. import com.runa.reggie.entity.Setmeal;
    10. import com.runa.reggie.service.CategoryService;
    11. import com.runa.reggie.service.SetmealDishService;
    12. import com.runa.reggie.service.SetmealService;
    13. import lombok.extern.slf4j.Slf4j;
    14. import org.springframework.beans.BeanUtils;
    15. import org.springframework.beans.factory.annotation.Autowired;
    16. import org.springframework.cache.annotation.CacheEvict;
    17. import org.springframework.cache.annotation.Cacheable;
    18. import org.springframework.web.bind.annotation.*;
    19.  
    20. import java.util.List;
    21. import java.util.stream.Collectors;
    22.  
    23. @RestController
    24. @RequestMapping("/setmeal")
    25. @Slf4j
    26. public class SetmealController {
    27.  
    28.     @Autowired
    29.     private SetmealService setmealService;
    30.  
    31.     @Autowired
    32.     private CategoryService categoryService;
    33.  
    34.     @Autowired
    35.     private SetmealDishService setmealDishService;
    36.  
    37.     /**
    38.      * 新增套餐
    39.      * @param setmealDto
    40.      * @return
    41.      */
    42.     @PostMapping
    43.     public R save(@RequestBody SetmealDto setmealDto){
    44.         log.info("套餐信息：{}",setmealDto);
    45.  
    46.         setmealService.saveWithDish(setmealDto);
    47.  
    48.         return R.success("新增套餐成功");
    49.     }
    50.  
    51.     /**
    52.      * 套餐分页查询
    53.      * @param page
    54.      * @param pageSize
    55.      * @param name
    56.      * @return
    57.      */
    58.     @GetMapping("/page")
    59.     public R page(int page, int pageSize, String name){
    60.         //分页构造器对象
    61.         Page pageInfo = new Page<>(page,pageSize);
    62.         Page dtoPage = new Page<>();
    63.  
    64.         LambdaQueryWrapper queryWrapper = new LambdaQueryWrapper<>();
    65.         //添加查询条件，根据name进行like模糊查询
    66.         queryWrapper.like(name != null,Setmeal::getName,name);
    67.         //添加排序条件，根据更新时间降序排列
    68.         queryWrapper.orderByDesc(Setmeal::getUpdateTime);
    69.  
    70.         setmealService.page(pageInfo,queryWrapper);
    71.  
    72.         //对象拷贝
    73.         BeanUtils.copyProperties(pageInfo,dtoPage,"records");
    74.         List records = pageInfo.getRecords();
    75.  
    76.         List list = records.stream().map((item) -> {
    77.             SetmealDto setmealDto = new SetmealDto();
    78.             //对象拷贝
    79.             BeanUtils.copyProperties(item,setmealDto);
    80.             //分类id
    81.             Long categoryId = item.getCategoryId();
    82.             //根据分类id查询分类对象
    83.             Category category = categoryService.getById(categoryId);
    84.             if(category != null){
    85.                 //分类名称
    86.                 String categoryName = category.getName();
    87.                 setmealDto.setCategoryName(categoryName);
    88.             }
    89.             return setmealDto;
    90.         }).collect(Collectors.toList());
    91.  
    92.         dtoPage.setRecords(list);
    93.         return R.success(dtoPage);
    94.     }
    95.  
    96.     /**
    97.      * 删除套餐
    98.      * @param ids
    99.      * @return
    100.      */
    101.     @DeleteMapping
    102.     @CacheEvict(value = "setmealCache" , allEntries = true)
    103.     public R delete(@RequestParam List ids){
    104.         log.info("ids:{}",ids);
    105.  
    106.         setmealService.removeWithDish(ids);
    107.  
    108.         return R.success("套餐数据删除成功");
    109.     }
    110.  
    111.     /**
    112.      * 根据条件查询套餐数据
    113.      * @param setmeal
    114.      * @return
    115.      */
    116.     @GetMapping("/list")
    117.     @Cacheable(value = "setmealCache", key = "#setmeal.categoryId + '_' + #setmeal.status")
    118.     public R> list(Setmeal setmeal){
    119.         LambdaQueryWrapper queryWrapper = new LambdaQueryWrapper<>();
    120.         queryWrapper.eq(setmeal.getCategoryId() != null,Setmeal::getCategoryId,setmeal.getCategoryId());
    121.         queryWrapper.eq(setmeal.getStatus() != null,Setmeal::getStatus,setmeal.getStatus());
    122.         queryWrapper.orderByDesc(Setmeal::getUpdateTime);
    123.         List list = setmealService.list(queryWrapper);
    124.         return R.success(list);
    125.  
    126.     }
    127.  
    128. }

    6.2.7 在SetmealController的save方法加入@CacheEvict注解

    1. package com.runa.reggie.controller;
    2.  
    3.  
    4. import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
    5. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
    6. import com.runa.reggie.common.R;
    7. import com.runa.reggie.dto.SetmealDto;
    8. import com.runa.reggie.entity.Category;
    9. import com.runa.reggie.entity.Setmeal;
    10. import com.runa.reggie.service.CategoryService;
    11. import com.runa.reggie.service.SetmealDishService;
    12. import com.runa.reggie.service.SetmealService;
    13. import lombok.extern.slf4j.Slf4j;
    14. import org.springframework.beans.BeanUtils;
    15. import org.springframework.beans.factory.annotation.Autowired;
    16. import org.springframework.cache.annotation.CacheEvict;
    17. import org.springframework.cache.annotation.Cacheable;
    18. import org.springframework.web.bind.annotation.*;
    19.  
    20. import java.util.List;
    21. import java.util.stream.Collectors;
    22.  
    23. @RestController
    24. @RequestMapping("/setmeal")
    25. @Slf4j
    26. public class SetmealController {
    27.  
    28.     @Autowired
    29.     private SetmealService setmealService;
    30.  
    31.     @Autowired
    32.     private CategoryService categoryService;
    33.  
    34.     @Autowired
    35.     private SetmealDishService setmealDishService;
    36.  
    37.     /**
    38.      * 新增套餐
    39.      * @param setmealDto
    40.      * @return
    41.      */
    42.     @PostMapping
    43.     @CacheEvict(value = "setmealCache" , allEntries = true)
    44.     public R save(@RequestBody SetmealDto setmealDto){
    45.         log.info("套餐信息：{}",setmealDto);
    46.  
    47.         setmealService.saveWithDish(setmealDto);
    48.  
    49.         return R.success("新增套餐成功");
    50.     }
    51.  
    52.     /**
    53.      * 套餐分页查询
    54.      * @param page
    55.      * @param pageSize
    56.      * @param name
    57.      * @return
    58.      */
    59.     @GetMapping("/page")
    60.     public R page(int page, int pageSize, String name){
    61.         //分页构造器对象
    62.         Page pageInfo = new Page<>(page,pageSize);
    63.         Page dtoPage = new Page<>();
    64.  
    65.         LambdaQueryWrapper queryWrapper = new LambdaQueryWrapper<>();
    66.         //添加查询条件，根据name进行like模糊查询
    67.         queryWrapper.like(name != null,Setmeal::getName,name);
    68.         //添加排序条件，根据更新时间降序排列
    69.         queryWrapper.orderByDesc(Setmeal::getUpdateTime);
    70.  
    71.         setmealService.page(pageInfo,queryWrapper);
    72.  
    73.         //对象拷贝
    74.         BeanUtils.copyProperties(pageInfo,dtoPage,"records");
    75.         List records = pageInfo.getRecords();
    76.  
    77.         List list = records.stream().map((item) -> {
    78.             SetmealDto setmealDto = new SetmealDto();
    79.             //对象拷贝
    80.             BeanUtils.copyProperties(item,setmealDto);
    81.             //分类id
    82.             Long categoryId = item.getCategoryId();
    83.             //根据分类id查询分类对象
    84.             Category category = categoryService.getById(categoryId);
    85.             if(category != null){
    86.                 //分类名称
    87.                 String categoryName = category.getName();
    88.                 setmealDto.setCategoryName(categoryName);
    89.             }
    90.             return setmealDto;
    91.         }).collect(Collectors.toList());
    92.  
    93.         dtoPage.setRecords(list);
    94.         return R.success(dtoPage);
    95.     }
    96.  
    97.     /**
    98.      * 删除套餐
    99.      * @param ids
    100.      * @return
    101.      */
    102.     @DeleteMapping
    103.     @CacheEvict(value = "setmealCache" , allEntries = true)
    104.     public R delete(@RequestParam List ids){
    105.         log.info("ids:{}",ids);
    106.  
    107.         setmealService.removeWithDish(ids);
    108.  
    109.         return R.success("套餐数据删除成功");
    110.     }
    111.  
    112.     /**
    113.      * 根据条件查询套餐数据
    114.      * @param setmeal
    115.      * @return
    116.      */
    117.     @GetMapping("/list")
    118.     @Cacheable(value = "setmealCache", key = "#setmeal.categoryId + '_' + #setmeal.status")
    119.     public R> list(Setmeal setmeal){
    120.         LambdaQueryWrapper queryWrapper = new LambdaQueryWrapper<>();
    121.         queryWrapper.eq(setmeal.getCategoryId() != null,Setmeal::getCategoryId,setmeal.getCategoryId());
    122.         queryWrapper.eq(setmeal.getStatus() != null,Setmeal::getStatus,setmeal.getStatus());
    123.         queryWrapper.orderByDesc(Setmeal::getUpdateTime);
    124.         List list = setmealService.list(queryWrapper);
    125.         return R.success(list);
    126.  
    127.     }
    128.  
    129. }

    6.3 功能测试

    1. http://localhost:8080/front/page/login.html
    2.  
    3. http://localhost:8080/backend/index.html

  • 相关阅读:
    C++之STL
    华为联机对战如何提升玩家匹配成功几率
    网络编程【TCP单向通信、TCP双向通信、一对多应用、一对多聊天服务器】(二)-全面详解（学习总结---从入门到深化）
    【排序算法】详解直接插入排序和希尔排序原理及其性能分析
    前端基础入门之JS 正则表达式
    Day10：图形用户界面和游戏开发
    Golang字符串处理
    Bugly iOS自动导入符号表
    C语言——文件
    一个简单的HTML网页 故宫学生网页设计作品 dreamweaver作业静态HTML网页设计模板 旅游景点网页作业制作
  • 原文地址：https://blog.csdn.net/legend818/article/details/132606895