室内装修设计软件哪个好用_京东网上商城购物_推广产品最好的方式_seo站长工具论坛

时间:2025/7/18 15:47:53来源：https://blog.csdn.net/kong7906928/article/details/144936272 浏览次数:0次

一、根据关键字查询商品

(1) shangcheng_service_search项目创建SearchService接口

public interface SearchService {
/*** 全文检索* @param paramMap  查询参数* @return*/public Map search(Map<String, String> paramMap) throws Exception;
}

(2) shangcheng_service_search项目创建SearchService接口实现类SearchServiceImpl

@Service
public class SearchServiceImpl implements SearchService {
@Autowiredprivate ElasticsearchTemplate esTemplate;


//设置每页查询条数据public final static Integer PAGE_SIZE = 20;
@Overridepublic Map search(Map<String, String> searchMap) throws Exception {Map<String, Object> resultMap = new HashMap<>();
//有条件才查询Esif (null != searchMap) {//组合条件对象BoolQueryBuilder boolQuery = QueryBuilders.boolQuery();//0:关键词if (!StringUtils.isEmpty(searchMap.get("keywords"))) {boolQuery.must(QueryBuilders.matchQuery("name", searchMap.get("keywords")).operator(Operator.AND));}
//4. 原生搜索实现类NativeSearchQueryBuilder nativeSearchQueryBuilder = new NativeSearchQueryBuilder();nativeSearchQueryBuilder.withQuery(boolQuery);//10: 执行查询, 返回结果对象AggregatedPage<SkuInfo> aggregatedPage = esTemplate.queryForPage(nativeSearchQueryBuilder.build(), SkuInfo.class, new SearchResultMapper() {@Overridepublic <T> AggregatedPage<T> mapResults(SearchResponse searchResponse, Class<T> aClass, Pageable pageable) {
List<T> list = new ArrayList<>();
SearchHits hits = searchResponse.getHits();if (null != hits) {for (SearchHit hit : hits) {SkuInfo skuInfo = JSON.parseObject(hit.getSourceAsString(), SkuInfo.class);
list.add((T) skuInfo);}}return new AggregatedPageImpl<T>(list, pageable, hits.getTotalHits(), searchResponse.getAggregations());}});
//11. 总条数resultMap.put("total", aggregatedPage.getTotalElements());//12. 总页数resultMap.put("totalPages", aggregatedPage.getTotalPages());//13. 查询结果集合resultMap.put("rows", aggregatedPage.getContent());
return resultMap;}return null;}

}

(3) shangcheng_service_search项目创建SearchController

@RestController
@RequestMapping("/sku_search")
public class SearchController {
@Autowiredprivate EsManagerService esManagerService;
@Autowiredprivate SearchService searchService;//对搜索入参带有特殊符号进行处理public void handlerSearchMap(Map<String,String> searchMap){
if(null != searchMap){Set<Map.Entry<String, String>> entries = searchMap.entrySet();for (Map.Entry<String, String> entry : entries) {if(entry.getKey().startsWith("spec_")){searchMap.put(entry.getKey(),entry.getValue().replace("+","%2B"));}}}
}
/*** 全文检索* @return*/@GetMappingpublic Map search(@RequestParam Map<String, String> paramMap) throws Exception {//特殊符号处理handlerSearchMap(searchMap);Map resultMap = searchService.search(paramMap);return resultMap;}
}

(4) 测试

使用postmain访问 http://localhost:9009/sku_search?keywords=手机

二、品牌筛选

用户有可能会根据分类搜索、品牌搜索，还有可能根据规格搜索，以及价格搜索和排序操作。根据分类和品牌搜索的时候，可以直接根据指定域搜索，而规格搜索的域数据是不确定的，价格是一个区间搜索，所以我们可以先实现分类、品牌搜素，再实现规格搜索，然后实现价格区间搜索。

2.1 需求分析

页面每次向后台传入对应的分类和品牌，后台据分类和品牌进行条件过滤。

2.2 代码实现

修改搜索微服务com.shangcheng.service.SearchServiceImpl的搜索方法，添加品牌过滤，代码如下：

代码如下：

@Override
public Map search(Map<String, String> searchMap) throws Exception {Map<String, Object> resultMap = new HashMap<>();
//有条件才查询Esif (null != searchMap) {//组合条件对象BoolQueryBuilder boolQuery = QueryBuilders.boolQuery();//0:关键词if (StringUtils.isNotEmpty(searchMap.get("keywords"))) {boolQuery.must(QueryBuilders.matchQuery("name", searchMap.get("keywords")).operator(Operator.AND));}//1:条件 品牌if (StringUtils.isNotEmpty(searchMap.get("brand"))) {boolQuery.filter(QueryBuilders.termQuery("brandName", searchMap.get("brand")));}//4. 原生搜索实现类NativeSearchQueryBuilder nativeSearchQueryBuilder = new NativeSearchQueryBuilder();nativeSearchQueryBuilder.withQuery(boolQuery);
//6. 品牌聚合(分组)查询String skuBrand = "skuBrand";
nativeSearchQueryBuilder.addAggregation(AggregationBuilders.terms(skuBrand).field("brandName"));
//10: 执行查询, 返回结果对象AggregatedPage<SkuInfo> aggregatedPage = esTemplate.queryForPage(nativeSearchQueryBuilder.build(), SkuInfo.class, new SearchResultMapper() {@Overridepublic <T> AggregatedPage<T> mapResults(SearchResponse searchResponse, Class<T> aClass, Pageable pageable) {
List<T> list = new ArrayList<>();
SearchHits hits = searchResponse.getHits();if (null != hits) {for (SearchHit hit : hits) {SkuInfo skuInfo = JSON.parseObject(hit.getSourceAsString(), SkuInfo.class);
list.add((T) skuInfo);}}return new AggregatedPageImpl<T>(list, pageable, hits.getTotalHits(), searchResponse.getAggregations());}});
//11. 总条数resultMap.put("total", aggregatedPage.getTotalElements());//12. 总页数resultMap.put("totalPages", aggregatedPage.getTotalPages());//13. 查询结果集合resultMap.put("rows", aggregatedPage.getContent());
//14. 获取品牌聚合结果StringTerms brandTerms = (StringTerms) aggregatedPage.getAggregation(skuBrand);List<String> brandList = brandTerms.getBuckets().stream().map(bucket -> bucket.getKeyAsString()).collect(Collectors.toList());resultMap.put("brandList", brandList);
return resultMap;}return null;
}