query类方式:
我比较常用,简单易懂,且能够一步到位。
Query query = new Query();
Criteria criteria = new Criteria();
criteria.and("f3").is("DeccaRecords");//类型为DeccaRecords
criteria.and("f2").gte(datebeginTime).lte(dateendTime);
query.addCriteria(criteria);
query.with(Sort.by(Sort.Order.desc("f1")));//排序
List<Map> mapList = mongoTemplate.find(query, Map.class, "tbanalyze");
也可简写为:
List<Map> tbDeccaList = mongoTemplate.find(new Query(Criteria.where("deccaNo").is(map.get("f0").toString())), Map.class, "tbDecca");
聚合方式 :
Aggregation aggregation = Aggregation.newAggregation(
//条件(含格林威治时间转换,见下文附加类)
Aggregation.match(Criteria.where("activity_no").is("3VSWM91OVOZS6LP0Z9YWE11O").and("create_time").gte(MogoISOdata.dateToISODate(datebeginTime)).lte(MogoISOdata.dateToISODate(dateendTime))),
//分组
Aggregation.group("create_time").sum("receive_num").as("usenum").first("create_time").as("create_time"),
//排序
Aggregation.sort(Sort.by("create_time").ascending())
);
List<Map> tbpayuser = mongoTemplate.aggregate(aggregation, "tbdailydate", Map.class).getMappedResults();
附加类(格林威治时间转换):
package com.hanlong.guns.modular.util;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.GregorianCalendar;
import java.util.SimpleTimeZone;
public class MogoISOdata {
/** * mongo 日期查询isodate * @param dateStr * @return */
public static Date dateToISODate(String dateStr){
//T代表后面跟着时间,Z代表UTC统一时间
Date date = formatD(dateStr);
SimpleDateFormat format =
new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSS'Z'");
format.setCalendar(new GregorianCalendar(new SimpleTimeZone(0, "GMT")));
String isoDate = format.format(date);
try {
return format.parse(isoDate);
} catch (ParseException e) {
e.printStackTrace();
}
return null;
}
/** 时间格式(yyyy-MM-dd HH:mm:ss) */
public final static String DATE_TIME_PATTERN = "yyyy-MM-dd HH:mm:ss";
public final static long TIMESTAMP = 28800000;
public static Date formatD(String dateStr){
return formatD(dateStr,DATE_TIME_PATTERN);
}
public static Date formatD(String dateStr ,String format) {
SimpleDateFormat simpleDateFormat = new SimpleDateFormat(format);
Date ret = null ;
try {
ret = simpleDateFormat.parse(dateStr) ;
ret = new Date(ret.getTime()+TIMESTAMP);
} catch (ParseException e) {
//
}
return ret;
}
}