java时间查询

谢谢蟹黄堡

于 2023-07-28 18:49:52 发布

阅读量86

点赞数

文章标签： java

本文链接：https://blog.csdn.net/qq_38978882/article/details/131986302

版权

@Data
@Builder
@ApiModel(value = "样本")
@TableName(value = "sample")
public class Sample {
    @TableId(value = "id", type = IdType.AUTO)
    @ApiModelProperty(value = "主键")
    private Long id;
     @ApiModelProperty(value = "访问时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date startTime;
   
    @ApiModelProperty(value = "应用")
    private String app;

 }

@Data
@Builder
public class SampleQuery {

    @ApiModelProperty(value = "应用")
    private String app;

    @ApiModelProperty(value = "访问开始时间")
    private String startTime;
    @ApiModelProperty(value = "访问结束时间")
    private String endTime;
}




LambdaQueryWrapper<ExLineSample> queryWrapper = new LambdaQueryWrapper();

if (ObjectUtil.isNotEmpty(queryParam.getStartTime())) {
    queryWrapper.ge(Sample::getStartTime, queryParam.getStartTime());
}

if (ObjectUtil.isNotEmpty(queryParam.getEndTime())) {
    queryWrapper.le(Sample::getEndTime, queryParam.getEndTime());
}