Date

date + X周

Calendar calendar = Calendar.getInstance();
calendar.add(Calendar.WEEK_OF_YEAR, X);


//eg: 今天+10周
Date date = new Date();
Calendar calendar = Calendar.getInstance();
calendar.setTime(date);
calendar.add(Calendar.WEEK_OF_YEAR, 10);

前端根据时间查询

• requestParam方式

@RequestParam(value = "startDate", required = false)@DateTimeFormat(pattern = "yyyy-MM-dd") Date startDate,
@RequestParam(value = "endDate", required = false)@DateTimeFormat(pattern = "yyyy-MM-dd") Date endDate)

• 查询参数对象

class Param {
    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
    private Date createTimeStart;

    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
    private Date createTimeEnd;


    public Date getCreateTimeStart() {
        if (null == createTimeStart) {
            return null;
        }
        try {
            SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
            SimpleDateFormat sdfSearch = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
            return sdfSearch.parse(sdf.format(createTimeStart) + " 00:00:00");
        } catch (Exception e) {
            e.printStackTrace();
            return null;
        }

    }

    public Date getCreateTimeEnd() {
        if (null == createTimeEnd) {
            return null;
        }
        try {
            SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
            SimpleDateFormat sdfSearch = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
            return sdfSearch.parse(sdf.format(createTimeEnd) + " 23:59:59");
        } catch (Exception e) {
            e.printStackTrace();
            return null;
        }
    }
}

• 查询对象

class XXX {
    @ApiModelProperty(value = "创建时间")
    @TableField(typeHandler = MyDateTypeHandler.class, fill = FieldFill.INSERT)
    private Date createTime;
}

• Java 查询语句

if (arrivalDetailParam.getCreateTimeStart() != null) {
    queryWrapper.ge(XXX::getCreateTime, param.getCreateTimeStart().getTime());
}
if (arrivalDetailParam.getCreateTimeEnd() != null) {
    queryWrapper.le(XXX::getCreateTime, param.getCreateTimeEnd().getTime());
}