Java 在数据库中生成一年的假日与工作日信息

最近写了个在数据库中自行插入一年中假日与工作日数据的小程序，数据库表字段含有（年，月，日，日期，周几，假日标识，上一个工作日，下一个工作日），因每年的法定节假日及调休信息不同，故每一年的假日与工作日需要自行维护，改程序只需要将几个节日假期及补班的日期手动录入

package com.java;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
import java.util.List;

/**
 * Created by lime on 2016/7/31.
 */
public class InsertHolidayUtil {

    public static void main(String[] args){
        //驱动程序名
        //String driver = "com.mysql.jdbc.Driver";
        String driver = "oracle.jdbc.driver.OracleDriver";
        //要插入的数据库
        //String url = "jdbc:mysql://127.0.0.1:3306/xx_web";
        String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
        String user = "payadm";
        String password = "payadm";
        try {
            //加载驱动程序
            Class.forName(driver);
            //连接数据库
            Connection conn = DriverManager.getConnection(url, user, password);
            if(!conn.isClosed())
                System.out.println("Succeeded connecting to the Database!");
            //statement用来执行SQL语句
            Statement statement = conn.createStatement();

            SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd");
            java.util.Date start = sdf.parse("20170101");//开始时间
            java.util.Date end = sdf.parse("20171231");//结束时间
            List<Date> lists = dateSplit(start, end);

            Date nextWorkDate = sdf.parse("20180102");//下一个工作日，默认1月2日，1日为元旦
            Date lastWorkDate = sdf.parse("20171229");//上一个工作日

            if (!lists.isEmpty()) {
                for (Date date : lists) {
                    Calendar cal = Calendar.getInstance();
                    cal.setTime(date);
                    System.out.println("********插入日期:" + sdf.format(date) + "***********");

                    int year = cal.get(Calendar.YEAR);
                    int month = cal.get(Calendar.MONTH) + 1;
                    int day = cal.get(Calendar.DATE);
                    int week = cal.get(Calendar.DAY_OF_WEEK)-1;

                    String monthStr = "",dayStr = "";
                    if(month/10 == 0){
                        monthStr = "0"+String.valueOf(month);
                    }else {
                        monthStr = String.valueOf(month);
                    }
                    if(day/10 == 0){
                        dayStr = "0"+String.valueOf(day);
                    }else {
                        dayStr = String.valueOf(day);
                    }

                    lastWorkDate = getLastWorkDay(date);

                    //T_CMM_TCLD表字段：年，月，日，日期，标识（1为假日，0为工作日），周几，上一个工作日，下一个工作日
                    String insertSql = "INSERT INTO T_CMM_TCLD (CLD_YEAR, CLD_MONTH, CLD_DAY, CLD_DATE, CLD_FLG, WEEK, LAST_WK_DT, NEXT_WK_DT) " +
                            "VALUES('"+year+"','"+monthStr+"','"+dayStr+"','"+sdf.format(date)+"','"+isHoliday(date)+"','"+week+"','"+sdf.format(lastWorkDate)+"','"+sdf.format(nextWorkDate)+"')";
//                    System.out.println(year+","+monthStr+","+dayStr+","+sdf.format(date));
//                    System.out.println(insertSql);
                    statement.execute(insertSql);
                    if(isHoliday(date) == 0){
                        nextWorkDate = date;
                    }
                }
            }

            conn.close();
        }
        catch(Exception e) {
            e.printStackTrace();
        }
    }

    private static List<Date> dateSplit(Date start, Date end) throws Exception {
        if (!start.before(end))
            throw new Exception("开始时间应该在结束时间之后");
        Long spi = end.getTime() - start.getTime();
        Long step = spi / (24 * 60 * 60 * 1000);// 相隔天数

        List<Date> dateList = new ArrayList<Date>();
        dateList.add(end);
        for (int i = 1; i <= step; i++) {
            dateList.add(new Date(dateList.get(i - 1).getTime() - (24 * 60 * 60 * 1000)));// 比上一天减一
        }
        return dateList;
    }

    /**
     * 判断是否为节假日，若是返回1，否则返回0
     * @param date
     * @return
     */
    private static int isHoliday(Date date){
        Calendar cal = Calendar.getInstance();
        cal.setTime(date);
        List<String> holidays = getHolidays();
        List<String> workdays = getWorkDays();
        SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd");
//        System.out.println(sdf.format(date));
        if(((cal.get(Calendar.DAY_OF_WEEK)==Calendar.SATURDAY||cal.get(Calendar.DAY_OF_WEEK)==Calendar.SUNDAY)&&!workdays.contains(sdf.format(date))) || holidays.contains(sdf.format(date)) ) {
            return 1;
        }
        return 0;
    }

    private static Date getLastWorkDay(Date date){
        Calendar cal = Calendar.getInstance();
        cal.setTime(date);
        cal.add(Calendar.DAY_OF_MONTH,-1);
        Date dateTemp = cal.getTime();

        while (isHoliday(dateTemp) != 0){
            cal.add(Calendar.DAY_OF_MONTH,-1);
            dateTemp = cal.getTime();
        }
        return dateTemp;
    }

    private static List<String> getHolidays(){
        List<String> holidays = new ArrayList<String>();
        /*holidays.add("20170101");//元旦
        holidays.add("20170102");
        holidays.add("20170103");

        holidays.add("20170218");//春节
        holidays.add("20170219");
        holidays.add("20170220");
        holidays.add("20170221");
        holidays.add("20170222");
        holidays.add("20170223");
        holidays.add("20170224");

        holidays.add("20170404");//清明节
        holidays.add("20170405");
        holidays.add("20170406");

        holidays.add("20170429");//劳动节
        holidays.add("20170430");
        holidays.add("20170501");

        holidays.add("20170620");//端午节
        holidays.add("20170621");
        holidays.add("20170622");

        holidays.add("20170927");//中秋节

        holidays.add("20171001");//国庆节
        holidays.add("20171002");
        holidays.add("20171003");
        holidays.add("20171004");
        holidays.add("20171005");
        holidays.add("20171006");
        holidays.add("20171007");*/
        return holidays;
    }

    private static List<String> getWorkDays(){
        List<String> workDays = new ArrayList<String>();
        /*workDays.add("20170104");//补班
        workDays.add("20170215");
        workDays.add("20170228");
        workDays.add("20171010");*/
        return workDays;
    }
}

写完后发现在网上找到的2017年的节日假期及补班信息是错误的，官方还没有公布，故又注释掉，公布后可自行添加。