JAVA 节假日 判断和配置.docx

import java.io.File;import java.io.FileInputStream;import java.io.FileNotFoundException;import java.io.IOException;import java.net.MalformedURLException;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.List;import org.apache.poi.hssf.usermodel.HSSFCell;import org.apache.poi.hssf.usermodel.HSSFDateUtil;import org.apache.poi.hssf.usermodel.HSSFRow;import org.apache.poi.hssf.usermodel.HSSFSheet;import org.apache.poi.hssf.usermodel.HSSFWorkbook;**********日期加一天***********DateFormat?? format=new?? SimpleDateFormat(yyyy-MM-dd);???Calendar?? calendar=Calendar.getInstance();???calendar.setTime(mdefSetting.getDate());???calendar.add(Calendar.DAY_OF_MONTH,1); mdefs.setName(format.format(calendar.getTime())+ 至 +mdefSetting2.getDate());说明：以上代码来源于实际项目。?????????? mdefSetting.getDate());??? 为 Date型?????????? format.format(calendar.getTime()) 便是加 一天后的 时间，，，也为Date型**********日期加一天***********public class Festival {private final String FILE_NAME = 节假日.xls;private ListDate festival = new ArrayListDate();//节假日private ListDate workDay = new ArrayListDate();//工作日public Festival(){?? File excel = this.getExcel();???? try {?????? FileInputStream fin = new FileInputStream(excel);??? HSSFWorkbook hssfworkbook = new HSSFWorkbook(fin);??? HSSFSheet sheet = hssfworkbook.getSheetAt(0);??? int last = sheet.getLastRowNum();??? int index = 1;??? Date dt = null;??? while(index=last){???? HSSFRow row = sheet.getRow(index);???????? /*读取法定节假日*/???? HSSFCell cell = row.getCell((short)0);???? if(cell!=null){?????????? if(HSSFDateUtil.isCellDateFormatted(cell)){?????? dt = HSSFDateUtil.getJavaDate(cell.getNumericCellValue());?????? if(dt!=nulldt.getTime()0){??????? this.festival.add(dt);?????? }????? }????????? }???????? /*读取特殊工作日*/???? cell = row.getCell((short)1);???????? if(cell!=null){?????????? if(HSSFDateUtil.isCellDateFormatted(cell)){?????? dt = HSSFDateUtil.getJavaDate(cel