spring boot时间区间查询

最新推荐文章于 2024-06-26 13:58:47 发布

djq8080

最新推荐文章于 2024-06-26 13:58:47 发布

阅读量3.7k

点赞数 1

文章标签： java

本文链接：https://blog.csdn.net/djq8080/article/details/106012766

版权

1.controller

@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

2.service
//列表查询

  IPage<MeetingManagement> pageList(Page<MeetingManagement> page , String conferenceTheme , String startTime , String endTime);

3.imp
//列表查询

   @Override
    public IPage<MeetingManagement> pageList(Page<MeetingManagement> page, String conferenceTheme, String startTime, String endTime) {
        DateFormat format = new SimpleDateFormat("yyyy-MM-dd");
        Date date1 = null;Date data2 = null;
        try {
            date1 = format.parse(startTime);
            data2 = format.parse(endTime);
        } catch (ParseException e) {
            e.printStackTrace();
        }
        List<MeetingManagement> managementList = this.baseMapper.selectPageInfo( conferenceTheme, date1, data2);
        if(CollectionUtils.isNotEmpty(managementList)) {
            return page.setRecords(managementList);
        }else {
            return page.setRecords(new ArrayList<>());
        }
    }

4.mapper
//列表查询

List<MeetingManagement> selectPageInfo( @Param("conferenceTheme") String conferenceTheme,@Param("startTime") Date startTime, @Param("endTime") Date endTime)

5.mapper.xml

<if test="startTime != null and endTime != null ">
    AND (DATE_FORMAT( t1.release_time, '%Y-%m-%d') BETWEEN DATE_FORMAT( #{startTime}, '%Y-%m-%d') and DATE_FORMAT( #{endTime}, '%Y-%m-%d'))
</if>