and cce.start_time between #{param.startTime} and #{param.endTime}
具体需求:求未来几天内的数据,例如未来3天内的数据,如下方法获取3天后的日期,用between and 筛选
/**
* 获取未来 第 past 天的日期
* @param past
* @return
*/
public static Date getFetureDate(int past) {
Calendar calendar = Calendar.getInstance();
calendar.set(Calendar.DAY_OF_YEAR, calendar.get(Calendar.DAY_OF_YEAR) + past);
Date today = calendar.getTime();
return today;
}