SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
        Date date = new Date();
        String nowDate = sdf.format(date);
        Calendar c = Calendar.getInstance();    
        c.add(Calendar.MONTH, 0);
        c.set(Calendar.DAY_OF_MONTH,1);//设置为1号,当前日期既为本月第一天 
        String firstDate = sdf.format(c.getTime());
        if("".equals(form.getBeginDate())||form.getBeginDate()==null){
            System.out.println("月初"+firstDate);
            form.setBeginDate(firstDate);
        }
        if("".equals(form.getEndDate())||form.getEndDate()==null){
            System.out.println("今天"+nowDate);
            form.setEndDate(nowDate);
        }
        String sql = " select count(id) from getDealerAccount("+form.getBeginDate()+","+form.getEnd()+") ";
        System.out.println("报表Count"+sql);
        return this.jdbcTemplate.queryForObject(sql, Long.class);