使用spring data api查询分组中的mongodb最大值

最新推荐文章于 2024-06-18 12:02:31 发布

weixin_33814685

最新推荐文章于 2024-06-18 12:02:31 发布

阅读量2k

点赞数

文章标签： java 数据库

原文链接：https://my.oschina.net/hfq/blog/1817816

版权

为什么80%的码农都做不了架构师？>>>

1，实现一个

GroupOperation groupOperation = Aggregation.group("stockno").max("volume").as("volume");
       Aggregation agg = Aggregation.newAggregation(StockQuotation.class,groupOperation);
       AggregationResults<java.util.Map> results = mongoTemplate.aggregate(agg,StockQuotation.class,java.util.Map.class);
       java.util.Map<String, Integer> classMaxScoreMap = new HashMap<String, Integer>();
       if(results.getMappedResults() != null && results.getMappedResults().size() != 0){
for(java.util.Map map:results.getMappedResults()){
classMaxScoreMap.put(map.get("_id").toString(), Integer.valueOf(map.get("volume").toString()));
System.out.println("==============" + map.get("_id").toString() + " | " + Integer.valueOf(map.get("volume").toString()));
}
       }

打印结果：

==============600004 | 6465485
==============600000 | 74449284

因为Aggregation.group()函数，参数不能为空，所以必须要分组，如果查询整个表里面某个列的最大值，这办法不行

2，写个日期的

//stockno,tradingDay是实体类中的字段，maxTradingDay是别名
       GroupOperation groupOperation = Aggregation.group("stockno").max("tradingDay").as("maxTradingDay");
       Aggregation agg = Aggregation.newAggregation(StockQuotation.class,groupOperation);
       AggregationResults<java.util.Map> results = mongoTemplate.aggregate(agg,StockQuotation.class,java.util.Map.class);
       java.util.Map<String, Object> classMaxScoreMap = new HashMap<String, Object>();
       if(results.getMappedResults() != null && results.getMappedResults().size() != 0){
for(java.util.Map map:results.getMappedResults()){
classMaxScoreMap.put(map.get("_id").toString(), map.get("maxTradingDay").toString());
System.out.println("==============" + map.get("_id").toString() + " | " + map.get("maxTradingDay").toString());
}
       }

打印结果：

==============600004 | Mon May 12 00:00:00 CST 2008
==============600000 | Mon May 12 00:00:00 CST 2008

转载于:https://my.oschina.net/hfq/blog/1817816