开发笔记:Hibernate使用distinct返回不重复的数据，使用groupby进行分组

public List distinctDutyDate() {
String hql="select distinct(dutyDate) from DoctorDuty";
Query query=getSession().createQuery(hql);
List list= query.list();
Iterator it= list.iterator();
List list1=new ArrayList();
while(it.hasNext()){
String dutyDate=it.next()+"";
list1.add(dutyDate);
}
return list1;
}

public List getYearMonthByUserId(Integer userId, String submitType) {
String hql="select submitYear,submitMonth from TotalBranchSubmit where userId=:userId and submitType=:submitType group by submitYear,submitMonth ";
Query query = getSession().createQuery(hql)
.setParameter("userId",userId)
.setParameter("submitType",submitType);
List list= query.list();
Iterator it= list.iterator();
List list1=new ArrayList<>();
while(it.hasNext()){
Object[] res=(Object[]) it.next();
YearMonthDTO dto=new YearMonthDTO();
String year=res[0]+"";
String month=res[1]+"";
dto.setYear(year);
dto.setMonth(month);
list1.add(dto);
}
return list1;
}