【ES】JavaAPI学习-06 条件查询 分页查询 结果排序 字段过滤

500 阅读1分钟

在这里插入图片描述

前言

本节主要实现条件查询,分页查询,查询结果排序,字段过滤。

实现

条件查询 ESTest_Doc_Cond_Query.java

package com.zwy.es;

import org.apache.http.HttpHost;
import org.elasticsearch.action.search.SearchRequest;
import org.elasticsearch.action.search.SearchResponse;
import org.elasticsearch.client.RequestOptions;
import org.elasticsearch.client.RestClient;
import org.elasticsearch.client.RestHighLevelClient;
import org.elasticsearch.index.query.QueryBuilders;
import org.elasticsearch.search.SearchHit;
import org.elasticsearch.search.SearchHits;
import org.elasticsearch.search.builder.SearchSourceBuilder;

import java.io.IOException;

public class ESTest_Doc_Cond_Query {
    public static void main(String[] args) throws IOException {

        //
        RestHighLevelClient esClient = new RestHighLevelClient(
                RestClient.builder(new HttpHost("localhost", 9200, "http"))
        );

        // 条件查询数据
        SearchRequest request = new SearchRequest();
        request.indices("users");

        request.source(new SearchSourceBuilder().query(QueryBuilders.termQuery("age", 30)));  // 条件

        SearchResponse response = esClient.search(request, RequestOptions.DEFAULT);

        SearchHits hits = response.getHits();

        System.out.println(hits.getTotalHits());  // 打印
        System.out.println(response.getTook());  // 打印

        for (SearchHit hit : hits) {
            System.out.println(hit.getSourceAsString());
        }

        // 关闭ES客户端
        esClient.close();

    }
}

分页查询 ESTest_Doc_Cond_Query_Page.java

package com.zwy.es;

import org.apache.http.HttpHost;
import org.elasticsearch.action.search.SearchRequest;
import org.elasticsearch.action.search.SearchResponse;
import org.elasticsearch.client.RequestOptions;
import org.elasticsearch.client.RestClient;
import org.elasticsearch.client.RestHighLevelClient;
import org.elasticsearch.index.query.QueryBuilders;
import org.elasticsearch.search.SearchHit;
import org.elasticsearch.search.SearchHits;
import org.elasticsearch.search.builder.SearchSourceBuilder;

import java.io.IOException;

public class ESTest_Doc_Cond_Query_Page {
    public static void main(String[] args) throws IOException {

        //
        RestHighLevelClient esClient = new RestHighLevelClient(
                RestClient.builder(new HttpHost("localhost", 9200, "http"))
        );

        // 分页查询数据
        SearchRequest request = new SearchRequest();
        request.indices("users");

        SearchSourceBuilder builer = new SearchSourceBuilder().query(QueryBuilders.matchAllQuery());
        // (当前页码-1)*每页显示数据条数
        builer.from(0);  // 起始页
        builer.size(2);  // 每页有多少条
        request.source(builer);

        SearchResponse response = esClient.search(request, RequestOptions.DEFAULT);

        SearchHits hits = response.getHits();

        System.out.println(hits.getTotalHits());  // 打印
        System.out.println(response.getTook());  // 打印

        for (SearchHit hit : hits) {
            System.out.println(hit.getSourceAsString());
        }

        // 关闭ES客户端
        esClient.close();

    }
}

编写排序查询 ESTest_Doc_Cond_Query_Sort.java

package com.zwy.es;

import org.apache.http.HttpHost;
import org.elasticsearch.action.search.SearchRequest;
import org.elasticsearch.action.search.SearchResponse;
import org.elasticsearch.client.RequestOptions;
import org.elasticsearch.client.RestClient;
import org.elasticsearch.client.RestHighLevelClient;
import org.elasticsearch.index.query.QueryBuilders;
import org.elasticsearch.search.SearchHit;
import org.elasticsearch.search.SearchHits;
import org.elasticsearch.search.builder.SearchSourceBuilder;
import org.elasticsearch.search.sort.SortOrder;

import java.io.IOException;

public class ESTest_Doc_Cond_Query_Sort {
    public static void main(String[] args) throws IOException {

        //
        RestHighLevelClient esClient = new RestHighLevelClient(
                RestClient.builder(new HttpHost("localhost", 9200, "http"))
        );

        // 分页查询数据
        SearchRequest request = new SearchRequest();
        request.indices("users");

        SearchSourceBuilder builer = new SearchSourceBuilder().query(QueryBuilders.matchAllQuery());
        // 降序
        builer.sort("age", SortOrder.DESC);  // 起始页

        request.source(builer);
        SearchResponse response = esClient.search(request, RequestOptions.DEFAULT);

        SearchHits hits = response.getHits();

        System.out.println(hits.getTotalHits());  // 打印
        System.out.println(response.getTook());  // 打印

        for (SearchHit hit : hits) {
            System.out.println(hit.getSourceAsString());
        }

        // 关闭ES客户端
        esClient.close();

    }
}

编写字段过滤 ESTest_Doc_Cond_Query_Filter.java

package com.zwy.es;

import org.apache.http.HttpHost;
import org.elasticsearch.action.search.SearchRequest;
import org.elasticsearch.action.search.SearchResponse;
import org.elasticsearch.client.RequestOptions;
import org.elasticsearch.client.RestClient;
import org.elasticsearch.client.RestHighLevelClient;
import org.elasticsearch.index.query.QueryBuilders;
import org.elasticsearch.search.SearchHit;
import org.elasticsearch.search.SearchHits;
import org.elasticsearch.search.builder.SearchSourceBuilder;

import java.io.IOException;

public class ESTest_Doc_Cond_Query_Filter {
    public static void main(String[] args) throws IOException {

        //
        RestHighLevelClient esClient = new RestHighLevelClient(
                RestClient.builder(new HttpHost("localhost", 9200, "http"))
        );

        // 过滤查询数据
        SearchRequest request = new SearchRequest();
        request.indices("users");

        SearchSourceBuilder builer = new SearchSourceBuilder().query(QueryBuilders.matchAllQuery());

        // 过滤字段
        String[] excludes = {};
        String[] includes = {"name"};
        builer.fetchSource(includes, excludes);

        request.source(builer);
        SearchResponse response = esClient.search(request, RequestOptions.DEFAULT);

        SearchHits hits = response.getHits();

        System.out.println(hits.getTotalHits());  // 打印
        System.out.println(response.getTook());  // 打印

        for (SearchHit hit : hits) {
            System.out.println(hit.getSourceAsString());
        }

        // 关闭ES客户端
        esClient.close();

    }
}

文件结构

在这里插入图片描述

运行

运行ESTest_Doc_Cond_Query.java 在这里插入图片描述

运行ESTest_Doc_Cond_Query_Page.java

在这里插入图片描述

运行ESTest_Doc_Cond_Query_Sort.java 在这里插入图片描述 运行ESTest_Doc_Cond_Query_Filter.java 在这里插入图片描述