10,612
社区成员




public void queryDriverRanking(long start, long end){
Aggregation aggregation = Aggregation.newAggregation(
Aggregation.group(StringConst.driverId).count().as("orderAmt"),
Aggregation.sort(new Sort(Sort.Direction.DESC,"orderAmt"))//排序,可以忽略
);
AggregationResults<DriverRanking> ar = mongoTemplate.aggregate(aggregation,"order", DriverRanking.class);
List<DriverRanking> list = ar.getMappedResults();//如果成功该List就是我想要的结果
for (DriverRanking ranking : list) {
System.out.println(ranking);
}
}
public class DriverRanking {
String driverId;
Integer orderAmt;//订单数量
private String name;
public String getName() {
name = BaseDomain.userDao.findById(driverId).getName();//通过id去数据库查询,不知道能不能实现
return name;
}
public void setName(String name) {
this.name = name;
}
@Override
public String toString() {
return "DriverRanking [driverId=" + driverId + ", orderAmt="
+ orderAmt + ", name=" + name + "]";
}
}