50,530
社区成员
发帖
与我相关
我的任务
分享
public List<RunRecord> queryAvg(Collection<String> names , Date startDate,Date endDate){
List<RunRecord> rets = new ArrayList<RunRecord>();
List<RunRecord> list = new ArrayList<RunRecord>();
Session session = HibernateUtils.create();
for(String str:names){
String hql = "select avg(activePowerAvg),avg(reactivePwerAvg),max(activePowerMax) from RunRecord rr where rr.name=:name and rr.insertDate>startDate and rr.insertDate<:endDate";
Query query = session.createQuery(hql);
query.setString("name", str);
query.setTimestamp("startDate" , startDate);
query.setTimestamp("endDate" , endDate);
list = query.list();
rets = query.addAll(list);
}
HibernateUtils.closeSession(session);
return rets;
}
List<RunRecord> records = recordDao.queryAvg(names.keySet(),startTime,endTime);
for(int i=0;i<records.size();i++){
system.out.println(records.get(i))
}
for(int i=0;i<records.size();i++){
Object[] obj = (Object[])records.get(i);
system.out.println(obj[0]+obj[1]+obj[2])
}