基于ElasticSearch+Vue实现简易搜索

基于ElasticSearch+Vue实现简易搜索

一、模拟数据

二、python导入脚本

# coding=gbk
import pandas as pd
from elasticsearch import Elasticsearch
from elasticsearch.helpers import streaming_bulk

# 连接到Elasticsearch
es = Elasticsearch([{'host': 'localhost', 'port': 9200}])

# 检查是否成功连接
if es.ping():
    print("Connected to Elasticsearch")
else:
    print("Failed to connect to Elasticsearch")

# 读取Excel文件
data = pd.read_excel('demoData.xls')

# 将DataFrame转换为字典格式
documents = data.to_dict(orient='records')

# 逐个文档导入数据到Elasticsearch
success, failed = 0, 0
total_documents = len(documents)
for doc in documents:
    index_action = {
        '_index': 'ecommerce',  # 修改为你的索引名称
        '_id': doc['产品名称'],  # 使用产品名称作为文档ID
        '_source': doc
    }
    try:
        result = next(streaming_bulk(es, [index_action], index=index_action['_index']))
        success += 1
    except Exception as e:
        print(f"Failed to index document {index_action['_id']}: {e}")
        failed += 1

print(f'Successfully indexed {success} documents, failed to index {failed} documents.')
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37

三、vue代码

  
  
  
  



  

    
基于ElasticSearch+Vue实现简易搜索
    
    

    

    

    
    

      
        

          
        
        

          产品名称: {{ result.productName }}
        
        

          描述: {{ result.productDescription }}
        
        

          价格: {{ result.productPrice }}
        
        

          库存数量: {{ result.productStock }}
        
        

          品牌名称: {{ result.productBrand }}
        
      
    
  









1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132

四、效果图