查找某一天的记录
String date = new SimpleDateFormat("yyyy-MM-dd").format(makeTime);
String hql = "FROM MemberSchedule ms WHEREdate_format(ms.makeTime,'%Y-%m-%d')='" + date + "'
查找七天前的记录
String hql = "FROM MemberSchedule WHERE memberInfoId='" + memberInfoId+ "' and makeTime < CURDATE()-7 ORDER BY makeTime";