微服务Day6-DSL语法、RestClient查询、案例

Jimmy Ding

已于 2024-06-02 21:40:38 修改

阅读量616

点赞数 6

分类专栏： Java 文章标签：微服务 linux 服务器 DSL elasticsearch

于 2024-02-24 23:04:57 首次发布

本文链接：https://blog.csdn.net/qq_48642405/article/details/136241379

版权

Java 专栏收录该内容

40 篇文章 1 订阅

订阅专栏

本文介绍了如何在旅游应用中使用DSL查询文档和RestClient进行数据检索，包括基本的matchAllQuery和布尔查询示例，以及如何处理Controller和Service层的参数，实现复杂搜索条件和排序功能。

摘要由CSDN通过智能技术生成

DSL查询文档

在这里插入图片描述

RestClient查询文档

快速入门

在这里插入图片描述

    @Test
    void testMatchAll() throws IOException {
        //1.准备Request
        SearchRequest request = new SearchRequest("hotel");
        //2.准备DSL
        request.source().query(QueryBuilders.matchAllQuery());
        //3.发送请求
        SearchResponse search = client.search(request, RequestOptions.DEFAULT);
        System.out.println(search);
    }

在这里插入图片描述

    @Test
    void testBool() throws IOException {
        //1.准备Request
        SearchRequest request = new SearchRequest("hotel");
        //2.准备DSL
        //2.1准备BooleanQuery
        BoolQueryBuilder boolQuery = QueryBuilders.boolQuery();
        //2.2添加term
//        boolQuery.must(QueryBuilders.termQuery("city", "杭州"));
        //2.3添加range
        boolQuery.filter(QueryBuilders.rangeQuery("price").lte(250));
        request.source().query(boolQuery);
        //3.发送请求
        SearchResponse search = client.search(request, RequestOptions.DEFAULT);
        //4.解析响应
        handleResponse(search);
    }

在这里插入图片描述

旅游案例

在这里插入图片描述

Controller层

@RestController
@RequestMapping("/hotel")
public class HotelController {
    @Autowired
    private IHotelService hotelService;

    @PostMapping("/list")
    public PageResult search(@RequestBody RequestParams params){
        return hotelService.search(params);
    }
}

Service实现类

@Service
public class HotelService extends ServiceImpl<HotelMapper, Hotel> implements IHotelService {
    @Autowired
    private RestHighLevelClient client;

    @Override
    public PageResult search(RequestParams params) {
        try {
        //1.准备Request
        SearchRequest request = new SearchRequest("hotel");
        //2.准备DSL
        //2.1query
        String key = params.getKey();
        if (key == null||"".equals(key)){
            request.source().query(QueryBuilders.matchAllQuery());
        }else{
            request.source().query(QueryBuilders.matchQuery("all",key));
        }
        //2.2分页
        int page = params.getPage();
        int size = params.getSize();
        request.source().from(page-1).size(size);
        //3.发送请求，得到响应
        SearchResponse response = client.search(request, RequestOptions.DEFAULT);
        //4.解析响应
        return handleResponse(response);
        } catch (IOException e) {
            throw new RuntimeException(e);
        }

    }

    private PageResult handleResponse(SearchResponse response) {
        //解析响应
        SearchHits searchHits = response.getHits();
        //获取总条数
        long total = searchHits.getTotalHits().value;
        System.out.println("共有:"+total);
        //文档数组
        SearchHit[] hits = searchHits.getHits();
        //遍历
        List<HotelDoc> hote  ls = new ArrayList<>();
        for (SearchHit hit : hits) {
            //获取文档source
            String json = hit.getSourceAsString();
            //反序列化
            HotelDoc hotelDoc = JSON.parseObject(json, HotelDoc.class);
            //获取高亮结果
            Map<String, HighlightField> highlightFields = hit.getHighlightFields();
            if (!CollectionUtils.isEmpty(highlightFields)){
                //根据字段名称获取高亮结果
                HighlightField highlightField = highlightFields.get("name");
                if (highlightField != null){
                    //获取高亮值
                    String name = highlightField.getFragments()[0].string();
                    //覆盖非高亮结果
                    hotelDoc.setName(name);
                }
            }
            hotels.add(hotelDoc);
        }

        return new PageResult(total,hotels);
    }
}

在这里插入图片描述

在这里插入图片描述
修改Service实现类

@Service
public class HotelService extends ServiceImpl<HotelMapper, Hotel> implements IHotelService {
    @Autowired
    private RestHighLevelClient client;

    @Override
    public PageResult search(RequestParams params) {
        try {
        //1.准备Request
        SearchRequest request = new SearchRequest("hotel");
        //2.准备DSL
        //2.1query
        //构建BooleanQuery
        BoolQueryBuilder boolQuery = buildBasicQuery(params, request);
        request.source().query(boolQuery);
        //2.2分页
        int page = params.getPage();
        int size = params.getSize();
        request.source().from(page-1).size(size);
        //3.发送请求，得到响应
        SearchResponse response = client.search(request, RequestOptions.DEFAULT);
        //4.解析响应
        return handleResponse(response);
        } catch (IOException e) {
            throw new RuntimeException(e);
        }

    }

    private BoolQueryBuilder buildBasicQuery(RequestParams params, SearchRequest request) {
        BoolQueryBuilder boolQuery = QueryBuilders.boolQuery();
        //全文检索  must关键字搜索
        String key = params.getKey();
        if (key == null||"".equals(key)){
            boolQuery.must(QueryBuilders.matchAllQuery());
        }else{
            boolQuery.must(QueryBuilders.matchQuery("all",key));
        }
        // 城市条件
        if (params.getCity() != null && !params.getCity().equals("")){
            boolQuery.filter(QueryBuilders.termQuery("city", params.getCity()));
        }
        request.source().query(boolQuery);
        // 品牌条件
        if (params.getBrand() != null && !params.getBrand().equals("")){
            boolQuery.filter(QueryBuilders.termQuery("brand", params.getBrand()));
        }
        // 星级条件
        if (params.getStarName() != null && !params.getStarName().equals("")){
            boolQuery.filter(QueryBuilders.termQuery("starName", params.getStarName()));
        }
        //价格
        if (params.getMinPrice() != null && !params.getMinPrice().equals("")){
            boolQuery.filter(QueryBuilders
                    .rangeQuery("price").gte(params.getMinPrice()).lte(params.getMaxPrice()));
        }
        return boolQuery;
    }

    private PageResult handleResponse(SearchResponse response) {
        //解析响应
        SearchHits searchHits = response.getHits();
        //获取总条数
        long total = searchHits.getTotalHits().value;
        System.out.println("共有:"+total);
        //文档数组
        SearchHit[] hits = searchHits.getHits();
        //遍历
        List<HotelDoc> hotels = new ArrayList<>();
        for (SearchHit hit : hits) {
            //获取文档source
            String json = hit.getSourceAsString();
            //反序列化
            HotelDoc hotelDoc = JSON.parseObject(json, HotelDoc.class);
            //获取高亮结果
            Map<String, HighlightField> highlightFields = hit.getHighlightFields();
            if (!CollectionUtils.isEmpty(highlightFields)){
                //根据字段名称获取高亮结果
                HighlightField highlightField = highlightFields.get("name");
                if (highlightField != null){
                    //获取高亮值
                    String name = highlightField.getFragments()[0].string();
                    //覆盖非高亮结果
                    hotelDoc.setName(name);
                }
            }
            hotels.add(hotelDoc);
        }

        return new PageResult(total,hotels);
    }
}

在这里插入图片描述

在这里插入图片描述
修改Service中代码

        //2.3排序
        String location = params.getLocation();
        if (location != null && !location.equals("")){
            request.source().sort(SortBuilders
                    .geoDistanceSort("location", new GeoPoint(location))
                    .order(SortOrder.ASC)
                    .unit(DistanceUnit.KILOMETERS)
                    );
        }

在解析响应中添加

            //获取排序值
            Object[] sortValues = hit.getSortValues();
            if (sortValues.length>0){
                Object sortValue = sortValues[0];
                hotelDoc.setDistance(sortValue);
            }

在这里插入图片描述

在BooleanSearch中添代码

        //2.算分控制
        FunctionScoreQueryBuilder functionScoreQuery = QueryBuilders.functionScoreQuery(boolQuery,
                                    // function score的数组
                                    new FunctionScoreQueryBuilder.FilterFunctionBuilder[]{
                                            //其中一个function score元素
                                            new FunctionScoreQueryBuilder.FilterFunctionBuilder(
                                                    // 过滤条件
                                                    QueryBuilders.termQuery("isAD", true),
                                                    //算分函数
                                                    ScoreFunctionBuilders.weightFactorFunction(10)
                                            )
                                    });
        request.source().query(functionScoreQuery);