【电商项目】----商品推荐

爱被打了一巴掌 2022-12-22 00:59 314阅读 0赞

# 前言 #

商品推荐

--------------------

# 需求分析与sql查询 #

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

*  首页分类的最新推荐商品查询

SELECT
    	* 
    FROM
    	category f
    	LEFT JOIN items i ON f.id = i.root_cat_id
    	LEFT JOIN items_img ii ON i.id = ii.item_id 
    WHERE
    	f.type = 1 
    	AND i.root_cat_id = 7 
    	AND ii.is_main = 1 
    ORDER BY
    	i.created_time DESC

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

# 接口编写 #

*  service  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyMzcwOTEz_size_16_color_FFFFFF_t_70_pic_center 3]
 *  impl  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyMzcwOTEz_size_16_color_FFFFFF_t_70_pic_center 4]
 *  mapper  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyMzcwOTEz_size_16_color_FFFFFF_t_70_pic_center 5]
 *  xml  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyMzcwOTEz_size_16_color_FFFFFF_t_70_pic_center 6]
 *  vo实体类

/**
     * 最新商品VO
     */
    public class NewItemsVO { 
    
        private Integer rootCatId;
        private String rootCatName;
        private String slogan;
        private String catImage;
        private String bgColor;
    
        private List<SimpleItemVO> simpleItemList;
    
        public Integer getRootCatId() { 
            return rootCatId;
        }
    
        public void setRootCatId(Integer rootCatId) { 
            this.rootCatId = rootCatId;
        }
    
        public String getRootCatName() { 
            return rootCatName;
        }
    
        public void setRootCatName(String rootCatName) { 
            this.rootCatName = rootCatName;
        }
    
        public String getSlogan() { 
            return slogan;
        }
    
        public void setSlogan(String slogan) { 
            this.slogan = slogan;
        }
    
        public String getCatImage() { 
            return catImage;
        }
    
        public void setCatImage(String catImage) { 
            this.catImage = catImage;
        }
    
        public String getBgColor() { 
            return bgColor;
        }
    
        public void setBgColor(String bgColor) { 
            this.bgColor = bgColor;
        }
    
        public List<SimpleItemVO> getSimpleItemList() { 
            return simpleItemList;
        }
    
        public void setSimpleItemList(List<SimpleItemVO> simpleItemList) { 
            this.simpleItemList = simpleItemList;
        }
    }

/**
     * 6个最新商品的简单数据类型
     */
    public class SimpleItemVO { 
    
        private String itemId;
        private String itemName;
        private String itemUrl;
    
        public String getItemId() { 
            return itemId;
        }
    
        public void setItemId(String itemId) { 
            this.itemId = itemId;
        }
    
        public String getItemName() { 
            return itemName;
        }
    
        public void setItemName(String itemName) { 
            this.itemName = itemName;
        }
    
        public String getItemUrl() { 
            return itemUrl;
        }
    
        public void setItemUrl(String itemUrl) { 
            this.itemUrl = itemUrl;
        }
    }

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyMzcwOTEz_size_16_color_FFFFFF_t_70_pic_center]: /images/20221120/e193908badf4496a8d94c7be3dfef589.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyMzcwOTEz_size_16_color_FFFFFF_t_70_pic_center 1]: /images/20221120/a32170f2175943faa986c32bbd7469e4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyMzcwOTEz_size_16_color_FFFFFF_t_70_pic_center 2]: /images/20221120/b913def53c4f4a9f8ca982534a283d99.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyMzcwOTEz_size_16_color_FFFFFF_t_70_pic_center 3]: /images/20221120/ab6e0c01700844f3ba6164076a7d607b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyMzcwOTEz_size_16_color_FFFFFF_t_70_pic_center 4]: /images/20221120/729bed14cf094cf9bb772de843b82dbc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyMzcwOTEz_size_16_color_FFFFFF_t_70_pic_center 5]: /images/20221120/b75064a4d51847d5b425faccf44886b6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyMzcwOTEz_size_16_color_FFFFFF_t_70_pic_center 6]: /images/20221120/3f48d0ca38e140fca40249b29df1f920.png