Calendar用法

Calendar的核心用法为 add方法

具体实现如下:

public static String getTwoMonthSQLFilter(String column){StringBuffer filter = new StringBuffer();Calendar previous = Calendar.getInstance();previous.add(Calendar.MONTH, -1);Calendar tom = Calendar.getInstance();tom.add(Calendar.MONTH, 1);SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-01 00:00:00");String pre = sdf.format(previous.getTime());System.out.println("preDate:" + pre);String to = sdf.format(tom.getTime());System.out.println("tom:" + to);filter.append("WHERE " + column + " >= to_date(" + pre + ",'yyyy-MM-dd HH24:mi:ss') \n");filter.append("AND " + column + " < to_date(" + to + ",'yyyy-MM-dd HH24:mi:ss') \n");return filter.toString();}

                StringBuffer sql = new StringBuffer();sql.append("/*dialect*/ SELECT j.fid,c.fnumber FROM t_cas_journal j \n");sql.append("LEFT JOIN t_org_company c ON c.fid=j.fcompanyid \n");sql.append(ExecuteEipAPIUtil.getTwoMonthSQLFilter("fbizdate"));IRowSet irs = DbUtil.executeQuery(ctx, sql.toString());