实现月、季度、年的相关数据

先从前端传递相关参数：如年度传year,季度传quarter，月度传month;
后台获取到参数，根据参数来拼接不同的sql;
(季度处理采用获取当前月份，然后根据月份所属季度范围来获取季度数据)

 if (type.equals("month")){
            whereSql+=" and TO_CHAR(a.createdTime,'YYYY-MM')=TO_CHAR(SYSDATE,'YYYY-MM')";
        }
 if (type.equals("quarter")){
            Date date=new Date();
            int month=date.getMonth();
            month+=1;
            int Year=date.getYear();
            String year=String.valueOf(Year);
            if (month<=3){

                whereSql+=" and TO_CHAR(a.createdTime,'YYYY-MM')='"+year+"-01' or TO_CHAR(a.createdTime,'YYYY-MM')='"+year+"-02' or TO_CHAR(a.createdTime,'YYYY-MM')='"+year+"-03' ";
            }
            if (month>3&&month<=6){
                where