获取最近7天的日期List列表

一、获取最近7天的日期List列表
import cn.hutool.core.date.DateField;
import cn.hutool.core.date.DateUtil;

/**
 * 获取最近7天的日期
 * @return List
 */
private List<LastWeekDateVo> generate7DateList(){
    List<LastWeekDateVo> list = new ArrayList<>();
    Date currentDate = new Date();
    for (int i=6; i>=1; i--){
        LastWeekDateVo dateVo = new LastWeekDateVo();
        Date newDate = DateUtil.offset(currentDate, DateField.DAY_OF_MONTH, -i);
        String formatDate = DateUtil.formatDate(newDate);
        dateVo.setDateStr(formatDate);
        list.add(dateVo);
    }
    String format1 = DateUtil.formatDate(currentDate);
    LastWeekDateVo currentDateVo = new LastWeekDateVo();
    currentDateVo.setDateStr(format1);
    list.add(currentDateVo);
    return list;
}

// LastWeekDateVo类：

@Data
public class LastWeekDateVo {

    @ApiModelProperty(value = "最新7天的日期")
    private String dateStr;

}

二、MySQL中获取最近7天的数据

SELECT * FROM `test_log` log
　　AND DATE_FORMAT(log.create_time, '%Y-%m-%d')>= NOW() - INTERVAL 7 DAY
　　ORDER BY log.create_time ASC