mysql 日历录入

public static void main(String[] args) throws ClassNotFoundException, SQLException {
    String URL = "jdbc:mysql://127.0.0.1:3306/?allowMultiQueries=true&zeroDateTimeBehavior=convertToNull&autoReconnect=true&failOverReadOnly=false&characterEncoding=UTF-8&characterSetResults=UTF-8";
    String USER = "root";
    String PASSWORD = "123456";
    //1.加载驱动程序
    Class.forName("com.mysql.jdbc.Driver");
    //2.获得数据库链接
    Connection conn = DriverManager.getConnection(URL, USER, PASSWORD);
    //3.通过数据库的连接操作数据库，实现增删改查（使用Statement类）
    String sql="INSERT INTO tb_calendar(id,YEAR,MONTH,DAY,STATUS,WEEK,NAME,setdate)\n" +
            "VALUES(NULL,'2018','04',?,?,?,NULL,?)";
    PreparedStatement  pst=conn.prepareStatement(sql);
    SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
    //开始日期
    String  begin="2018-04-01";
    Date beginDay=null;
    try {
         beginDay=sdf.parse(begin);
    } catch (ParseException e) {
        e.printStackTrace();
    }
    Calendar c = Calendar.getInstance();
    c.setTime(beginDay);
    //获取本月天数
    int days=c.getActualMaximum(Calendar.DAY_OF_MONTH);
    String[] weekDays = {"星期日", "星期一", "星期二", "星期三", "星期四", "星期五", "星期六"};
    //获取今天是周几
    //int status=c.get
    for(int i=0;i<days;i++){
        Integer day = c.get(Calendar.DAY_OF_MONTH);
        if (day <= 9) {
            pst.setString(1,"0" + day);
        }else{
            pst.setString(1,day+"");
        }
        int index=c.get(Calendar.DAY_OF_WEEK)-1;
       if( index==0 || index==6){
            pst.setInt(2,1);
       }else{
           pst.setInt(2,0);
       }
        pst.setString(3,weekDays[c.get(Calendar.DAY_OF_WEEK)-1]);
        pst.setString(4,sdf.format(c.getTime()));
        pst.execute();
        System.out.println("插入成功");
        c.add(Calendar.DAY_OF_MONTH, 1);// 今天+1天
     }
    //关闭资源
    pst.close();
    conn.close();
}