JAVA 关于时间

SELECT DATE_SUB(CURDATE(),INTERVAL 1 DAY)

查询一天前

Calendar calendar2 = Calendar.getInstance();
SimpleDateFormat sdf2 = new SimpleDateFormat("yyyyMMdd");
calendar2.add(Calendar.DATE, time);
return sdf2.format(calendar2.getTime());

查询time天后

Date xYxqjs = yjYhqEntity.getXYxqjs();
Calendar cal1 = Calendar.getInstance();
cal1.setTime(xYxqjs);
cal1.set(Calendar.HOUR_OF_DAY, 23);
cal1.set(Calendar.MINUTE, 59);
cal1.set(Calendar.SECOND, 59);
yjYhqEntity.setXYxqjs(cal1.getTime());

设置时分秒