java mysql 周_java怎么查询数据库一周内的记录

tab1.setNumRows(0);Calendarca=Calendar.getInstance();//获取Calendar实例Datedate2=newDate();SimpleDateFormatdateFormat=newSimpleDateFormat("yyyy-MM-dd");Strings_date=dateF...

tab1.setNumRows(0);

Calendar ca= Calendar.getInstance();//获取Calendar实例

Date date2 = new Date();

SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");

String s_date = dateFormat.format(date2);

try {

ca.setTime(DateFormat.getDateInstance().parse(s_date));

b=ca.get(ca.DAY_OF_YEAR);

} catch (ParseException e1) {

e1.printStackTrace();

}

int month[] = null;

String[] monthdate=null;

for(int s=0;s<=num;s++){

try {

ca.setTime(DateFormat.getDateInstance().parse(String(a[s][2])));

month[s]=ca.get(ca.DAY_OF_YEAR);

System.out.println(month[s]);

} catch (ParseException e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

}

for(int s=0;s<=num;s++){

if(b-month[s]<=30){

monthdate[s]=(java.lang.String) a[s][2];

}

}

我想从数据库取出日期与当天相减，然后重新查询刷新TABEL

却出现错误

Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException

at java.text.SimpleDateFormat.parse(SimpleDateFormat.java:1380)

at java.text.DateFormat.parse(DateFormat.java:355)

at load.Business$3.actionPerformed(Business.java:216)

展开