java实现mongo查询使用总结

原创已于 2023-03-03 16:17:43 修改 · 1.4k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java #mongodb

于 2023-03-02 15:02:52 首次发布

java 专栏收录该内容

9 篇文章

订阅专栏

该文展示了在MongoDB中进行不同类型的查询操作，包括简单的查询、聚合查询、复杂的聚合查询、聚合排序并限制条数的查询，以及返回特定对象的聚合查询。这些方法使用了Criteria表达式和Aggregation框架，通过mongoTemplate执行。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.简单查询

    public <T>List<T> findQuery(Criteria criteria, Class<T> c ,String tableName) {
        Query query = Query.query(criteria);
        return mongoTemplate.find(query, c, tableName);
    }

2.聚合查询

  public List<Map> aggregateQuery(Criteria criteria, String groupField, String tableName) {
        AggregationOptions aggregationOptions = AggregationOptions.builder().allowDiskUse(true).build();
        Aggregation aggregation = Aggregation.newAggregation(
                Aggregation.match(criteria),
                Aggregation.group(groupField).count().as("count")
        ).withOptions(aggregationOptions);
        return mongoTemplate.aggregate(aggregation, tableName, Map.class).getMappedResults();
    }

3.复杂聚合查询


  public List<Map> complexAggregateQuery(Criteria criteria, String primaryField, String additionalField, String tableName) {
        AggregationOptions aggregationOptions = AggregationOptions.builder().allowDiskUse(true).build();
        Aggregation aggregation = Aggregation.newAggregation(
                Aggregation.match(criteria),
                Aggregation.group(primaryField, additionalField),
                Aggregation.group(primaryField).count().as("count")
        ).withOptions(aggregationOptions);
        return mongoTemplate.aggregate(aggregation, tableName, Map.class).getMappedResults();
    }

4.聚合排序limit条数

    public List<Map> aggregateSortQuery(Criteria criteria, String groupField, String tableName, long limit) {
        AggregationOptions aggregationOptions = AggregationOptions.builder().allowDiskUse(true).build();
        Aggregation aggregation = Aggregation.newAggregation(
                Aggregation.match(criteria),
                Aggregation.group(groupField).count().as("count"),
                Aggregation.sort(new Sort(new Sort.Order(Sort.Direction.DESC,"count"))),
                Aggregation.limit(limit)
        ).withOptions(aggregationOptions);
        return mongoTemplate.aggregate(aggregation, tableName, Map.class).getMappedResults();
    }

4.聚合排序返回对象

   public<T>List<T> aggregateGroupQueryT(Criteria criteria, String groupField, String tableName,Class<T> c) {
        AggregationOptions aggregationOptions = AggregationOptions.builder().allowDiskUse(true).build();
        Aggregation aggregation = Aggregation.newAggregation(
                Aggregation.match(criteria),
                Aggregation.group(groupField)
        ).withOptions(aggregationOptions);
        return mongoTemplate.aggregate(aggregation, tableName, c).getMappedResults();
    }

5.聚合排序加limit条数返回对象

    public<T>List<T> aggregateSortQueryT(Criteria criteria, String groupField, String tableName, long limit, Class<T> c) {
        AggregationOptions aggregationOptions = AggregationOptions.builder().allowDiskUse(true).build();
        Aggregation aggregation = Aggregation.newAggregation(
                Aggregation.match(criteria),
                Aggregation.group(groupField).count().as("count"),
                Aggregation.sort(new Sort(new Sort.Order(Sort.Direction.DESC,"count"))),
                Aggregation.limit(limit)
        ).withOptions(aggregationOptions);
        return mongoTemplate.aggregate(aggregation, tableName, c).getMappedResults();
    }