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);
            SimpleDateFormat sf = new SimpleDateFormat("MMMM");
            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);


            for(;!gc1.equals(gc2); gc1.set(Calendar.DAY_OF_MONTH,gc1.get(Calendar.DAY_OF_MONTH)+1)){
                if(gc1.get(Calendar.DAY_OF_MONTH)==1){
                    out.println("<br>"+sf.format(gc1.getTime())+"<br>");
                    out.println("<table width=\"807\" border=\"1\">\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>");



            }

            }


            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);
        }

        }