public void printCalendarByID(HttpServletRequest request, HttpServletResponse response)
            throws SQLException, IOException {
        String id = request.getParameter("id");
        CRSManager c = new CRSManager();
        if(!id.equals("")){

            if(c.isCorrectID(dbcon,id)){


            printTop(request,response);
            PrintWriter out = response.getWriter();
            Date d2 = c.getMaxDate(dbcon, id);
            Date d1 = c.getMinDate(dbcon, id);

            GregorianCalendar gc1 = new GregorianCalendar();
            GregorianCalendar gc2 = new GregorianCalendar();
            GregorianCalendar begin = new GregorianCalendar();
            gc1.setTime(d1);
            gc2.setTime(d2);
            gc1.set(Calendar.DAY_OF_MONTH,1);
            SimpleDateFormat monthfrmt = new SimpleDateFormat("MMMM");
            SimpleDateFormat dayfrmt = new SimpleDateFormat("");
                int endday = gc2.get(Calendar.DAY_OF_MONTH);


            for(;!gc1.equals(gc2); gc1.add(Calendar.DAY_OF_MONTH,1)){

                if(gc1.get(Calendar.DAY_OF_MONTH)==1){
                    out.println("<br><center><h3>"+monthfrmt.format(gc1.getTime())+"</h3></center>");
                    out.println("<center><table width=\"900\" border=\"2\"cellpadding=\"4\">\n" +
                            "  <tr>\n" +
                            "    <td><center>Monday</center></td>\n" +
                            "    <td><center>Tuesday</center></td>\n" +
                            "    <td><center>Wednesday</center></td>\n" +
                            "    <td><center>Thursday</center></td>\n" +
                            "    <td><center>Friday</center></td>\n" +
                            "  </tr>");
                    if((gc1.get(Calendar.DAY_OF_WEEK)==Calendar.MONDAY)){
                        int day = gc1.get(Calendar.DAY_OF_MONTH);
                        if(day!=1){
                            day = day-1;
                        }
                    out.println("<tr><td height=\"100\"valign=\"top\"><center>"+day+"</center></td>");
                } else if(gc1.get(Calendar.DAY_OF_WEEK)==Calendar.TUESDAY){
                        int day = gc1.get(Calendar.DAY_OF_MONTH);
                        if(day!=1){
                            day = day-1;
                        }
                    out.println("<td height=\"100\"valign=\"top\"></td><td height=\"100\"valign=\"top\"><center>"+day+"</center></td>");
                } else if(gc1.get(Calendar.DAY_OF_WEEK)==Calendar.WEDNESDAY){
                        int day = gc1.get(Calendar.DAY_OF_MONTH);
                        if(day!=1){
                            day = day-1;
                        }
                    out.println("<td height=\"100\"valign=\"top\"></td><td height=\"100\"valign=\"top\"></td>" +
                            "<td height=\"100\"valign=\"top\"><center>"+day+"</center></td>");
                } else if(gc1.get(Calendar.DAY_OF_WEEK)==Calendar.THURSDAY){
                        int day = gc1.get(Calendar.DAY_OF_MONTH);
                        if(day!=1){
                            day = day-1;
                        }
                    out.println("<td height=\"100\"valign=\"top\"></td><td height=\"100\"valign=\"top\"></td>" +
                            "<td height=\"100\"valign=\"top\"></td><td height=\"100\"valign=\"top\"><center>"+day+"</center></td>");
                } else if(gc1.get(Calendar.DAY_OF_WEEK)==Calendar.FRIDAY){
                        int day = gc1.get(Calendar.DAY_OF_MONTH);
                        if(day!=1){
                            day = day-1;
                        }
                    out.println("<td height=\"100\"valign=\"top\"></td>" +
                            "<td height=\"100\"valign=\"top\"></td>" +
                            "<td height=\"100\"valign=\"top\"></td>" +
                            "<td height=\"100\"valign=\"top\"></td>" +
                            "<td height=\"100\"valign=\"top\"><center>"+day+"</center></td>");
                    }


                } else if(gc1.get(Calendar.DAY_OF_MONTH)==31){
                    out.println("</center></table>");
                } else if(gc1.get(Calendar.DAY_OF_MONTH)==30){
                          out.println("</center></table>");
                } else if(gc1.get(Calendar.DAY_OF_MONTH)==29){
                    out.println("</center></table>");
                } else if(gc1.get(Calendar.DAY_OF_MONTH)==28){
                    out.println("</center></table>");


                

                }
                else if(gc1.get(Calendar.DAY_OF_WEEK)==Calendar.MONDAY){
                    out.println("<tr><td height=\"100\"valign=\"top\"><center>"+gc1.get(Calendar.DAY_OF_MONTH)+"</center></td>");
                } else if(gc1.get(Calendar.DAY_OF_WEEK)==Calendar.TUESDAY){
                    out.println("<td height=\"100\"valign=\"top\"><center>"+gc1.get(Calendar.DAY_OF_MONTH)+"</center></td>");
                } else if(gc1.get(Calendar.DAY_OF_WEEK)==Calendar.WEDNESDAY){
                    out.println("<td height=\"100\"valign=\"top\"><center>"+gc1.get(Calendar.DAY_OF_MONTH)+"</center></td>");
                } else if(gc1.get(Calendar.DAY_OF_WEEK)==Calendar.THURSDAY){
                    out.println("<td height=\"100\"valign=\"top\"><center>"+gc1.get(Calendar.DAY_OF_MONTH)+"</center></td>");
                } else if(gc1.get(Calendar.DAY_OF_WEEK)==Calendar.FRIDAY){
                    out.println("<td height=\"100\"valign=\"top\"><center>"+gc1.get(Calendar.DAY_OF_MONTH)+"</center></td></tr>");
                }






            }
            printBottom(request,response);



            } else {
               printTop(request,response);
            PrintWriter out = response.getWriter();
            out.println("<span class=\"message\">You entered an invalid ID number please go back</span>");
            printBottom(request,response); 

            }
    } else {
            printTop(request,response);
            PrintWriter out = response.getWriter();
            out.println("<span class=\"message\">You entered an invalid ID number please go back</span>");
            printBottom(request,response);
        }

        }