请假功能中计算有效工作日

判断请假日期中有效工作日：排除周末及法定节日
1） 引用方法

String timeDates[] = request.getParameter("timeDate").split(",");
        String timeDate=timeDates[0]+"-"+timeDates[1]+"-"+timeDates[2];
        String timeDate2=timeDates[3]+"-"+timeDates[4]+"-"+timeDates[5];
        int  times= dayutils.weekDayCount(timeDate, timeDate2);//weekDayCoun方法支持date类型和String类型的日期传入

2）weekDayCount方法实现
首先通过配置文件配置2017年周末情况
附：weekDayConfig.xml

<?xml version="1.0" encoding="utf-8"?>
<root>
    <validation>
        <list>
            <!-- 非补报报文的交易时间必须在5个工作日内 -->
            <key>EXCH_DATE_CHECK</key>
            <value>5</value>
        </list>
        <list>
            <!-- 回执处理必须在5个工作日内 -->
            <key>REC_DATE_CHECK</key>
            <value>5</value>
        </list>
    </validation>
    <!-- 工作日是假期的情况 -->
    <weekday>
        <holiday_list>
            <date>2017-01-02</date>
            <date>2017-01-27</date>
            <date>2017-01-30</date>
            <date>2017-01-31</date>
            <date>2017-02-01</date>
            <date>2017-02-02</date>
            <date>2017-04-03</date>
            <date>2017-04-04</date>
            <date>2017-05-01</date>
            <date>2017-05-29</date>
            <date>2017-05-30</date>
            <date>2017-10-02</date>
            <date>2017-10-03</date>
            <date>2017-10-04</date>
            <date>2017-10-05</date>
            <date>2017-10-06</date>
        </holiday_list>
    </weekday>
    <!-- 周末是工作日的情况 -->
    <weekend>
        <weekday_list>
            <date>2017-01-22</date>
            <date>2017-02-04</date>
            <date>2017-04-01</date>
            <date>2017-05-27</date>
            <date>2017-09-30</date>
        </weekday_list>
    </weekend>
</root>

附：WeekdayVO.java

package com.buss.common;

import java.util.List;
import java.util.Map;

public class WeekdayVO {

    private Map validateMap;//工作日校验
    private List weekendIsWeekdayList;//周末是工作日的列表
    private List weekdayIsHolidayList;//工作日是假期的列表


    public Map getValidateMap() {
        return validateMap;
    }
    public void setValidateMap(Map validateMap) {
        this.validateMap = validateMap;
    }
    public List getWeekendIsWeekdayList() {
        return weekendIsWeekdayList;
    }
    public void setWeekendIsWeekdayList(List weekendIsWeekdayList) {
        this.weekendIsWeekdayList = weekendIsWeekdayList;
    }
    public List getWeekdayIsHolidayList() {
        return weekdayIsHolidayList;
    }
    public void setWeekdayIsHolidayList(List weekdayIsHolidayList) {
        this.weekdayIsHolidayList = weekdayIsHolidayList;
    }


}

附：WeekDayUtil.java

package com.buss.common;

import java.io.File;
import java.net.URL;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
import java.util.GregorianCalendar;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;

import org.dom4j.Document;
import org.dom4j.Element;
import org.dom4j.io.SAXReader;

public class WeekDayUtil {

    private final static String BASE_PATH = "/classes/resources/";

    /**
     * @title 获取工作日相关配置
     * @author chanson
     * @return
     */
    public WeekdayVO getWeekdayConfig(){

        Map validateMap = new HashMap();
        List weekendIsWeekdayList = new ArrayList();
        List weekdayIsHolidayList = new ArrayList();

        //web相对路径+xml文件路径
        //1、放到web工程
        File f = new File("WEB-INF/classes/weekDayConfig.xml");
        //File f = new File("D:/apache-tomcat-7.0.33/apache-tomcat-7.0.33/webapps/lzhrms/WEB-INF/classes/weekDayConfig.xml");
        String path=f.getAbsolutePath().toString();
        String  path1[]=path.split("bin");
        path1[0]=path1[0].replaceAll("\\\\","/");
        String  p=path1[0]+"webapps/lzhrms/WEB-INF/classes/weekDayConfig.xml";
        f = new File(p);
        //2、application测试
        //String file  = "D:/workspace/test/src/config/weekday.xml";
        //File f = new File(file);
        SAXReader reader = new SAXReader();
        try{
            Document doc = reader.read(f);
            Element root = doc.getRootElement();

            //===================================
            //工作日校验相关属性
            //===================================
            Element validationElement = root.element("validation");
            Element listElement;
            for(Iterator i = validationElement.elementIterator("list");i.hasNext();){
                listElement = (Element)i.next();
                validateMap.put((String) listElement.elementText("key"), 
                        (String)listElement.elementText("value"));
            }

            //===================================
            //工作日是假期的列表
            //===================================
            Element weekdayElement = root.element("weekday");
            Element holidayListElement = weekdayElement.element("holiday_list");
            Element holidayValueElement = null;
            for(Iterator i = holidayListElement.elementIterator("date");i.hasNext();){
                holidayValueElement = (Element)i.next();
                weekdayIsHolidayList.add((String)holidayValueElement.getText());
            }

            //===================================
            //周末是工作日的列表
            //===================================
            Element weekendElement = root.element("weekend");
            Element weekdayListElement = weekendElement.element("weekday_list");
            Element weekdayValueElement = null;
            for(Iterator i = weekdayListElement.elementIterator("date");i.hasNext();){
                weekdayValueElement = (Element)i.next();
                weekendIsWeekdayList.add((String)weekdayValueElement.getText());
            }

            WeekdayVO vo = new WeekdayVO();
            vo.setValidateMap(validateMap);
            vo.setWeekdayIsHolidayList(weekdayIsHolidayList);
            vo.setWeekendIsWeekdayList(weekendIsWeekdayList);
            return vo;
        }catch(Exception e){
            e.printStackTrace();
            return null;
        }
    }

     /** 
     * @title 判断是否为工作日 
     * @detail 工作日计算: 
     *           1、正常工作日，并且为非假期 
     *           2、周末被调整成工作日 
     * @author yy 
     * @param date 日期 
     * @return 是工作日返回true，非工作日返回false 
     */
    public static boolean isWeekday(Date time){  
        WeekDayUtil util = new WeekDayUtil();  
        WeekdayVO vo = util.getWeekdayConfig();  
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
        Calendar c = Calendar.getInstance();
        c.setTime(time);

        if (c.get(GregorianCalendar.DAY_OF_WEEK) != GregorianCalendar.SATURDAY  
                && c.get(GregorianCalendar.DAY_OF_WEEK) != GregorianCalendar.SUNDAY){  
            //平时  
            return !vo.getWeekdayIsHolidayList().contains(sdf.format(time));  
        }else{  
            //周末  
            return vo.getWeekendIsWeekdayList().contains(sdf.format(time));  
        }  
    }

    /** 
     * @title 判断是否为工作日 
     * @detail 工作日计算: 
     *           1、正常工作日，并且为非假期 
     *           2、周末被调整成工作日 
     * @author yy 
     * @param String 日期 
     * @return 是工作日返回true，非工作日返回false 
     */
    public static boolean isWeekday(String timeStr){ 
        WeekDayUtil util = new WeekDayUtil();  
        WeekdayVO vo = util.getWeekdayConfig();  
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
        Calendar c = Calendar.getInstance();
        boolean weekday=false;
        try {
            c.setTime(sdf.parse(timeStr));
            if (c.get(GregorianCalendar.DAY_OF_WEEK) != GregorianCalendar.SATURDAY  
                    && c.get(GregorianCalendar.DAY_OF_WEEK) != GregorianCalendar.SUNDAY){  
                //平时  
                weekday= !vo.getWeekdayIsHolidayList().contains(timeStr);
            }else{  
                //周末  
                weekday= vo.getWeekendIsWeekdayList().contains(timeStr);  
            }
        } catch (ParseException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return weekday;
    }

    /** 
     * @title 获取当前月工作日天数
     * @detail 工作日计算: 
     *           1、获取月份总天数 
     *           2、循环每天，判断是否为工作日
     * @author yy
     * @param String 日期月份(2017-01) 
     * @return int 天数
     */
    public static int monthWeekDaySum(String timeStr){
        int count = 0;
        int month = Integer.parseInt(timeStr.substring(5, 7));
        Calendar c = Calendar.getInstance();

        c.set(Calendar.YEAR, Integer.parseInt(timeStr.substring(0, 4)));
        c.set(Calendar.MONTH,  month - 1);
        c.set(Calendar.DATE, 1);

        while(c.get(Calendar.MONTH) < month){
            if(isWeekday(c.getTime())){
                count++;
            }
            c.add(Calendar.DATE, 1);
        }

        return count;
    }

    /** 
     * @title 获取当前月工作日天数
     * @detail 工作日计算: 
     *           1、获取月份总天数 
     *           2、循环每天，判断是否为工作日
     *           3、判断时使用工作日和XML两种方式结合
     * @author yy
     * @param Date 日期月份
     * @return int 天数
     */
    public static int monthWeekDaySum(Date time){
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM");
        return monthWeekDaySum(sdf.format(time));
    }

    /** 
     * @title 计算两个时间内工作日天数
     * @detail 工作日计算 (包含开始时间以及结束时间)
     * @author yy
     * @param Date 开始时间   Date 结束时间
     * @return int 天数
     */
    public static int weekDayCount(Date startTime,Date endTime){
         Calendar sc = Calendar.getInstance();
         sc.setTime(startTime);

         Calendar ec = Calendar.getInstance();
         ec.setTime(endTime);

         SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
         int count=0;
         while(sc.getTime().before(ec.getTime())){
            if(isWeekday(sc.getTime())){
                count++;
            }
            sc.add(Calendar.DATE, 1);
         }
         if(isWeekday(sc.getTime())){
             count++;
         }

        return count;
    }

    /** 
     * @title 计算两个时间内工作日天数
     * @detail 工作日计算 (包含开始时间以及结束时间)
     * @author yy
     * @param String 开始时间   String 结束时间  格式:yyyy-MM-dd
     * @return int 天数
     */
    public static int weekDayCount(String startTime,String endTime){
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
        Date start;
        Date end;
        int count=0;
        try {
            start=sdf.parse(startTime);
            end = sdf.parse(endTime);
            count=weekDayCount(start,end);
        } catch (ParseException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return count;
    }

    /**
     * 判断当前日期是星期几
     * 
     * @param pTime 修要判断的时间
     * @return dayForWeek 判断结果
     * @Exception 发生异常
     */
     public static int dayForWeek(String pTime) throws Exception {
          SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
          Calendar c = Calendar.getInstance();
          c.setTime(format.parse(pTime));
          int dayForWeek = 0;
          if(c.get(Calendar.DAY_OF_WEEK) == 1){
           dayForWeek = 7;
          }else{
           dayForWeek = c.get(Calendar.DAY_OF_WEEK) - 1;
          }
          return dayForWeek;
     }

    public static void main(String[] args) throws Exception {
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
        System.out.println(weekDayCount(sdf.parse("2017-10-01"),sdf.parse("2017-10-10")));
//      System.out.println(weekDayCount("2017-10-01","2017-10-10"));

//      System.out.println(dayForWeek("2017-06-03"));
//      System.out.println(isWeekday("2017-10-04"));
//      System.out.println(monthWeekDaySum(new Date()));
    }

}