1、偷懒直接贴代码，方便下次使用：

  /**
     * .Description://根据字符日期返回星期几
     * .Author:麦克劳林
     * .@Date: 2018/12/29
     */
    public String getWeek(String dateTime){
        String week = "";
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
        try {
            Date date = sdf.parse(dateTime);
            SimpleDateFormat dateFm = new SimpleDateFormat("EEEE");
            week = dateFm.format(date);
            week=week.replaceAll("星期","周");
        }catch (ParseException e){
            e.printStackTrace();
        }
        return week;
    }

    /**
     * 获取过去7天内的日期数组
     * @param intervals      intervals天内
     * @return              日期数组
     */
    public ArrayList<String> getDays(int intervals) {
        ArrayList<String> pastDaysList = new ArrayList<>();
        for (int i = intervals -1; i >= 0; i--) {
            pastDaysList.add(getPastDate(i));
        }
        return pastDaysList;
    }
    /**
     * 获取过去第几天的日期
     * @param past
     * @return
     */
    public String getPastDate(int past) {
        Calendar calendar = Calendar.getInstance();
        calendar.set(Calendar.DAY_OF_YEAR, calendar.get(Calendar.DAY_OF_YEAR) - past);
        Date today = calendar.getTime();
        SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
        String result = format.format(today);
        return result;
    }

2、SQL根据日期查询某天数据

  select * from table_name where date_format(create_date,'%Y-%m-%d') = '2018-12-29';
   <!-- 查询某一月数据-->
  select *from table_name  where year(create_date) = '2018' and month(create_date) =  '12';

1、补全给定起止时间区间内的所有日期

/**
 * 补全给定起止时间区间内的所有日期
 * @param startTime
 * @param endTime
 * @param isIncludeStartTime
 * @return
 */
public static List<String> getBetweenDates(String startTime, String endTime,boolean isIncludeStartTime){
    List<String> result = new ArrayList<>();
    try {
        SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
        Date d1 = new SimpleDateFormat("yyyy-MM-dd").parse(startTime);//定义起始日期
        Date d2 = new SimpleDateFormat("yyyy-MM-dd").parse(endTime);//定义结束日期  可以去当前月也可以手动写日期。
        Calendar dd = Calendar.getInstance();//定义日期实例
        dd.setTime(d1);//设置日期起始时间
        if(isIncludeStartTime) {
            result.add(format.format(d1));
        }
        while (dd.getTime().before(d2)) {//判断是否到结束日期
            dd.add(Calendar.DATE, 1);//进行当前日期加1
            SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
            String str = sdf.format(dd.getTime());
            result.add(str);
            System.out.println(str);
        }
    }catch (Exception e) {
        e.printStackTrace();
    }

    return result;
}

2、 补全给定起止时间区间内的所有周(年份-周)

/**
 * 补全给定时间内的所有周，包含最开始的
 * @param startTime
 * @param endTime
 * @return
 */
public static ArrayList<String> getWeeksBetweenDates(String startTime,String endTime) {
    ArrayList<String> result = new ArrayList<>();
    SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
    Date start = null;
    Date end = null;
    try {
        start = format.parse(startTime);
        end = format.parse(endTime);
        Calendar calendar = Calendar.getInstance();
        calendar.setFirstDayOfWeek(Calendar.MONDAY);
        calendar.setTime(start);
        result.add(calendar.get(Calendar.YEAR) + "-" + calendar.get(Calendar.WEEK_OF_YEAR));
        while(calendar.getTime().before(end)) {
            calendar.add(Calendar.WEEK_OF_YEAR, 1);
            String weekStr = calendar.get(Calendar.YEAR) + "-" + calendar.get(Calendar.WEEK_OF_YEAR);
            result.add(weekStr);
        }
    } catch (ParseException e) {
        e.printStackTrace();
    }

    return result;
}

3、补全给定起止时间区间内的所有月份

/**
 * 补全给定时间区内的所有月份
 * @param startTime
 * @param endTime
 * @return
 */
public static List<String> getMonthsBetweenDates(String startTime,String endTime) {
    List<String> result = new ArrayList<>();
    try{
        SimpleDateFormat format = new SimpleDateFormat("yyyy-MM");
        Date d1 = new SimpleDateFormat("yyyy-MM").parse(startTime);//定义起始日期
        Date d2 = new SimpleDateFormat("yyyy-MM").parse(endTime);//定义结束日期  可以去当前月也可以手动写日期。
        Calendar dd = Calendar.getInstance();//定义日期实例
        dd.setTime(d1);//设置日期起始时间
        result.add(format.format(d1));
        while (dd.getTime().before(d2)) {//判断是否到结束日期
            dd.add(Calendar.MONTH, 1);//进行当前日期月份加1
            SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM");
            String str = sdf.format(dd.getTime());
            result.add(str);
        }
    }catch (Exception e){
        e.printStackTrace();
    }

    return result;
}

4、最近一周的所有日期

/**
 * 最近一周的所有日期
 * @return
 */
public static List<String> getNearlyWeekDates() {
    SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
    Calendar c = Calendar.getInstance();
    //过去七天
    c.setTime(new Date());
    String today = format.format(new Date());
    c.add(Calendar.DATE, - 7);
    Date d = c.getTime();
    String day = format.format(d);
    List<String> result = getBetweenDates(day,today,false);

    return result;
}

5、最近一个月的所有日期

/**
 * 最近一个月的所有日期
 * @return
 */
public static List<String> getNearlyMonthDates() {
    SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
    Calendar c = Calendar.getInstance();
    //过去一月
    c.setTime(new Date());
    String today = format.format(new Date());
    c.add(Calendar.MONTH, -1);
    Date m = c.getTime();
    String mon = format.format(m);
    List<String> result = getBetweenDates(mon,today,false);

    return result;
}

6、最近一年的所有月份

/**
 * 最近一年的所有月份
 * @return
 */
public static List<String> getNearlyYearDates() {
    SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
    Calendar c = Calendar.getInstance();
    //过去一年
    c.setTime(new Date());
    String today = format.format(new Date());
    c.add(Calendar.MONTH, -11);
    Date y = c.getTime();
    String year = format.format(y);
    //如果要获取近一年内的所有日期则，调用getBetweenDates()方法
    List<String> result = getMonthsBetweenDates(year,today);

    return result;
}

7、运行

public static void main(String[] args) {
    List<String> result1 = getBetweenDates("2019-11-01","2019-11-12",true);
    System.out.println("年-月-日："+result1);
    List<String> result2 = getMonthsBetweenDates("2019-09-01","2019-11-12");
    System.out.println("年-月："+result2);
    ArrayList<String> result = getWeeksBetweenDates("2019-1-1","2019-11-12");
    System.out.println("周："+result.toString());
    List<String> result3 = getNearlyWeekDates();
    System.out.println("最近一周："+result3.toString());
    List<String> result4 = getNearlyMonthDates();
    System.out.println("最近一月："+result4.toString());
    List<String> result5 = getNearlyYearDates();
    System.out.println("最近一年："+result5.toString());
}

运行结果：

年-月-日：
[2019-11-01, 2019-11-02, 2019-11-03, 2019-11-04, 2019-11-05, 2019-11-06, 
2019-11-07, 2019-11-08, 2019-11-09, 2019-11-10, 2019-11-11, 2019-11-12]

年-月：
[2019-09, 2019-10, 2019-11]

周：指的是一年内的第多少周
[2019-1, 2019-2, 2019-3, 2019-4, 2019-5, 2019-6, 2019-7, 2019-8, 2019-9, 2019-10, 
2019-11, 2019-12, 2019-13, 2019-14, 2019-15, 2019-16, 2019-17, 2019-18, 2019-19, 2019-20,
2019-21, 2019-22, 2019-23, 2019-24, 2019-25, 2019-26, 2019-27, 2019-28, 2019-29, 2019-30,
2019-31, 2019-32, 2019-33, 2019-34, 2019-35, 2019-36, 2019-37, 2019-38, 2019-39, 2019-40,
2019-41, 2019-42, 2019-43, 2019-44, 2019-45, 2019-46]

最近一周：
[2019-11-14, 2019-11-15, 2019-11-16, 2019-11-17, 2019-11-18, 2019-11-19, 2019-11-20]

最近一月：
[2019-10-21, 2019-10-22, 2019-10-23, 2019-10-24, 2019-10-25, 2019-10-26, 2019-10-27, 
2019-10-28, 2019-10-29, 2019-10-30, 2019-10-31, 2019-11-01, 2019-11-02, 2019-11-03, 
2019-11-04, 2019-11-05, 2019-11-06, 2019-11-07, 2019-11-08, 2019-11-09, 2019-11-10, 
2019-11-11, 2019-11-12, 2019-11-13, 2019-11-14, 2019-11-15, 2019-11-16, 2019-11-17, 
2019-11-18, 2019-11-19, 2019-11-20]

最近一年：
[2018-12, 2019-01, 2019-02, 2019-03, 2019-04, 2019-05, 2019-06, 2019-07, 2019-08, 
2019-09, 2019-10, 2019-11]