java-datetime类型按当天时间查询
对应的实体增加两个逻辑字段
//逻辑字段
private Date beginDate; //开始时间
private Date endDate; //结束时间
实体类都是DATE类型
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
/** * 获取首页今日采集数量 * @param request * @param response * @return */ @GetMapping("collectTodyNum") public AjaxJson collectTodyNum(HttpServletRequest request, HttpServletResponse response) { HashMap<String, Integer> map = new HashMap<>(); XfRobotLog xfRobotLog = new XfRobotLog(); Date date = new Date();//实例化当天时间 try{ xfRobotLog.setBeginDate(DateUtils.getStartTime(date));//设置当天的最大时间 xfRobotLog.setEndDate(DateUtils.getEndTime(date));//设置当天的最小时间 } catch (ParseException e) { e.printStackTrace(); } int collectTodyNum=xfRobotLogService.collectTodyNum(xfRobotLog); return AjaxJson.success().put("map", map); } |
DateUtils.java 新增
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 |
/** * 获取某一天的开始时间 * @author mfg * @return yyyy-MM-dd 00:00:00.0 * @throws ParseException */ public static Date getStartTime(Date date) throws ParseException { SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); Calendar todayStart = Calendar.getInstance(); todayStart.setTime(date); todayStart.set(Calendar.HOUR_OF_DAY, 0); todayStart.set(Calendar.MINUTE, 0); todayStart.set(Calendar.SECOND, 0); todayStart.set(Calendar.MILLISECOND, 0); return sdf.parse(sdf.format(todayStart.getTime())); } /** * 获取某一天的结束时间 * @author mfg * @return yyyy-MM-dd 23:59:59.0 * @throws ParseException */ public static Date getEndTime(Date date) throws ParseException { SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); Calendar todayEnd = Calendar.getInstance(); todayEnd.setTime(date); todayEnd.set(Calendar.HOUR_OF_DAY, 23); todayEnd.set(Calendar.MINUTE, 59); todayEnd.set(Calendar.SECOND, 59); todayEnd.set(Calendar.MILLISECOND, 999); return sdf.parse(sdf.format(todayEnd.getTime())); } |
xml 新增:
1 2 3 4 5 6 |
<if test="beginDate != null and beginDate != ''"> AND a.prediction_day >= #{beginDate} </if> <if test="endDate != null and endDate != ''"> AND a.prediction_day <= #{endDate} </if> |