检索条件
@JsonFormat(pattern = "yyyy/MM/dd", timezone = "GMT+8")
@DateTimeFormat(pattern = "yyyy/MM/dd")
@ApiModelProperty("开始时间")
private Date startTime;
@JsonFormat(pattern = "yyyy/MM/dd", timezone = "GMT+8")
@DateTimeFormat(pattern = "yyyy/MM/dd")
@ApiModelProperty("结束时间")
private Date endTime;
xml设置
<if test="param.startTime != null">
and STR_TO_DATE(a.upload_time, '%Y-%m-%d') >= STR_TO_DATE(#{param.startTime}, '%Y-%m-%d')
</if>
<if test="param.endTime != null">
and STR_TO_DATE(a.upload_time, '%Y-%m-%d') <= STR_TO_DATE(#{param.endTime}, '%Y-%m-%d')
</if>