hibernate search -- 多条件查询

最新推荐文章于 2018-01-19 10:09:52 发布

开心的D哥

最新推荐文章于 2018-01-19 10:09:52 发布

阅读量3.5k

点赞数

分类专栏： Java Java Web 文章标签： hibernate 搜索组合查询

本文链接：https://blog.csdn.net/cloud_ll/article/details/48791787

版权

Java 同时被 2 个专栏收录

106 篇文章 0 订阅

订阅专栏

Java Web

52 篇文章 0 订阅

订阅专栏

hibernate search可以通过多组合条件来实现多条件查询，这里简单介绍一下多条件查询的一个实践。
如果只是单个条件查询，那么这个查询就可以很简单

luceneQuery = queryBuilder.keyword().onFields("title", "content").matching(query.getKeyword()).createQuery()

如果是多条件并查询，那么就需要使用到Must Join，如果是多条件或查询，就需要使用should Join，这里举个Must Join的例子

//must true
MustJunction term = queryBuilder.bool().must(queryBuilder.keyword()
                   .onFields("title", "content")     .matching(query.getKeyword()).createQuery());
//must false
 term.must(queryBuilder.keyword()
                            .onField("status")                         .matching(query.getExcludeStatus()).createQuery()).not();

完整例子：

private FullTextQuery findByKeywordQuery(TopicQuery query) {
        FullTextSession fullTextSession = Search
                .getFullTextSession(getSession());


        QueryBuilder queryBuilder = fullTextSession.getSearchFactory()
                .buildQueryBuilder().forEntity(Topic.class).get();
        org.apache.lucene.search.Query luceneQuery = null;
        if (null == query.getStatus() && null == query.getUsername() && null == query.getExcludeStatus()) {
            luceneQuery = queryBuilder.keyword()// .wildcard()
                    .onFields("title", "content").matching(query.getKeyword())
                    // .matching("*" + query.getKeyword() + "*")
                    .createQuery();
            if(LOG.isDebugEnabled()){
                LOG.debug("create clean keyword search query: " + luceneQuery.toString());
            }
        } else {
           MustJunction term = queryBuilder.bool().must(queryBuilder.keyword()
                   .onFields("title", "content")     .matching(query.getKeyword()).createQuery());
           if(null != query.getStatus()){
               term.must(queryBuilder.keyword()
                            // .wildcard()
                            .onField("status")
                            .matching(query.getStatus()).createQuery());
           }
           if(null != query.getExcludeStatus()){
               term.must(queryBuilder.keyword()
                            .onField("status")
                            .matching(query.getExcludeStatus()).createQuery()).not();
           }
           if(null != query.getUsername()){
               term.must(queryBuilder.keyword()
                            // .wildcard()
                            .onField("owner.username")
                             .ignoreFieldBridge()
                            .matching(query.getUsername()).createQuery());
           }
           luceneQuery =term.createQuery();
           if(LOG.isDebugEnabled()){
               LOG.debug("create complicated keyword search query: " + luceneQuery.toString());
           }
        }
        // BooleanQuery
        FullTextQuery hibernateQuery = fullTextSession.createFullTextQuery(
                luceneQuery, Topic.class);
        return hibernateQuery;
    }