全文检索工具elasticsearch:第四章:开发电商的搜索列表功能

1、功能简介
1.1入口: 两个
首页的分类

 
 

 









搜索栏

 





列表展示页面

 



















2 根据业务搭建数据结构

这时我们要思考三个问题:

    哪些字段需要分词
    我们用哪些字段进行过滤
    哪些字段我们需要通过搜索显示出来。

     

需要分词的字段
    

sku名称  sku描述
    

分词、定义分词器

有可能用于过滤的字段
    

平台属性、三级分类、价格
    

要索引

其他需要显示的字段
    

skuId  图片路径
    

不索引
第一种方式:

根据以上制定出如下结构:

执行:

PUT gmall

{

  "mappings": {

    "SkuInfo":{

      "properties": {

        "id":{

          "type": "keyword"

          , "index": false

        },

        "price":{

          "type": "double"

        },

         "skuName":{

          "type": "text",

          "analyzer": "ik_max_word"

        },

        "skuDesc":{

          "type": "text",

          "analyzer": "ik_smart"

        },

        "catalog3Id":{

          "type": "keyword"

        },

        "skuDefaultImg":{

          "type": "keyword",

          "index": false

        },

        "skuAttrValueList":{

          "properties": {

            "valueId":{

              "type":"keyword"

            }

          }

        }

      }

    }

  }

}

查看:

GET /gmall

结果:

    {
      "gmall": {
        "aliases": {},
        "mappings": {
          "SkuLsInfo": {
            "properties": {
              "catalog3Id": {
                "type": "keyword"
              },
              "hotScore": {
                "type": "double"
              },
              "id": {
                "type": "keyword",
                "index": false
              },
              "price": {
                "type": "double"
              },
              "skuAttrValueList": {
                "properties": {
                  "attrId": {
                    "type": "text",
                    "fields": {
                      "keyword": {
                        "type": "keyword",
                        "ignore_above": 256
                      }
                    }
                  },
                  "id": {
                    "type": "text",
                    "fields": {
                      "keyword": {
                        "type": "keyword",
                        "ignore_above": 256
                      }
                    }
                  },
                  "skuId": {
                    "type": "text",
                    "fields": {
                      "keyword": {
                        "type": "keyword",
                        "ignore_above": 256
                      }
                    }
                  },
                  "valueId": {
                    "type": "keyword"
                  }
                }
              },
              "skuDefaultImg": {
                "type": "keyword",
                "index": false
              },
              "skuDesc": {
                "type": "text",
                "analyzer": "ik_smart"
              },
              "skuName": {
                "type": "text",
                "analyzer": "ik_max_word"
              }
            }
          }
        },
        "settings": {
          "index": {
            "creation_date": "1548161868908",
            "number_of_shards": "5",
            "number_of_replicas": "1",
            "uuid": "1ZSLxTDOScubSqhf2c18rQ",
            "version": {
              "created": "5060499"
            },
            "provided_name": "gmall"
          }
        }
      }
    }

执行测试类:

    @RunWith(SpringRunner.class)
    @SpringBootTest
    public class GmallListServiceApplicationTests {
     
        @Autowired
        JestClient jestClient;
     
        @Reference
        SkuService skuService;
        
        @Test
        public void test02() throws IOException {
            // 查询sku表中的所有数据skuInfo
            List<SkuInfo> skuInfos = skuService.SkuListByCatalog3Id("4");
     
            // skuInfo转化成skuLsInfo
            for (SkuInfo skuInfo : skuInfos) {
                SkuLsInfo skuLsInfo = new SkuLsInfo();
                BeanUtils.copyProperties(skuInfo,skuLsInfo);
     
                // 将skuLsInfo导入到es中
                Index index = new Index.Builder(skuLsInfo).index("gmall").type("SkuLsInfo").id(skuLsInfo.getId()).build();
                jestClient.execute(index);
     
            }
        }
     
    }

        @Override
        public List<SkuInfo> SkuListByCatalog3Id(String catalog3Id) {
     
            SkuInfo skuInfo = new SkuInfo();
            skuInfo.setCatalog3Id(catalog3Id);
            List<SkuInfo> skuInfos = skuInfoMapper.select(skuInfo);
     
            for (SkuInfo info : skuInfos) {
                SkuAttrValue skuAttrValue = new SkuAttrValue();
                skuAttrValue.setSkuId(info.getId());
                List<SkuAttrValue> skuAttrValues = skuAttrValueMapper.select(skuAttrValue);
                info.setSkuAttrValueList(skuAttrValues);
            }
            return skuInfos;
        }

再次查看

GET /gmall/SkuLsInfo/_search

数据库中的数据就出来了

    {
      "took": 5,
      "timed_out": false,
      "_shards": {
        "total": 5,
        "successful": 5,
        "skipped": 0,
        "failed": 0
      },
      "hits": {
        "total": 4,
        "max_score": 1,
        "hits": [
          {
            "_index": "gmall",
            "_type": "SkuLsInfo",
            "_id": "105",
            "_score": 1,
            "_source": {
              "id": "105",
              "price": 1000,
              "skuName": "360手机",
              "skuDesc": "360N5,360N6",
              "catalog3Id": "4",
              "skuDefaultImg": "http://192.168.0.100/group1/M00/00/00/wKgAZFxF1V6AeGnrAAB0eitaW6M234.jpg",
              "hotScore": 0,
              "skuAttrValueList": [
                {
                  "id": "770",
                  "attrId": "39",
                  "valueId": "90",
                  "skuId": "105"
                },
                {
                  "id": "771",
                  "attrId": "40",
                  "valueId": "90",
                  "skuId": "105"
                },
                {
                  "id": "772",
                  "attrId": "41",
                  "valueId": "90",
                  "skuId": "105"
                }
              ]
            }
          },
          {
            "_index": "gmall",
            "_type": "SkuLsInfo",
            "_id": "101",
            "_score": 1,
            "_source": {
              "id": "101",
              "price": 5000,
              "skuName": "三体的sku",
              "skuDesc": "三体的sku描述",
              "catalog3Id": "4",
              "skuDefaultImg": "http://192.168.0.100/group1/M00/00/00/wKgAZFw_4VOAD-e4AACOjs59iN8474.jpg",
              "hotScore": 0,
              "skuAttrValueList": [
                {
                  "id": "751",
                  "attrId": "39",
                  "valueId": "91",
                  "skuId": "101"
                },
                {
                  "id": "752",
                  "attrId": "40",
                  "valueId": "91",
                  "skuId": "101"
                }
              ]
            }
          },
          {
            "_index": "gmall",
            "_type": "SkuLsInfo",
            "_id": "106",
            "_score": 1,
            "_source": {
              "id": "106",
              "price": 2000,
              "skuName": "华为手机",
              "skuDesc": "华为荣耀",
              "catalog3Id": "4",
              "skuDefaultImg": "http://192.168.0.100/group1/M00/00/00/wKgAZFxF1WWAOA3hAADKNM6pL68983.jpg",
              "hotScore": 0,
              "skuAttrValueList": [
                {
                  "id": "773",
                  "attrId": "39",
                  "valueId": "90",
                  "skuId": "106"
                },
                {
                  "id": "774",
                  "attrId": "40",
                  "valueId": "90",
                  "skuId": "106"
                },
                {
                  "id": "775",
                  "attrId": "41",
                  "valueId": "90",
                  "skuId": "106"
                }
              ]
            }
          },
          {
            "_index": "gmall",
            "_type": "SkuLsInfo",
            "_id": "102",
            "_score": 1,
            "_source": {
              "id": "102",
              "price": 55555,
              "skuName": "三体第二部的sku名称",
              "skuDesc": "三体第耳部的sku描述",
              "catalog3Id": "4",
              "skuDefaultImg": "http://192.168.0.100/group1/M00/00/00/wKgAZFw_4VOAD-e4AACOjs59iN8474.jpg",
              "hotScore": 0,
              "skuAttrValueList": [
                {
                  "id": "753",
                  "attrId": "39",
                  "valueId": "91",
                  "skuId": "102"
                },
                {
                  "id": "754",
                  "attrId": "40",
                  "valueId": "91",
                  "skuId": "102"
                }
              ]
            }
          }
        ]
      }
    }

第二种方式:

之前已经将数据库中的数据保存到es中了,就可以用这种

      @Test
        public void contextLoads() throws IOException {
            // 查询
            String dsl = getMyDsl();
            System.out.print(dsl);
            Search build = new Search.Builder(dsl).addIndex("gmall0906").addType("SkuLsInfo").build();
            SearchResult execute = jestClient.execute(build);
            List<SearchResult.Hit<SkuLsInfo, Void>> hits = execute.getHits(SkuLsInfo.class);
            List<SkuLsInfo> skuLsInfos = new ArrayList<>();
            for (SearchResult.Hit<SkuLsInfo, Void> hit : hits) {
                SkuLsInfo source = hit.source;
                skuLsInfos.add(source);
            }
            System.out.println(skuLsInfos.size());
        }
     
        public String getMyDsl() {
            // 查询语句封装
            SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
            // 联合查询
            BoolQueryBuilder boolQueryBuilder = new BoolQueryBuilder();
    /*        TermQueryBuilder termQueryBuilder = new TermQueryBuilder(null, null);
            boolQueryBuilder.filter(termQueryBuilder);*/
            //分词查询:按skuName中有0725查询
            MatchQueryBuilder matchQueryBuilder = new MatchQueryBuilder("skuName", "华为");
            boolQueryBuilder.must(matchQueryBuilder);
            searchSourceBuilder.query(boolQueryBuilder);
            //高亮
            HighlightBuilder highlightBuilder = new HighlightBuilder();
            highlightBuilder.field("skuName");
            searchSourceBuilder.highlight(highlightBuilder);
            return searchSourceBuilder.toString();
        }