先得到上个月25日的日期,然后在数据库用between查出该日期到今天这段时间的数据,如下:
java.util.Calendar cal=java.util.Calendar.getInstance();
cal.set(Calendar.DATE,24);
java.util.Date d1=cal.getTime();
java.text.SimpleDateFormat sdf=new java.text.SimpleDateFormat("yyyy-MM-dd");
int month=cal.get(Calendar.MONTH);
if(month<=0)
cal.set(Calendar.MONTH,11);
else
cal.set(Calendar.MONTH, cal.get(Calendar.MONTH) - 1);
cal.set(Calendar.DATE,25);
java.util.Date d2=cal.getTime();
System.out.println(sdf.format(d2));
System.out.println(sdf.format(d1));
然后在数据库中用sql语句如下:
String sql="select * from tablename where addtime between '"+d2+"' and '"+d1+"'"
java.util.Calendar cal=java.util.Calendar.getInstance();
cal.set(Calendar.DATE,24);
java.util.Date d1=cal.getTime();
java.text.SimpleDateFormat sdf=new java.text.SimpleDateFormat("yyyy-MM-dd");
int month=cal.get(Calendar.MONTH);
if(month<=0)
cal.set(Calendar.MONTH,11);
else
cal.set(Calendar.MONTH, cal.get(Calendar.MONTH) - 1);
cal.set(Calendar.DATE,25);
java.util.Date d2=cal.getTime();
System.out.println(sdf.format(d2));
System.out.println(sdf.format(d1));
然后在数据库中用sql语句如下:
String sql="select * from tablename where addtime between '"+d2+"' and '"+d1+"'"
请问Calendar.DATE得到的是什么?