Java 计算日期之间 天数 周数 月数 年数 列表

红太狼 2022-08-09 18:56 439阅读 0赞 
  1. import java.text.ParseException;
  2. import java.text.SimpleDateFormat;
  3. import java.util.ArrayList;
  4. import java.util.Calendar;
  5. import java.util.Date;
  6. import java.util.List;
  8. public class DateUtil {
  9.     public static final String YYYYMM = "yyyy-MM";
  10.     public static final String YYYYMMDD = "yyyy-MM-dd";
  11.     public static final String YYYYMMDDHHMMSS = "yyyy-MM-dd HH:mm:ss";
  13.     /**
  14.      * 获取两个时间中连续日期-包含开始时间结束时间所在日期
  15.      *
  16.      * @param startDay yyyy-MM-dd
  17.      * @param endDay   yyyy-MM-dd
  18.      * @return
  19.      */
  20.     public static List<String> getDayList(String startDay, String endDay) {
  21.         List<String> result = new ArrayList<>();
  22.         result.add(startDay.substring(0, 10));
  23.         if (startDay.equals(endDay)) {
  24.             return result;
  25.         }
  26.         Calendar tempStart = Calendar.getInstance();
  27.         tempStart.setTime(parseDate(startDay, null));
  28.         tempStart.add(Calendar.DAY_OF_YEAR, 1);
  30.         Calendar tempEnd = Calendar.getInstance();
  31.         tempEnd.setTime(parseDate(endDay, null));
  32.         while (tempStart.before(tempEnd)) {
  33.             result.add(new SimpleDateFormat("yyyy-MM-dd").format(tempStart.getTime()));
  34.             tempStart.add(Calendar.DAY_OF_YEAR, 1);
  35.         }
  36.         result.add(endDay.substring(0, 10));
  37.         return result;
  38.     }
  40.     /**
  41.      * 获取两个时间中连续周数-包含开始时间结束时间所在周数
  42.      *
  43.      * @param startWeek yyyy-0~53
  44.      * @param endWeek   yyyy-1~53
  45.      * @return
  46.      */
  47.     public static List<String> getWeekList(String startWeek, String endWeek) {
  48.         List<String> result = new ArrayList<>();
  49.         int sYear = Integer.parseInt(startWeek.substring(0, 4));// 开始年数
  50.         int sWeek = Integer.parseInt(startWeek.substring(5, 7));// 开始周数
  51.         int eYear = Integer.parseInt(endWeek.substring(0, 4));// 结束年数
  52.         int eWeek = Integer.parseInt(endWeek.substring(5, 7));// 结束周数
  53.         if (sYear == eYear) {// 开始、结束年数为同一年
  54.             while (sWeek <= eWeek) {
  55.                 result.add(sYear + "-" + formatIntStr(sWeek));
  56.                 sWeek = sWeek + 1;
  57.             }
  58.         } else {// 开始、结束年数非同一年
  59.             int sYearWeekNum = weekNumOfYear(sYear);// 开始年周总数
  60.             while (sWeek <= sYearWeekNum) {// 开始年周数信息
  61.                 result.add(sYear + "-" + formatIntStr(sWeek));
  62.                 sWeek = sWeek + 1;
  63.             }
  64.             if ((eYear - sYear) > 1) {// 开始、结束年间隔大于 1
  65.                 sYear = sYear + 1;
  66.                 while (sYear < eYear) {
  67.                     int tempWeekNum = weekNumOfYear(sYear);// 间隔年周总数
  68.                     for (int i = 1; i <= tempWeekNum; i++) {
  69.                         result.add(sYear + "-" + formatIntStr(i));
  70.                     }
  71.                     sYear = sYear + 1;
  72.                 }
  73.             }
  74.             for (int i = 1; i <= eWeek; i++) {
  75.                 result.add(eYear + "-" + formatIntStr(i));
  76.             }
  77.         }
  78.         return result;
  79.     }
  81.     /**
  82.      * 获取两个时间中连续月份-包含开始时间结束时间所在月份
  83.      *
  84.      * @param startMonth yyyy-MM
  85.      * @param endMonth   yyyy-MM
  86.      * @return
  87.      */
  88.     public static List<String> getMonthList(String startMonth, String endMonth) {
  89.         ArrayList<String> result = new ArrayList<>();
  90.         try {
  91.             SimpleDateFormat sdf = new SimpleDateFormat(YYYYMM);//格式化为年月
  92.             Calendar min = Calendar.getInstance();
  93.             Calendar max = Calendar.getInstance();
  95.             min.setTime(sdf.parse(startMonth));
  96.             min.set(min.get(Calendar.YEAR), min.get(Calendar.MONTH), 1);
  98.             max.setTime(sdf.parse(endMonth));
  99.             max.set(max.get(Calendar.YEAR), max.get(Calendar.MONTH), 2);
  101.             Calendar curr = min;
  102.             while (curr.before(max)) {
  103.                 result.add(sdf.format(curr.getTime()));
  104.                 curr.add(Calendar.MONTH, 1);
  105.             }
  106.         } catch (ParseException e) {
  107.             e.printStackTrace();
  108.         }
  109.         return result;
  110.     }
  112.     /**
  113.      * 获取两个时间中连续年份-包含开始时间结束时间所在年份
  114.      *
  115.      * @param startYear yyyy
  116.      * @param endYear   yyyy
  117.      * @return
  118.      */
  119.     public static List<String> getYearList(String startYear, String endYear) {
  120.         ArrayList<String> result = new ArrayList<>();
  121.         int start = Integer.parseInt(startYear);
  122.         int end = Integer.parseInt(endYear);
  123.         result.add(startYear);
  124.         while (start < end) {
  125.             start++;
  126.             result.add(String.valueOf(start));
  127.         }
  128.         return result;
  129.     }
  131.     /**
  132.      * 时间字符串转换为时间
  133.      *
  134.      * @param strDate
  135.      * @param pattern
  136.      * @return
  137.      */
  138.     public static Date parseDate(String strDate, String pattern) {
  139.         Date date = null;
  140.         try {
  141.             if (pattern == null) {
  142.                 pattern = YYYYMMDD;
  143.             }
  144.             SimpleDateFormat format = new SimpleDateFormat(pattern);
  145.             date = format.parse(strDate);
  146.         } catch (Exception e) {
  147.             e.printStackTrace();
  148.         }
  149.         return date;
  150.     }
  152.     /**
  153.      * 获取一年周数
  154.      *
  155.      * @param year
  156.      * @return
  157.      */
  158.     public static int weekNumOfYear(int year) {
  159.         int weekNum = 0;
  160.         int days = 365;
  161.         int day = 0; // 判断是否闰年，闰年366天
  162.         if (year % 400 == 0 || (year % 4 == 0 && year % 100 != 0)) {
  163.             days = 366;
  164.         }
  165.         // 得到一年所有天数然后除以7
  166.         day = days % 7 > 0 ? weekNum += 1 : weekNum;
  167.         // 得到余下几天如果有余则周+1，否则不加
  168.         weekNum += days / 7;
  169.         //得到多少周
  170.         return weekNum;
  171.     }
  173.     /**
  174.      * 小于 10 数字前补 0
  175.      *
  176.      * @param formatInt
  177.      * @return
  178.      */
  179.     public static String formatIntStr(int formatInt) {
  180.         if (formatInt > 9) {
  181.             return "" + formatInt;
  182.         } else {
  183.             return "0" + formatInt;
  184.         }
  185.     }
  187.     public static void main(String[] args) {
  188.         getDayList("2019-12-25", "2020-01-01").stream().forEach(str -> System.out.println(str));
  189.         getWeekList("2018-50", "2020-05").stream().forEach(str -> System.out.println(str));
  190.         getMonthList("2019-12", "2020-05").stream().forEach(str -> System.out.println(str));
  191.         getYearList("2001", "2020").stream().forEach(str -> System.out.println(str));
  192.     }
  193. }

Mybatis 统计代码：

  1. <select id="dayReportForm" resultType="java.util.Map">
  2.         SELECT
  3.             date_format(team.dispatch_time, '%Y-%m-%d') AS dayTime,
  4.             COUNT(*) AS teamCountNum
  5.         FROM
  6.             fire_warn_team_rel AS team
  7.         WHERE 1 = 1
  8.             <if test="startTime != null and startTime != ''">
  9.                 AND date_format(team.dispatch_time, '%Y-%m-%d') <![CDATA[ >= ]]> #{startTime}
  10.             </if>
  11.             <if test="endTime != null and endTime != ''">
  12.                 AND date_format(team.dispatch_time, '%Y-%m-%d') <![CDATA[ <= ]]> #{endTime}
  13.             </if>
  14.             <if test="limitStart != null and limitStart != ''">
  15.                 AND date_format(team.dispatch_time, '%Y-%m-%d') <![CDATA[ >= ]]> #{limitStart}
  16.             </if>
  17.             <if test="limitEnd != null and limitEnd != ''">
  18.                 AND date_format(team.dispatch_time, '%Y-%m-%d') <![CDATA[ <= ]]> #{limitEnd}
  19.             </if>
  20.         GROUP BY
  21.             date_format(team.dispatch_time, '%Y-%m-%d');
  22.     </select>
  24.     <select id="weekReportForm" resultType="java.util.Map">
  25.         SELECT
  26.             yearweek(team.dispatch_time, 3) AS weekTime,
  27.             COUNT(*) AS teamCountNum
  28.         FROM
  29.             fire_warn_team_rel AS team
  30.         WHERE 1 = 1
  31.             <if test="startTime != null and startTime != ''">
  32.                 AND yearweek(team.dispatch_time, 3) <![CDATA[ >= ]]> #{startTime}
  33.             </if>
  34.             <if test="endTime != null and endTime != ''">
  35.                 AND yearweek(team.dispatch_time, 3) <![CDATA[ <= ]]> #{endTime}
  36.             </if>
  37.             <if test="limitStart != null and limitStart != ''">
  38.                 AND yearweek(team.dispatch_time, 3) <![CDATA[ >= ]]> #{limitStart}
  39.             </if>
  40.             <if test="limitEnd != null and limitEnd != ''">
  41.                 AND yearweek(team.dispatch_time, 3) <![CDATA[ <= ]]> #{limitEnd}
  42.             </if>
  43.         GROUP BY
  44.             yearweek(team.dispatch_time, 3);
  45.     </select>
  47.     <select id="monthReportForm" resultType="java.util.Map">
  48.         SELECT
  49.             date_format(team.dispatch_time, '%Y-%m') AS monthTime,
  50.             COUNT(*) AS teamCountNum
  51.         FROM
  52.             fire_warn_team_rel AS team
  53.         WHERE 1 = 1
  54.             <if test="startTime != null and startTime != ''">
  55.                 AND date_format(team.dispatch_time, '%Y-%m') <![CDATA[ >= ]]> #{startTime}
  56.             </if>
  57.             <if test="endTime != null and endTime != ''">
  58.                 AND date_format(team.dispatch_time, '%Y-%m') <![CDATA[ <= ]]> #{endTime}
  59.             </if>
  60.             <if test="limitStart != null and limitStart != ''">
  61.                 AND date_format(team.dispatch_time, '%Y-%m') <![CDATA[ >= ]]> #{limitStart}
  62.             </if>
  63.             <if test="limitEnd != null and limitEnd != ''">
  64.                 AND date_format(team.dispatch_time, '%Y-%m') <![CDATA[ <= ]]> #{limitEnd}
  65.             </if>
  66.         GROUP BY
  67.             date_format(team.dispatch_time, '%Y-%m');
  68.     </select>
  70.     <select id="yearReportForm" resultType="java.util.Map">
  71.         SELECT
  72.             date_format(team.dispatch_time, '%Y') AS yearTime,
  73.             COUNT(*) AS teamCountNum
  74.         FROM
  75.             fire_warn_team_rel AS team
  76.         WHERE 1 = 1
  77.             <if test="startTime != null and startTime != ''">
  78.                 AND date_format(team.dispatch_time, '%Y') <![CDATA[ >= ]]> #{startTime}
  79.             </if>
  80.             <if test="endTime != null and endTime != ''">
  81.                 AND date_format(team.dispatch_time, '%Y') <![CDATA[ <= ]]> #{endTime}
  82.             </if>
  83.             <if test="limitStart != null and limitStart != ''">
  84.                 AND date_format(team.dispatch_time, '%Y') <![CDATA[ >= ]]> #{limitStart}
  85.             </if>
  86.             <if test="limitEnd != null and limitEnd != ''">
  87.                 AND date_format(team.dispatch_time, '%Y') <![CDATA[ <= ]]> #{limitEnd}
  88.             </if>
  89.         GROUP BY
  90.             date_format(team.dispatch_time, '%Y');
  91.     </select>

发表评论

表情：
评论列表 （有 0 条评论，439人围观）

还没有评论，来说两句吧...

相关阅读