前言
本节主要实现条件查询,分页查询,查询结果排序,字段过滤。
实现
条件查询 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