【Mybatis】Date型和String型的时间类型和格式转换

Date

String

2017-06-14

 

public List<ReportWeekVO> activeDeviceWeek() {

    List<ReportWeekVO> reportWeekVOs = reportDeviceWeekMapper.activeDeviceWeek();
    logger.info("[ReportDeviceService] [activeDeviceWeek] query active device in week, response = {}", JSON.toJSONString(reportWeekVOs));

    List<ReportWeekVO> newReportWeekVOs = new ArrayList<>();

    //获取当天日期
    SimpleDateFormat dateFormater = new SimpleDateFormat("yyyy-MM-dd");
    for (int i = 1; i < 8; i++) {
        ReportWeekVO newReportWeekVO = new ReportWeekVO();
        Calendar calendar = Calendar.getInstance();
        calendar.add(Calendar.DATE, -i);
        Date monday = calendar.getTime();
        String preMonday = dateFormater.format(monday);
        newReportWeekVO.setDate(preMonday);

        int intWeek = calendar.get(Calendar.DAY_OF_WEEK) - 1;
        newReportWeekVO.setWeek(intWeek);
        newReportWeekVO.setCount(0);
        newReportWeekVOs.add(newReportWeekVO);
    }
    logger.info("[ReportDeviceService] [activeDeviceWeek]  newReportWeekVOs = {}", JSON.toJSONString(newReportWeekVOs));

    for (int i = 0; i < newReportWeekVOs.size(); i++) {
        for (int j = 0; j < reportWeekVOs.size(); j++) {
            if (newReportWeekVOs.get(i).getDate().equals(reportWeekVOs.get(j).getDate())) {
                newReportWeekVOs.get(i).setCount(reportWeekVOs.get(j).getCount());
            }
        }
    }
    logger.info("[ReportDeviceService] [activeDeviceWeek]  newReportWeekVOs = {}", JSON.toJSONString(newReportWeekVOs));

    return newReportWeekVOs;
}