/** * 传入的是年-月的时间格式(2018-04) */
public void getMaxDay(String time){
String[] time = selectTime.split("-"); String addTime = String.valueOf(getDaysByYearMonth(Integer.valueOf(time[0]), Integer.valueOf(time[1]))); String startTime = selectTime + "-01" + " 00:00:00"; String endTime = selectTime + "-" + addTime + " 23:59:59";
}
/** * 根据年 月 获取对应的月份的最大天数,用来进行月报的时间段的拼接 */ public int getDaysByYearMonth(int year, int month) { Calendar a = Calendar.getInstance(); a.set(Calendar.YEAR, year); a.set(Calendar.MONTH, month - 1); a.set(Calendar.DATE, 1); a.roll(Calendar.DATE, -1); int maxDate = a.get(Calendar.DATE); return maxDate; }
startTime ,endTime 为sql语句准备的时间段