public String GetPre_5_month_startdate(String tradeMonth){
// select to_char(add_months(to_date(i_trademonth, 'yyyyMM'), -5), 'yyyyMM') || '01'
// into v_pre_5_month_startdate from dual;
final int renewalsdata = -5;
String validatetime = tradeMonth;
validatetime=validatetime+"01";
SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd");
Date tradeTime = null;
try {
tradeTime = sdf.parse(validatetime);
} catch (ParseException e) {
e.printStackTrace();
}
Calendar calendar = Calendar.getInstance();
calendar.setTime(tradeTime);
System.out.println(sdf.format(calendar.getTime()));
calendar.add(Calendar.MONTH, renewalsdata);
return sdf.format(calendar.getTime()).toString();
}
另外,String没有append函数 。一个string要赋值给一个StringBuilder的话 可以如下:
public void SaveVolumeToTemporaryTable(String tradeMonth) {
StringBuilder validatetime = new StringBuilder(tradeMonth);