1:calendar类
Calendar cal = Calendar.getInstance();
cal.add(Calendar.DATE, -1);
String yesterday = new SimpleDateFormat( "yyyy-MM-dd ").format(cal.getTime());
2:DateUtils
Date backupTime=DateUtils.addDays(new Date(), -1);
3:mysql语句
select * from table where to_days(now()) - to_days(creatday)=1