java实现统计 日期自动补0

一：导入日期工具类

package com.common.util;

import java.text.DateFormat;
import java.text.ParsePosition;
import java.text.SimpleDateFormat;
import java.time.Instant;
import java.time.LocalDateTime;
import java.time.ZoneId;
import java.util.*;



public class DateUtil {

        public static Date getCurrentDate() {
            return new Date();
        }


        /**
         * 获取当天的开始时间
         */
        public static Date getDayBegin() {
            Calendar cal = new GregorianCalendar();
            cal.set(Calendar.HOUR_OF_DAY, 0);
            cal.set(Calendar.MINUTE, 0);
            cal.set(Calendar.SECOND, 0);
            cal.set(Calendar.MILLISECOND, 0);
            return cal.getTime();
        }

        /**
         * 获取当天的结束时间
         * @return
         */
        public static Date getDayEnd() {
            Calendar cal = new GregorianCalendar();
            cal.set(Calendar.HOUR_OF_DAY, 23);
            cal.set(Calendar.MINUTE, 59);
            cal.set(Calendar.SECOND, 59);
            return cal.getTime();
        }

        /**
         * 获取昨天的开始时间
         * @return
         */
        public static Date getBeginDayOfYesterday() {
            Calendar cal = new GregorianCalendar();
            cal.setTime(getDayBegin());
            cal.add(Calendar.DAY_OF_MONTH, -1);
            return cal.getTime();
        }

        /**
         * 获取昨天的结束时间
         * @return
         */
        public static Date getEndDayOfYesterDay() {
            Calendar cal = new GregorianCalendar();
            cal.setTime(getDayEnd());
            cal.add(Calendar.DAY_OF_MONTH, -1);
            return cal.getTime();
        }

        /**
         * 获取明天的开始时间
         * @return
         */
        public static Date getBeginDayOfTomorrow() {
            Calendar cal = new GregorianCalendar();
            cal.setTime(getDayBegin());
            cal.add(Calendar.DAY_OF_MONTH, 1);

            return cal.getTime();
        }
        //获取明天的结束时间
        public static Date getEndDayOfTomorrow() {
            Calendar cal = new GregorianCalendar();
            cal.setTime(getDayEnd());
            cal.add(Calendar.DAY_OF_MONTH, 1);
            return cal.getTime();
        }

        /**
         * 获取本周的开始时间
         * @return
         */
        public static Date getBeginDayOfWeek() {
            Date date = new Date();
            return getBeginDayOfWeek(date);
        }
        /**
         * 获取本周的开始时间
         * @return
         */
        public static Date getBeginDayOfWeek(Date date) {
            if (date == null) {
                return null;
            }
            Calendar cal = Calendar.getInstance();
            cal.setTime(date);
            int dayofweek = cal.get(Calendar.DAY_OF_WEEK);
            if (dayofweek == 1) {
                dayofweek += 7;
            }
            cal.add(Calendar.DATE, 2 - dayofweek);
            return getDayStartTime(cal.getTime());
        }

        /**
         * 获取本周的结束时间
         * @return
         */
        public static Date getEndDayOfWeek(){
            Calendar cal = Calendar.getInstance();
            cal.setTime(getBeginDayOfWeek());
            cal.add(Calendar.DAY_OF_WEEK, 6);
            Date weekEndSta = cal.getTime();
            return getDayEndTime(weekEndSta);
        }

        /**获取本周的结束时间
         * @param date
         * @return
         * @author shaosen
         * @Date 2018年9月12日
         */
        public static Date getEndDayOfWeek(Date date){
            Calendar cal = Calendar.getInstance();
            cal.setTime(getBeginDayOfWeek(date));
            cal.add(Calendar.DAY_OF_WEEK, 6);
            Date weekEndSta = cal.getTime();
            return getDayEndTime(weekEndSta);
        }
    /**
     * 日期转为LocalDateTime
     */
    public static LocalDateTime dateToLocalDateTime(Date date) {
        Instant instant = date.toInstant();
        ZoneId zoneId = ZoneId.systemDefault();
        LocalDateTime localDateTime = instant.atZone(zoneId).toLocalDateTime();
        return localDateTime;
    }
        /**
         * 获取本月的开始时间
         * @return
         */
        public static Date getBeginDayOfMonth() {
            Calendar calendar = Calendar.getInstance();
            calendar.set(getNowYear(), getNowMonth() - 1, 1);
            return getDayStartTime(calendar.getTime());
        }
        /**
         * 获取本月的开始时间
         * @return
         */
        public static Date getBeginDayOfMonth(Date time){
            Calendar calendar = Calendar.getInstance();
            calendar.setTime(time);
            calendar.set(calendar.get(Calendar.YEAR), calendar.get(Calendar.MONTH) , 1);
            return getDayStartTime(calendar.getTime());
        }

        /**
         * 获取本月的结束时间
         * @return
         */
        public static Date getEndDayOfMonth() {
            Calendar calendar = Calendar.getInstance();
            calendar.set(getNowYear(), getNowMonth() - 1, 1);
            int day = calendar.getActualMaximum(5);
            calendar.set(getNowYear(), getNowMonth() - 1, day);
            return getDayEndTime(calendar.getTime());
        }


        /**
         * 获取本月的结束时间
         * @return
         */
        public static Date getEndDayOfMonth(Date time) {
            Calendar calendar = Calendar.getInstance();
            calendar.setTime(time);
            calendar.set(calendar.get(Calendar.YEAR), calendar.get(Calendar.MONTH) , 1);
            int day = calendar.getActualMaximum(Calendar.DAY_OF_MONTH);
            calendar.set(calendar.get(Calendar.YEAR), calendar.get(Calendar.MONTH) , day);
            return getDayEndTime(calendar.getTime());
        }

        /**
         * 获取本年的开始时间
         * @return
         */
        public static Date getBeginDayOfYear() {
            return getBeginDayOfYear(new Date());
        }

        /**
         * 获得time所在年的第一天
         * @param time
         * @return
         */
        public static Date getBeginDayOfYear(Date time){
            Calendar cal = Calendar.getInstance();
            cal.setTime(time);
            cal.set(Calendar.YEAR, cal.get(Calendar.YEAR));
            cal.set(Calendar.MONTH, Calendar.JANUARY);
            cal.set(Calendar.DATE, 1);

            return getDayStartTime(cal.getTime());
        }

        /**
         * 获取本年的结束时间
         * @return
         */
        public static Date getEndDayOfYear() {
            return getEndDayOfYear(new Date());
        }


        /**
         * 获取本年的结束时间
         * @return
         */
        public static Date getEndDayOfYear(Date time) {
            Calendar cal = Calendar.getInstance();
            cal.setTime(time);
            cal.set(Calendar.YEAR, cal.get(Calendar.YEAR));
            cal.set(Calendar.MONTH, Calendar.DECEMBER);
            cal.set(Calendar.DATE, 31);
            return getDayEndTime(cal.getTime());
        }

        /**
         * 获取某个日期的开始时间
         * @param d
         * @return
         */
        public static Date getDayStartTime(Date d) {
            Calendar calendar = Calendar.getInstance();
            if(null != d) calendar.setTime(d);
            calendar.set(calendar.get(Calendar.YEAR), calendar.get(Calendar.MONTH),calendar.get(Calendar.DAY_OF_MONTH), 0, 0, 0);
            calendar.set(Calendar.MILLISECOND, 0);
//        return new Timestamp(calendar.getTimeInMillis());
            return calendar.getTime();
        }

        /**
         * 获取某个日期的结束时间
         * @param d
         * @return
         */
        public static Date getDayEndTime(Date d) {
            Calendar calendar = Calendar.getInstance();
            if(null != d) calendar.setTime(d);
            calendar.set(calendar.get(Calendar.YEAR), calendar.get(Calendar.MONTH), calendar.get(Calendar.DAY_OF_MONTH), 23, 59, 59);
            calendar.set(Calendar.MILLISECOND, 999);
//        return new Timestamp(calendar.getTimeInMillis());
            return calendar.getTime();
        }

        /**
         * 获取今年是哪一年
         * @return
         */
        public static Integer getNowYear() {
            Date date = new Date();
            return getNowYear(date);
        }
        /**
         * 获取今年是哪一年
         * @return
         */
        public static Integer getNowYear(Date date) {
            GregorianCalendar gc = (GregorianCalendar) Calendar.getInstance();
            gc.setTime(date);
            return Integer.valueOf(gc.get(1));
        }

        /**
         * 获取本月是哪一月
         * @return
         */
        public static int getNowMonth() {
            Date date = new Date();
            return getNowMonth(date);
        }
        /**
         * 获取本月是哪一月
         * @return
         */
        public static int getNowMonth(Date date) {
            GregorianCalendar gc = (GregorianCalendar) Calendar.getInstance();
            gc.setTime(date);
            return gc.get(2) + 1;
        }

        /**
         * @Description: 获取当日是第几周
         * @param @param date
         * @param @return
         * @return int
         * @throws
         * @author shaosen
         * @date 2018年6月1日
         */
        public static int getNowWeek(Date date) {
            Calendar ca = Calendar.getInstance();
            ca.setTime(date);
            return ca.get(Calendar.WEEK_OF_YEAR);
        }

        /**
         * 两个日期相减得到的天数
         * @param beginDate
         * @param endDate
         * @return
         */
        public static int getDiffDays(Date beginDate, Date endDate) {

            if (beginDate == null || endDate == null) {
                throw new IllegalArgumentException("getDiffDays param is null!");
            }

            long diff = (endDate.getTime() - beginDate.getTime())
                    / (1000 * 60 * 60 * 24);

            int days = new Long(diff).intValue();

            return days;
        }

        /**
         * @Description: 获取两个日期的时间差
         * @param @param beginDate
         * @param @param endDate
         * @return long
         * @throws
         * @author shaosen
         * @date 2018年6月13日
         */
        public static long getDiffHours(Date beginDate, Date endDate) {
            long between = dateDiff(beginDate, endDate);
            long day = between / (24 * 60 * 60 * 1000);
            long hours = (between / (60 * 60 * 1000) - day * 24);
            return day*24+hours;
        }

        /**
         * 两个日期相减得到的毫秒数
         * @param beginDate
         * @param endDate
         * @return
         */
        public static long dateDiff(Date beginDate, Date endDate) {
            long date1ms = beginDate.getTime();
            long date2ms = endDate.getTime();
            return date2ms - date1ms;
        }

        /**
         * 获取两个日期中的最大日期
         * @param beginDate
         * @param endDate
         * @return
         */
        public static Date max(Date beginDate, Date endDate) {
            if (beginDate == null) {
                return endDate;
            }
            if (endDate == null) {
                return beginDate;
            }
            if (beginDate.after(endDate)) {
                return beginDate;
            }
            return endDate;
        }

        /**
         * 获取两个日期中的最小日期
         * @param beginDate
         * @param endDate
         * @return
         */
        public static Date min(Date beginDate, Date endDate) {
            if (beginDate == null) {
                return endDate;
            }
            if (endDate == null) {
                return beginDate;
            }
            if (beginDate.after(endDate)) {
                return endDate;
            }
            return beginDate;
        }

        /**
         * 返回某月该季度的第一个月
         * @param date
         * @return
         */
        public static Date getFirstSeasonDate(Date date) {
            final int[] SEASON = { 1, 1, 1, 2, 2, 2, 3, 3, 3, 4, 4, 4 };
            Calendar cal = Calendar.getInstance();
            cal.setTime(date);
            int sean = SEASON[cal.get(Calendar.MONTH)];
            cal.set(Calendar.MONTH, sean * 3 - 3);
            return cal.getTime();
        }

        /**
         * 返回某个日期下几天的日期
         * @param date
         * @param i
         * @return
         */
        public static Date getNextDay(Date date, int i) {
            Calendar cal = new GregorianCalendar();
            cal.setTime(date);
            cal.set(Calendar.DATE, cal.get(Calendar.DATE) + i);
            return cal.getTime();
        }

        /**
         * 返回某个日期前几天的日期
         * @param date
         * @param i
         * @return
         */
        public static Date getFrontDay(Date date, int i) {
            Calendar cal = new GregorianCalendar();
            cal.setTime(date);
            cal.set(Calendar.DATE, cal.get(Calendar.DATE) - i);
            return cal.getTime();
        }

        /**
         * 获取某年某月到某年某月按天的切片日期集合（间隔天数的日期集合）
         * @param beginYear
         * @param beginMonth
         * @param endYear
         * @param endMonth
         * @param k
         * @return
         */
        public static List getTimeList(int beginYear, int beginMonth, int endYear,
                                       int endMonth, int k) {
            List list = new ArrayList();
            if (beginYear == endYear) {
                for (int j = beginMonth; j <= endMonth; j++) {
                    list.add(getTimeList(beginYear, j, k));

                }
            } else {
                {
                    for (int j = beginMonth; j < 12; j++) {
                        list.add(getTimeList(beginYear, j, k));
                    }

                    for (int i = beginYear + 1; i < endYear; i++) {
                        for (int j = 0; j < 12; j++) {
                            list.add(getTimeList(i, j, k));
                        }
                    }
                    for (int j = 0; j <= endMonth; j++) {
                        list.add(getTimeList(endYear, j, k));
                    }
                }
            }
            return list;
        }

        /**
         * 获取某年某月按天切片日期集合（某个月间隔多少天的日期集合）
         * @param beginYear
         * @param beginMonth
         * @param k
         * @return
         */
        public static List getTimeList(int beginYear, int beginMonth, int k) {
            List list = new ArrayList();
            Calendar begincal = new GregorianCalendar(beginYear, beginMonth, 1);
            int max = begincal.getActualMaximum(Calendar.DATE);
            for (int i = 1; i < max; i = i + k) {
                list.add(begincal.getTime());
                begincal.add(Calendar.DATE, k);
            }
            begincal = new GregorianCalendar(beginYear, beginMonth, max);
            list.add(begincal.getTime());
            return list;
        }

        /**
         * 将精确到s的时间戳转化为时间
         * @param t
         * @return
         */
        public static Date setTimestamp2Date(long t){
            return new Date(t * 1000);
        }

        /**
         * 将精确到毫秒的时间戳转化为时间
         * @param t
         * @return
         */
        public static Date setMillisTimestamp2Date(long t){
            return new Date(t);
        }

        /**
         * 将时间转化为s的时间戳
         * @param d
         * @return
         */
        public static Long setDate2Timestamp(Date d){
            return d.getTime() / 1000;
        }

        /**
         * 将时间转化为毫秒为单位的时间戳
         * @param d
         * @return
         */
        public static Long setDate2MillisTimestamp(Date d){
            return d.getTime();
        }

        /**
         * string格式转Date yyyy-MM-dd HH:mm:ss
         * @param s
         * @return
         */
        public static Date getString2Date(String s){
            if(s==null||s.trim().length()<0) {
                return null;
            }
            DateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
            ParsePosition pos = new ParsePosition(0);
            return formatter.parse(s, pos);
        }


        /**
         * 将时间转化为string格式 yyyy-MM-dd HH:mm:ss
         * @param d
         * @return
         */
        public static String getDate2String(Date d){
            DateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
            return formatter.format(d);
        }

        public static String getDate2YYYYMMdd(Date d){
            DateFormat formatter = new SimpleDateFormat("yyyyMMdd");
            return formatter.format(d);
        }



        /**获取前n个小时的时间
         * @param date
         * @param hour
         * @return
         * @author shaosen
         * @Date 2018年9月12日
         */
        public static Date getBeforHour(Date date , int hour) {
            Calendar c = Calendar.getInstance();
            c.setTime(date);
            c.set(Calendar.HOUR_OF_DAY, c.get(Calendar.HOUR_OF_DAY) - hour );
            return c.getTime();
        }

        /**获取后n个小时的时间
         * @param date
         * @param hour
         * @return
         * @author shaosen
         * @Date 2018年9月12日
         */
        public static Date getAfterHour(Date date , int hour) {
            Calendar c = Calendar.getInstance();
            c.setTime(date);
            c.set(Calendar.HOUR_OF_DAY, c.get(Calendar.HOUR_OF_DAY) + hour );
            return c.getTime();
        }

        /**获取小时开始时间
         * @param date
         * @return
         * @author shaosen
         * @Date 2018年9月12日
         */
        public static Date getHourBeginTime(Date date) {
            Calendar c = Calendar.getInstance();
            c.setTime(date);
            c.set(c.get(Calendar.YEAR), c.get(Calendar.MONTH), c.get(Calendar.DAY_OF_MONTH), c.get(Calendar.HOUR_OF_DAY), 0, 0);
            c.set(Calendar.MILLISECOND, 0);
            return c.getTime();
        }

        /**获取小时结束时间
         * @param date
         * @return
         * @author shaosen
         * @Date 2018年9月12日
         */
        public static Date getHourEndTime(Date date) {
            Calendar c = Calendar.getInstance();
            c.setTime(date);
            c.set(c.get(Calendar.YEAR), c.get(Calendar.MONTH), c.get(Calendar.DAY_OF_MONTH), c.get(Calendar.HOUR_OF_DAY), 59, 59);
            c.set(Calendar.MILLISECOND, 999);
            return c.getTime();
        }





        private static List<Map<String, Date>> getStartTimeAndEndTimeByDay(Date date, List<Map<String, Date>> list) {
            Date endDay = DateUtil.getFrontDay(date, 1);// 返回某个日期前几天的日期
            Date startDay = DateUtil.getDayStartTime(endDay);

            if (startDay.after(DateUtil.getBeginDayOfYear())) {
                Map<String, Date> map = new HashMap<>();
                map.put("startDay", startDay);
                map.put("endDay", date);
                list.add(map);
                getStartTimeAndEndTimeByDay(startDay, list);
            } else {
                Map<String, Date> lastMap = new HashMap<>();
                lastMap.put("startDay", DateUtil.getBeginDayOfYear());
                lastMap.put("endDay", date);
                list.add(lastMap);
            }
            return list;
        }


        private static List<Map<String, Date>> getStartTimeAndEndTimeByMonth(Date date, List<Map<String, Date>> list) {

            Date endDay = DateUtil.getFrontDay(date, 1);// 返回某个日期前几天的日期
            Date startDay = DateUtil.getBeginDayOfMonth(endDay);

            if (startDay.after(DateUtil.getBeginDayOfYear())) {
                Map<String, Date> map = new HashMap<>();
                map.put("startDay", startDay);
                map.put("endDay", date);
                list.add(map);
                // 继续找上月开始时间和结束时间
                getStartTimeAndEndTimeByMonth(startDay, list);
            }
            return list;
        }


        private static List<Map<String, Date>> getStartTimeAndEndTimeByWeek(Date date, List<Map<String, Date>> list) {

            Date endDay = DateUtil.getFrontDay(date, 1);// 返回某个日期前几天的日期
            Date startDay = DateUtil.getBeginDayOfWeek(endDay);

            if (startDay.after(DateUtil.getBeginDayOfYear())) {
                Map<String, Date> map = new HashMap<>();
                map.put("startDay", startDay);
                map.put("endDay", date);
                list.add(map);
                // 继续找上周开始时间和结束时间
                getStartTimeAndEndTimeByWeek(startDay, list);
            } else {
                // 获取本年第一周开始日期和结束日期
                Map<String, Date> lastMap = new HashMap<>();
                lastMap.put("startDay", DateUtil.getBeginDayOfYear());
                lastMap.put("endDay", date);
                list.add(lastMap);
            }
            return list;
        }


        /**获取当月以前共12个月的日期集合
         * @author shaosen
         * @date 2019年1月17日
         * @param
         * @return List<Map<String,Date>>
         */
        public static List<Map<String, Date>> getBefore12Months(){

            List<Map<String, Date>> list = new ArrayList<>();

            Date startDay = DateUtil.getBeginDayOfMonth();
            Map<String, Date> map = new HashMap<>();
            map.put("startDay", startDay);
            map.put("endDay", new Date());
            list.add(map);

            for (int i = 1; i < 12; i++) {
                startDay = DateUtil.getBeginDayOfMonth(DateUtil.getFrontDay(startDay, 1));
                Map<String, Date> m = new HashMap<>();
                m.put("startDay", startDay);
                m.put("endDay", DateUtil.getEndDayOfMonth(startDay));
                list.add(m);
            }
            return list;
        }

      /**
     * 获取近n的日期
     */
    public static Date getDateAdd(int days) {

        SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM-dd");

        Calendar c = Calendar.getInstance();

        c.add(Calendar.DAY_OF_MONTH, -days);

        return c.getTime();

    }


}

二：导入日期补0工具类

package com.common.util;

import java.time.Duration;
import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;
import java.util.ArrayList;
import java.util.List;

public class CompletionDateUtils {
     /*
      * 隐藏构造方法.
     */
    private CompletionDateUtils() {
    }

    /**
     * 数据库查询出来的统计数据有时候日期是不连续的.
     * 但是前端展示要补全缺失的日期.
     * 此方法返回一个给定日期期间的所有日期字符串列表.
     * 具体在业务逻辑中去判断补全.
     *
     * @param startDate 开始日期
     * @param endDate   结束日期
     * @param Pattern   日期格式
     * @return
     */
    public static List<String> completionDate(
            LocalDateTime startDate,
            LocalDateTime endDate,
            String pattern) {
        //日期格式化
        DateTimeFormatter formatter = DateTimeFormatter.ofPattern(pattern);
        List<String> dateList = new ArrayList<>();
        //遍历给定的日期期间的每一天
        for (int i = 0; !Duration.between(startDate.plusDays(i), endDate).isNegative(); i++) {
            //添加日期
            dateList.add(startDate.plusDays(i).format(formatter));
        }
        return dateList;
    }


}

三：使用

  public static void main(String[] args) {
        //模拟数据库数据
        List<Home> homeList = new ArrayList<>();
        Home home = new Home();
        home.setDay("03-28");
        home.setCounts(10L);
        homeList.add(home);
        //获取本周
        LocalDateTime statTime = DateUtil.dateToLocalDateTime(DateUtil.getBeginDayOfWeek());
        LocalDateTime endTime=LocalDateTime.now();
        //本周到今日自动补充0
        List<String> dayStringList = CompletionDateUtils.completionDate(statTime, endTime,"MM-dd");
        List<Home> dayList = dayStringList.stream().map(day -> {
            Home home1 = new Home();
            home1.setCounts(0L);
            home1.setDay(day);
            return home1;
        }).collect(Collectors.toList());
        for (Home home1 : homeList) {
            for (Home home2 : dayList) {
                if(home1.getDay().equals(home2.getDay())){
                    home2.setCounts(home1.getCounts());
                    break;
                }
            }
        }
        System.out.println("输出补0后的数据结果集"+dayList);
    }
    @Data
    static class Home{
        /**
         * 天数
         */
        private String day;

        /**
         * 个数
         */
        private  Long counts;
    }

注意：Date转LocalDateTime

 /**
     * 日期转为LocalDateTime
     */
    public static LocalDateTime dateToLocalDateTime(Date date) {
        Instant instant = date.toInstant();
        ZoneId zoneId = ZoneId.systemDefault();
        LocalDateTime localDateTime = instant.atZone(zoneId).toLocalDateTime();
        return localDateTime;
    }