springdata.mongodb根据某个字段统计每天数量

最新推荐文章于 2024-04-12 10:29:35 发布

帅气的喵喵

最新推荐文章于 2024-04-12 10:29:35 发布

阅读量621

点赞数

文章标签： mongodb 数据库 database

本文链接：https://blog.youkuaiyun.com/m0_71149992/article/details/125253950

版权

该博客介绍了如何使用Spring与MongoDB进行集成，通过Aggregation操作进行日期统计。示例代码展示了如何根据用户ID获取指定日期的日志数量，并进行排序和分组，最后返回统计结果。

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

public List countLogByUserIdAndDate(Long userId) {
		Criteria criteria = Criteria.where("userId").is(userId);
		Aggregation agg = Aggregation.newAggregation(
				Aggregation.match(criteria),
				Aggregation.project("createAt").and(DateOperators.DateToString.dateOf("createAt").toString("%Y-%m-%d")).as("times"),
				Aggregation.group("times").count().as("count"),
				Aggregation.project("times", "count").and("date").previousOperation(),
				Aggregation.sort(Sort.Direction.DESC, "date"));
		AggregationResults<Map> queryAccess = mongoTemplate.aggregate(agg, "VehicleOperate", Map.class);
		org.bson.Document rawResults = queryAccess.getRawResults();
		List<Map<String, Object>> results = (List<Map<String, Object>>) rawResults.get("results");
		return results;
	}

参考博客

https://blog.youkuaiyun.com/xiangwangxiangwang/article/details/84104092?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522165508304316782390567553%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fall.%2522%257D&request_id=165508304316782390567553&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2_allfirst_rank_ecpm_v1~rank_v31_ecpm-1-84104092-null-null.142^v13control,157^v14control&utm_term=+spring+date++mongodb+%E6%8C%89%E7%85%A7%E6%97%A5%E6%9C%9F%E7%BB%9F%E8%AE%A1%E6%95%B0%E9%87%8F&spm=1018.2226.3001.4187

https://blog.youkuaiyun.com/weixin_44260614/article/details/104972327?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522165508304316782390567553%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fall.%2522%257D&request_id=165508304316782390567553&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2_allfirst_rank_ecpm_v1~rank_v31_ecpm-2-104972327-null-null.142^v13control,157^v14control&utm_term=+spring+date++mongodb+%E6%8C%89%E7%85%A7%E6%97%A5%E6%9C%9F%E7%BB%9F%E8%AE%A1%E6%95%B0%E9%87%8F&spm=1018.2226.3001.4187

https://blog.youkuaiyun.com/qq_26383975/article/details/125205882?ops_request_misc=&request_id=&biz_id=102&utm_term=%20spring%20date%20%20mongodb%20%E6%8C%89%E7%85%A7%E6%97%A5%E6%9C%9F%E7%BB%9F%E8%AE%A1%E6%95%B0%E9%87%8F&utm_medium=distribute.pc_search_result.none-task-blog-2_allsobaiduweb~default-6-125205882.142^v13control,157^v14control&spm=1018.2226.3001.4187