时间查询 _输入框提示信息“开始时间”
@RequestParam(name="startTime" ,required = false) @ApiParam(value = "开始时间") @DateTimeFormat(pattern = "yyyy-MM-dd") String startTime,
@RequestParam(name="endTime" ,required = false) @ApiParam(value = "结束时间") @DateTimeFormat(pattern = "yyyy-MM-dd") String endTime
string型日期转换成date型进行查询
SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
Date date1 = null;Date data2 = null;
if (StringUtils.isNotEmpty(startTime) && StringUtils.isNotEmpty(endTime)){
date1 = format.parse(startTime);
data2 = format.parse(endTime);
}
List<PharmacyDrugVo> pharmacyDrugVoList = this.baseMapper.selectPageList(page , elderId , date1 , data2);
Mapper传入处理
List<PharmacyDrugVo> selectPageList(Page<PharmacyDrugVo> page , @Param("elderId") String elderId , @Param("date1") Date date1 , @Param("data2") Date data2);
mybatis data型日期处理
<if test="date1 != null and data2 != null ">
AND (DATE_FORMAT( a.add_time, '%Y-%m-%d') BETWEEN DATE_FORMAT( #{date1}, '%Y-%m-%d') and DATE_FORMAT( #{data2}, '%Y-%m-%d'))
</if>