对working_date增加2012年数据

[xiejing]

working_date表的用途：

主要用于在预订资源计算预订单的有效工作日。
没有足够的天数的话就无法预订资源。所以在每一年年末需要将下一年的数据插入到该表中。

添加步骤

1.先确定测试环境和正式环境中，该表的主键是否一致。如果不一致，将测试环境的序列的开始数据修改为正式环境该表主键+1。
2.修改cn.com.pc.mis.data_convert.handy报中的InitWorkingDate文件。
1)修改基本信息

    //这里需要将area表中所有数据id都写进来，用","隔开
    static int[] areaId ={727,767,839,840,856,864,867,11,928,908,828,834,837,849,854,863,865,866,887,929,931,932,933,939,940,829,830,836,841,843,850,860,862,869,871,930,935,938,527,588,608,647,671,672,687,688,689,690,707,427,450,451,452,447,448,449,507,508,509,668,1,2,3,4,5,6,7,8,9,10,227,247,287,307,347,348,367,387,388,389,407,408,428,487,547,548,567,568,569,587,589,590,591,627,667,669,670,467,607,609,827,831,832,835,838,842,844,845,846,847,851,852,853,855,857,858,859,868,747,787,807,833,848,861,870,909,934,936,937,941};
    //插入数据的开始年份和结束年份
    static int fromYear = 2012;
    static int toYear = 2012;

2)修改节日信息

//元旦
                cld.set(Calendar.MONTH,0);
                cld.set(Calendar.DAY_OF_MONTH,1);
                holiday.put(getFormateDate(cld.getTime()),"holiday");
                cld.set(Calendar.MONTH,0);
                cld.set(Calendar.DAY_OF_MONTH,2);
                holiday.put(getFormateDate(cld.getTime()),"holiday");
                cld.set(Calendar.MONTH,0);
                cld.set(Calendar.DAY_OF_MONTH,3);
                holiday.put(getFormateDate(cld.getTime()),"holiday");
                //春节
                cld.set(Calendar.MONTH,0);
                cld.set(Calendar.DAY_OF_MONTH,22);
                holiday.put(getFormateDate(cld.getTime()),"holiday");
                cld.set(Calendar.MONTH,0);
                cld.set(Calendar.DAY_OF_MONTH,23);
                holiday.put(getFormateDate(cld.getTime()),"holiday");
                cld.set(Calendar.MONTH,0);
                cld.set(Calendar.DAY_OF_MONTH,24);
                holiday.put(getFormateDate(cld.getTime()),"holiday");
                cld.set(Calendar.MONTH,0);
                cld.set(Calendar.DAY_OF_MONTH,25);
                holiday.put(getFormateDate(cld.getTime()),"holiday");
                cld.set(Calendar.MONTH,0);
                cld.set(Calendar.DAY_OF_MONTH,26);
                holiday.put(getFormateDate(cld.getTime()),"holiday");
                cld.set(Calendar.MONTH,0);
                cld.set(Calendar.DAY_OF_MONTH,27);
                holiday.put(getFormateDate(cld.getTime()),"holiday");
                cld.set(Calendar.MONTH,0);
                cld.set(Calendar.DAY_OF_MONTH,28);
                holiday.put(getFormateDate(cld.getTime()),"holiday");
                cld.set(Calendar.MONTH,0);
                cld.set(Calendar.DAY_OF_MONTH,29);
                holiday.put(getFormateDate(cld.getTime()),"holiday");
                //清明
                cld.set(Calendar.MONTH,3);
                cld.set(Calendar.DAY_OF_MONTH,2);
                holiday.put(getFormateDate(cld.getTime()),"holiday");
                cld.set(Calendar.MONTH,3);
                cld.set(Calendar.DAY_OF_MONTH,3);
                holiday.put(getFormateDate(cld.getTime()),"holiday");
                cld.set(Calendar.MONTH,3);
                cld.set(Calendar.DAY_OF_MONTH,4);
                holiday.put(getFormateDate(cld.getTime()),"holiday");
                //五一
                cld.set(Calendar.MONTH,4);
                cld.set(Calendar.DAY_OF_MONTH,1);
                holiday.put(getFormateDate(cld.getTime()),"holiday");
                cld.set(Calendar.MONTH,4);
                cld.set(Calendar.DAY_OF_MONTH,2);
                holiday.put(getFormateDate(cld.getTime()),"holiday");
                cld.set(Calendar.MONTH,4);
                cld.set(Calendar.DAY_OF_MONTH,3);
                holiday.put(getFormateDate(cld.getTime()),"holiday");
                 //端午
                cld.set(Calendar.MONTH,5);
                cld.set(Calendar.DAY_OF_MONTH,22);
                holiday.put(getFormateDate(cld.getTime()),"holiday");
                cld.set(Calendar.MONTH,5);
                cld.set(Calendar.DAY_OF_MONTH,23);
                holiday.put(getFormateDate(cld.getTime()),"holiday");
                cld.set(Calendar.MONTH,5);
                cld.set(Calendar.DAY_OF_MONTH,24);
                holiday.put(getFormateDate(cld.getTime()),"holiday");
                //中秋
                cld.set(Calendar.MONTH,8);
                cld.set(Calendar.DAY_OF_MONTH,30);
                holiday.put(getFormateDate(cld.getTime()),"holiday");
                //国庆
                cld.set(Calendar.MONTH,9);
                cld.set(Calendar.DAY_OF_MONTH,1);
                holiday.put(getFormateDate(cld.getTime()),"holiday");
                cld.set(Calendar.MONTH,9);
                cld.set(Calendar.DAY_OF_MONTH,2);
                holiday.put(getFormateDate(cld.getTime()),"holiday");
                cld.set(Calendar.MONTH,9);
                cld.set(Calendar.DAY_OF_MONTH,3);
                holiday.put(getFormateDate(cld.getTime()),"holiday");
                cld.set(Calendar.MONTH,9);
                cld.set(Calendar.DAY_OF_MONTH,4);
                holiday.put(getFormateDate(cld.getTime()),"holiday");
                cld.set(Calendar.MONTH,9);
                cld.set(Calendar.DAY_OF_MONTH,5);
                holiday.put(getFormateDate(cld.getTime()),"holiday");
                cld.set(Calendar.MONTH,9);
                cld.set(Calendar.DAY_OF_MONTH,6);
                holiday.put(getFormateDate(cld.getTime()),"holiday");
                cld.set(Calendar.MONTH,9);
                cld.set(Calendar.DAY_OF_MONTH,7);

3)修改数据库信息

   String sDBDriver="oracle.jdbc.driver.OracleDriver";
   sConnStr="jdbc:oracle:thin:@192.168.75.100:1521:testdb";
   conn = DriverManager.getConnection(sConnStr,"mis","******");   

4)运行该文件。
3.刚刚运行生成的数据导入到正式环境中。并且将正式环境的序列开始数据修改为导入数据最大主键+1。