java 求前三天

前3天的数据(包括今天)
        Calendar   cal1   =   Calendar.getInstance();
        cal1.add(Calendar.DATE,-2);
        //cal1.set(2000,1,29);
        SimpleDateFormat   sdf   =   new SimpleDateFormat("yyyy-MM-


dd");  
        String towDaysBefore = sdf.format(cal1.getTime());
        
        String today = sdf.format(Calendar.getInstance().getTime());
        
        String sql = "select * from "+tableName+" where time between 


'"+towDaysBefore
                    +" and "+today;
上面的sql就是查前3天的数据(包括今天)的sql了