电商项目（六）----后台添加商品中的查询商品分类

青旅半醒 2023-07-03 06:10 19阅读 0赞

## 一、实现添加商品的接口 ##

### 1. 在common\_item服务中实现商品分类查询 ###

#### 1.1 创建controller ####

package com.bjsxt.item.controller;
    
    import com.bjsxt.item.service.ItemCategoryService;
    import com.bjsxt.pojo.TbItemCat;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RequestParam;
    import org.springframework.web.bind.annotation.RestController;
    
    import java.util.List;
    
    @RestController
    @RequestMapping("/service/itemCategory")
    public class ItemCategoryController { 
        @Autowired
        private ItemCategoryService itemCategoryService;
        /** * 根据父节点查询子节点 */
        @RequestMapping("/selectItemCategoryByParentId")
        public List<TbItemCat> selectItemCategoryByParentId(@RequestParam Long id){ 
            return itemCategoryService.selectItemCategoryByParentId(id);
        }
    }

#### 1.2 创建service ####

package com.bjsxt.item.service;
    
    import com.bjsxt.pojo.TbItemCat;
    
    import java.util.List;
    
    public interface ItemCategoryService { 
        //根据父节点查询子节点 商品类目
        List<TbItemCat> selectItemCategoryByParentId(Long id);
    }

#### 1.3 创建serviceImpl ####

package com.bjsxt.item.service.impl;
    
    import com.bjsxt.item.service.ItemCategoryService;
    import com.bjsxt.mapper.TbItemCatMapper;
    import com.bjsxt.pojo.TbItemCat;
    import com.bjsxt.pojo.TbItemCatExample;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import java.util.List;
    @Service
    public class ItemCategoryServiceImpl implements ItemCategoryService { 
    
        @Autowired
        private TbItemCatMapper tbItemCatMapper;
        /** * 根据父节点查询子节点 * @param id * @return */
        @Override
        public List<TbItemCat> selectItemCategoryByParentId(Long id) { 
    
    
            TbItemCatExample example = new TbItemCatExample();
            example.createCriteria().andParentIdEqualTo(id).andStatusEqualTo(1);
    
            List<TbItemCat> tbItemCats = tbItemCatMapper.selectByExample(example);
    
    
            return tbItemCats;
        }
    }

## 测试：父节点为1的所有的子节点数据。 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY2NjA1MQ_size_16_color_FFFFFF_t_70]

### 2. 在backend\_item服务中实现商品分类查询 ###

#### 2.1 创建controller ####

package com.bjsxt.backenditem.controller;
    
    import com.bjsxt.backenditem.service.ItemCategoryService;
    import com.bjsxt.utils.Result;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RequestParam;
    import org.springframework.web.bind.annotation.RestController;
    
    @RestController
    @RequestMapping("/backend/itemCategory")
    public class ItemCategoryController { 
    
        @Autowired
        private ItemCategoryService itemCategoryService;
    
        /** * 查询商品类目：根据类目id，查询当前类目的子节点 */
        @RequestMapping("/selectItemCategoryByParentId")
        public Result selectItemCategoryByParentId(@RequestParam(value = "id",defaultValue = "0") Long id){ 
            try{ 
                Result result = itemCategoryService.selectItemCategoryByParentId(id);
                return result;
    
            }catch (Exception e){ 
                e.printStackTrace();
            }
            return Result.build(500,"error");
        }
    }

#### 2.2 创建service ####

package com.bjsxt.backenditem.service;
    
    import com.bjsxt.utils.Result;
    
    public interface ItemCategoryService { 
        Result selectItemCategoryByParentId(Long id);
    }

#### 2.3 创建serviceImpl ####

package com.bjsxt.backenditem.service.impl;
    
    import com.bjsxt.backenditem.feign.CommonItemFeignClient;
    import com.bjsxt.backenditem.service.ItemCategoryService;
    import com.bjsxt.pojo.TbItemCat;
    import com.bjsxt.utils.Result;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import java.util.List;
    
    @Service
    public class ItemCategoryServiceImpl implements ItemCategoryService { 
    
        @Autowired
        private CommonItemFeignClient commonItemFeignClient;
        @Override
        public Result selectItemCategoryByParentId(Long id) { 
            List<TbItemCat> tbItemCats = commonItemFeignClient.selectTbItemAllByPage(id);
            System.out.println(tbItemCats);
            if(tbItemCats.size()>0 && tbItemCats!=null){ 
                return  Result.ok(tbItemCats);
    
            }
            return Result.error("查无结果");
        }
    }

#### 2.4 创建FeignClient ####

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY2NjA1MQ_size_16_color_FFFFFF_t_70 1]

#### 2.5 测试 ####

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY2NjA1MQ_size_16_color_FFFFFF_t_70 2]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY2NjA1MQ_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200203100551666.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY2NjA1MQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY2NjA1MQ_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200203103305139.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY2NjA1MQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY2NjA1MQ_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20200203103337257.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY2NjA1MQ==,size_16,color_FFFFFF,t_70