Elasticsearch Java API 的使用—多条件查询

最新推荐文章于 2024-08-19 08:36:18 发布

Soyoger

最新推荐文章于 2024-08-19 08:36:18 发布

阅读量2w

点赞数 4

分类专栏： ElasticSearch

本文链接：https://blog.csdn.net/qq_36330643/article/details/79640828

版权

ElasticSearch 专栏收录该内容

48 篇文章 2 订阅

订阅专栏


//多条件设置
MatchPhraseQueryBuilder mpq1 = QueryBuilders
                .matchPhraseQuery("pointid","W3.UNIT1.10LBG01CP301");
MatchPhraseQueryBuilder mpq2 = QueryBuilders
                .matchPhraseQuery("inputtime","2016-07-21 00:00:01");
QueryBuilder qb2 = QueryBuilders.boolQuery().must(mpq1).must(mpq2);

实现多条件查询

public class EsBool{
    public void BoolSearch(TransportClient client){
        //多条件设置
        MatchPhraseQueryBuilder mpq1 = QueryBuilders
            .matchPhraseQuery("pointid","W3.UNIT1.10LBG01CP301");
        MatchPhraseQueryBuilder mpq2 = QueryBuilders
            .matchPhraseQuery("inputtime","2016-07-21 00:00:01");
        QueryBuilder qb2 = QueryBuilders.boolQuery()   
                                .must(mpq1)   
                                .must(mpq2);
        SearchSourceBuilder sourceBuilder = new SearchSourceBuilder();
        sourceBuilder.query(qb2);
        //System.out.println(sourceBuilder.toString());

        //查询建立
        SearchRequestBuilder responsebuilder = client
                .prepareSearch("pointdata").setTypes("pointdata");
        SearchResponse myresponse=responsebuilder
                    .setQuery(qb2)
                    .setFrom(0).setSize(50)
                    .addSort("inputtime", SortOrder.ASC)
                    //.addSort("inputtime", SortOrder.DESC)
                    .setExplain(true).execute().actionGet();
            SearchHits hits = myresponse.getHits();
            for(int i = 0; i < hits.getHits().length; i++) {
                System.out.println(hits.getHits()[i].getSourceAsString());

            }
    }
}

@Test 
    public void testSearch() 
    { 
        String index="index_log_daily";
        String type="uq_log";
        String uquestion = "139";
        String province = "江苏";
        SearchResponse searchResponse = client.prepareSearch(index) 
                .setTypes(type) 
                .setQuery(QueryBuilders.matchAllQuery()) //查询所有
                .setQuery(QueryBuilders.boolQuery()
                .must(QueryBuilders.matchQuery("uquestion", uquestion))//查询uquestion为139的
                .must(QueryBuilders.matchQuery("province", province)))//查询省份为江苏的
                //.setQuery(QueryBuilders.matchQuery("uquestion", "12599").operator(Operator.AND)) //根据tom分词查询name,默认or
                //.setQuery(QueryBuilders.matchQuery("province", "江苏").operator(Operator.AND)) //根据tom分词查询name,默认or
                //.setQuery(QueryBuilders.multiMatchQuery("tom", "name", "age")) //指定查询的字段 
                //.setQuery(QueryBuilders.queryString("name:to* AND age:[0 TO 19]")) //根据条件查询,支持通配符大于等于0小于等于19 
                //.setQuery(QueryBuilders.termQuery("name", "tom"))//查询时不分词 
                .setSearchType(SearchType.QUERY_THEN_FETCH) 
                .setFrom(0).setSize(10)//分页 
                //.addSort("age", SortOrder.DESC)//排序 
                .get(); 
           
        SearchHits hits = searchResponse.getHits(); 
        long total = hits.getTotalHits(); 
        System.out.println(total); 
        SearchHit[] searchHits = hits.hits(); 
        for(SearchHit s : searchHits) 
        { 
            System.out.println(s.getSourceAsString());
            String []logindex=s.getSourceAsString().split(",");
             
        } 
    }

提示：根据留言区一位同学的提示，因为这篇博客写的时候比较早，属于ES早期版本，后来版本不推荐使用TransportClient client，大家考虑替换成RestHighLevelClient和SearchSourceBuilder来进行新版本的迭代。