实例如下:
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);