拼多商城实现商品的全文检索

亦凉 2022-11-28 00:44 91阅读 0赞

![在这里插入图片描述][20200816160608498.png_pic_center]

### 文章目录 ###

*  修改 hosts 文件, 添加 www.pd.com 映射
 *  IDEA 导入 pd-web 项目
 *  修改数据库连接配置
 *  启动项目, 访问 www.pd.com
 *  商品检索调用分析
 *  pom.xml 添加 solr 和 lombok 依赖
 *  application.yml 添加 solr 连接信息
 *  Item 实体类
 *  SearchService 业务接口
 *  SearchServiceImpl 业务实现类
 *  SearchController 控制器

![在这里插入图片描述][20200816160614200.png_pic_center]

# 修改 hosts 文件, 添加 www.pd.com 映射 #

127.0.0.1      www.pd.com

# IDEA 导入 pd-web 项目 #

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

# 修改数据库连接配置 #

application.yml 配置文件中,修改连接配置

spring:
        datasource:
            type: com.alibaba.druid.pool.DruidDataSource
            driver-class-name: com.mysql.jdbc.Driver
            url: jdbc:mysql://127.0.0.1:3306/pd_store?useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2B8
            username: root
            password: root

# 启动项目, 访问 www.pd.com #

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

# 商品检索调用分析 #

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

# pom.xml 添加 solr 和 lombok 依赖 #

<dependency>
    	<groupId>org.springframework.boot</groupId>
    	<artifactId>spring-boot-starter-data-solr</artifactId>
    </dependency>
    
    <dependency>
    	<groupId>org.projectlombok</groupId>
    	<artifactId>lombok</artifactId>
    </dependency>

# application.yml 添加 solr 连接信息 #

spring:
      data:
        solr:   #注意修改ip地址
          host: http://192.168.64.170:8983/solr/pd

# Item 实体类 #

package com.pd.pojo;
    
    import java.io.Serializable;
    import org.apache.solr.client.solrj.beans.Field;
    import lombok.Data;
    
    @Data
    public class Item implements Serializable { 
    		private static final long serialVersionUID = 1L;
    		
    		@Field("id")
    		private String id;
    		@Field("title")
    		private String title;
    		@Field("sellPoint")
    		private String sellPoint;
    		@Field("price")
    		private Long price;
    		@Field("image")
    		private String image;
    }

# SearchService 业务接口 #

package com.pd.service;
    
    import java.util.List;
    
    import com.pd.pojo.Item;
    
    public interface SearchService { 
    	List<Item> findItemByKey(String key) throws Exception;
    }

# SearchServiceImpl 业务实现类 #

package com.pd.service.impl;
    
    import com.pd.pojo.Item;
    import com.pd.service.SearchService;
    import lombok.extern.slf4j.Slf4j;
    import org.apache.solr.client.solrj.SolrClient;
    import org.apache.solr.client.solrj.SolrQuery;
    import org.apache.solr.client.solrj.SolrServerException;
    import org.apache.solr.client.solrj.response.QueryResponse;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.boot.autoconfigure.solr.SolrAutoConfiguration;
    import org.springframework.stereotype.Service;
    
    import java.io.IOException;
    import java.util.List;
    
    @Service
    @Slf4j
    public class SearchServiceImpl implements SearchService { 
        /* SolrAutoConfiguration */
        @Autowired
        private SolrClient solrClient;
    
        @Override
        public List<Item> search(String key) throws Exception { 
            // 连接solr服务器，向solr服务器提交关键词，得到查询结果 json
            // json 转换成java对象
    
            // 封装查询信息
            SolrQuery q = new SolrQuery(key);
            q.setStart(0);
            q.setRows(20);
    
            // 执行查询
            QueryResponse r = solrClient.query(q);
            List<Item> list = r.getBeans(Item.class);
            return list;
        }
    }

# SearchController 控制器 #

package com.pd.controller;
    
    import com.pd.pojo.Item;
    import com.pd.service.SearchService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.ui.Model;
    import org.springframework.web.bind.annotation.GetMapping;
    
    import java.util.List;
    
    @Controller
    public class SearchController { 
        @Autowired
        private SearchService searchService;
    
        @GetMapping("/search/toSearch.html") // ?key=手机
        public String search(String key, Model model) throws Exception { 
            List<Item> list = searchService.search(key);
    
            model.addAttribute("list", list);
            return "/search.jsp";
        }
    }

> http://localhost/search/toSearch.html?key=手机

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

[20200816160608498.png_pic_center]: /images/20221124/4e315a67e1714e53a0a24d003518bc3d.png
[20200816160614200.png_pic_center]: /images/20221124/517eac173d804e7790fc98a5ac002fa7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMTgwODgxNDAyNQ_size_16_color_FFFFFF_t_70_pic_center]: /images/20221124/6071400df2884296b85fb109bf850c8c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMTgwODgxNDAyNQ_size_16_color_FFFFFF_t_70_pic_center 1]: /images/20221124/918809b4234a4080b0da6c2ecd001195.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMTgwODgxNDAyNQ_size_16_color_FFFFFF_t_70_pic_center 2]: /images/20221124/77e614c1a5434e5db049cb67e74f923b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMTgwODgxNDAyNQ_size_16_color_FFFFFF_t_70_pic_center 3]: /images/20221124/2f88ee873bbb4783ab050923da741a64.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMTgwODgxNDAyNQ_size_16_color_FFFFFF_t_70_pic_center 4]: /images/20221124/aab3c788e9b54a37bc45067a2f89f4f4.png