记录一次计算两个日期间的工作日天数，排除节假日、周末等

1.数据库存储节假日、补班日期 数据库结构如下，0代表节日，1代表补班日期，需要每年更新

2.代码 （1）计算相差天数

@Override public Long getWorkDay(String startDate, String endDate) { try { //获取所有节假日 List<String> holidayList = dateDao.getMnHoliday(0L); //获取补班日期 List<String> workdayList = dateDao.getMnHoliday(1L); List<Calendar> holiday = initHolidayList(holidayList); List<Calendar> workday = initHolidayList(workdayList); DateFormat df = new SimpleDateFormat("yyyy-MM-dd"); Calendar ca = Calendar.getInstance(); Date sd = df.parse(startDate); Date ed = df.parse(endDate); Long heaven = 0L; ca.setTime(sd); while (sd.compareTo(ed) == -1) { if (!checkHoliday(ca, holiday, workday)) { heaven++; } ca.add(Calendar.DAY_OF_MONTH,1); sd=ca.getTime(); } return heaven; } catch (Exception e) { e.printStackTrace(); } return 0L; }

（2）初始化日期

/** * 初始化日期 * @param date * @return */ public List<Calendar> initHolidayList(List<String> date) { List<Calendar> list = new ArrayList<Calendar>(); for (String string : date) { String[] da = string.split("-"); Calendar calendar = Calendar.getInstance(); calendar.set(Calendar.YEAR, Integer.valueOf(da[0])); calendar.set(Calendar.MONTH, Integer.valueOf(da[1]) - 1);// 月份比正常小1,0代表一月 calendar.set(Calendar.DAY_OF_MONTH, Integer.valueOf(da[2])); list.add(calendar); } return list; }

（3）判断是否是休息日

/** * 判断日期时候是休息日 * @param calendar 传入日期 * @param holiday 所有节假日 * @param workday 所有工作日 * @return * @throws Exception */ public static boolean checkHoliday(Calendar calendar, List<Calendar> holiday, List<Calendar> workday) throws Exception { //判断日期是否是补班日期 for (Calendar ca : workday) { if (ca.get(Calendar.MONTH) == calendar.get(Calendar.MONTH) && ca.get(Calendar.DAY_OF_MONTH) == calendar.get(Calendar.DAY_OF_MONTH) && ca.get(Calendar.YEAR) == calendar.get(Calendar.YEAR)) { return false; } } //判断日期是否是周六周日 if (calendar.get(Calendar.DAY_OF_WEEK) == Calendar.SUNDAY || calendar.get(Calendar.DAY_OF_WEEK) == Calendar.SATURDAY) { return true; } //判断日期是否是节假日 for (Calendar ca : holiday) { if (ca.get(Calendar.MONTH) == calendar.get(Calendar.MONTH) && ca.get(Calendar.DAY_OF_MONTH) == calendar.get(Calendar.DAY_OF_MONTH) && ca.get(Calendar.YEAR) == calendar.get(Calendar.YEAR)) { return true; } } return false; }