查询每天最早一次时间和最晚一次时间
mysql部分
left(str,10)是指str自动从左往右取10个字段
select xx,xx,MIN(datetime) as am,MAX(datetime) as pm from xxxx GROUP BY left(datetime,10);
后台判断比较时间
int late = 0;
int leave = 0;
SimpleDateFormat format = new SimpleDateFormat("HH:mm:ss");
List<xxx> xxxList = xxxxxx;//获取数据列表
Date date1 = format.parse(xxxList.get(i).getAm().split(" ")[1]);//截取时间戳的时分秒
Date date2 = format.parse("08:30:00");
int compareTo = date1.compareTo(date2);
if(compareTo==1){
//date1大于date2
xxxList.get(i).setAm(xxxList.get(0).getAm()+"(迟到)");
late = late+1;
}
date1 = format.parse(xxxList.get(0).getPm().split(" ")[1]);//截取时间戳的时分秒
date2 = format.parse("17:30:00");
compareTo = date1.compareTo(date2);
if(compareTo==-1){
//date1小于date2
xxxList.get(i).setPm(xxxList.get(0).getPm()+"(早退)");
leave = leave+1;
}