Beispiel #1
0
  /** @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */
  protected void doPost(HttpServletRequest request, HttpServletResponse response)
      throws ServletException, IOException {
    /* Check Login Status */
    request
        .getRequestDispatcher(
            "/components/CLS?user_type=faculty&firstTime=true&returnType=redirect")
        .include(request, response);
    if (response.isCommitted()) return; // CLS preempting
    /* Get Connection */
    HttpSession session = request.getSession();
    Connection conn = null;
    synchronized (session) {
      DBConnector dbcon = (DBConnector) session.getAttribute("dbcon"); // fetch

      if (dbcon == null) {
        dbcon = new DBConnector();
        session.setAttribute("dbcon", dbcon);
      }
      conn = dbcon.getConnection();
    }

    String query =
        "select B.class_id, "
            + "xmlserialize(content xmlelement (name \"day\", "
            + "				xmlattributes(A.d_id as \"d_id\"), "
            + "				xmlagg(xmlelement(name \"slot\", "
            + "						xmlattributes(A.no as \"no\"), "
            + "						xmlelement(name \"subject_name\", su.name), "
            + "						xmlelement(name \"teacher_name\", na.fname||' '|| na.mname||' '||na.lname), "
            + "						xmlelement(name \"infra_name\", in.name) ))) as clob) "
            + "from pietons.faculty fa, "
            + "xmltable('$c/personal_details' passing fa.personal_details as \"c\" "
            + "columns fname varchar(20) path './name/fname', "
            + "		mname varchar(20) path './name/mname', "
            + "		lname varchar(20) path './name/lname') as na, "
            + "pietons.subject su, pietons.infrastructure in, pietons.allocation B, "
            + "xmltable ('$d/schedule/day/slot' passing B.schedule as \"d\" "
            + "columns d_id varchar(2) path '../@d_id', "
            + "		subject_id int path './subject_id', "
            + "		no varchar(2) path './@no', "
            + "		teacher_id varchar(10) path './teacher_id', "
            + "		infra_id int path './infra_id') as A "
            + "where A.teacher_id = fa.gr_no and A.subject_id = su.id and A.infra_id=in.id and fa.gr_no=?"
            + "group by B.class_id, A.d_id";
    PreparedStatement ps = null;
    try {
      ps = conn.prepareStatement(query);
      ps.setString(1, session.getAttribute("user_id").toString());
      ResultSet rs = ps.executeQuery();
      PrintWriter out = response.getWriter();
      out.println(
          "<?xml version=\"1.0\" encoding=\"UTF-8\" ?>"
              + "<?xml-stylesheet type=\"text/xsl\" href=\"/ITEA/components/tt.xsl\" ?>"
              + "<schedule>");
      while (rs.next()) out.println(rs.getString(2));
      out.println("</schedule>");
    } catch (SQLException e) {
      System.err.println(e.toString());
    }
  }
Beispiel #2
0
 /** @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */
 protected void doGet(HttpServletRequest request, HttpServletResponse response)
     throws ServletException, IOException {
   /* Check Login Status */
   request
       .getRequestDispatcher("/components/CLS?user_type=admin&returnType=redirect")
       .include(request, response);
   if (response.isCommitted()) return; // CLS preempting
   /* Get connection */
   HttpSession session = request.getSession();
   Connection conn = null;
   synchronized (session) {
     DBConnector dbcon = (DBConnector) session.getAttribute("dbcon"); // fetch
     // an
     // existing
     // instance
     if (dbcon == null) { // if none found, create a new one
       dbcon = new DBConnector();
       session.setAttribute("dbcon", dbcon);
     }
     conn = dbcon.getConnection();
   }
   // Determine if ajax or ordinary hyperlink
   if (request.getParameter("ajax") == null || request.getParameter("ajax").equals("")) {
     doPost(request, response);
     return;
   } else if (request.getParameter("do") != null && request.getParameter("do").equals("delete")) {
     /* Delete a Record */
     String query = "update pietons.subject set valid=? where id=?";
     try {
       PreparedStatement ps = conn.prepareStatement(query);
       ps.setInt(1, 0);
       ps.setString(2, request.getParameter("id"));
       ps.execute();
       return;
     } catch (SQLException e) {
       // TODO Auto-generated catch block
       System.out.println(e.toString());
       request
           .getRequestDispatcher(response.encodeURL("/components/error.jsp?type=database"))
           .forward(request, response);
       return;
     }
   } else if (request.getParameter("do") != null && request.getParameter("do").equals("restore")) {
     /* Restore a Record */
     String query = "update pietons.subject set valid=? where id=?";
     try {
       PreparedStatement ps = conn.prepareStatement(query);
       ps.setInt(1, 1);
       ps.setString(2, request.getParameter("id"));
       ps.execute();
       return;
     } catch (SQLException e) {
       // TODO Auto-generated catch block
       System.out.println(e.toString());
       request
           .getRequestDispatcher(response.encodeURL("/components/error.jsp?type=database"))
           .forward(request, response);
       return;
     }
   } else if (request.getParameter("do") != null && request.getParameter("do").equals("edit")) {
     /* Edit a Record */
     String field = request.getParameter("field");
     int subject_id = Integer.parseInt(request.getParameter("subject_id"));
     String newContent = request.getParameter("newContent");
     if (field.equals("labs_available")) {
       String labs_available = "<labs_available>";
       StringTokenizer st = new StringTokenizer(newContent, ",");
       while (st.hasMoreTokens()) {
         labs_available += "<lab id=\"" + Integer.parseInt(st.nextToken()) + "\"/>";
       }
       labs_available += "</labs_available>";
       newContent = labs_available;
     }
     String query = "update pietons.subject set " + field + "=? where id=?";
     PreparedStatement ps;
     try {
       ps = conn.prepareStatement(query);
       ps.setString(1, newContent);
       ps.setInt(2, subject_id);
       ps.execute();
       return;
     } catch (SQLException e) {
       // TODO Auto-generated catch block
       System.out.println(e.toString());
       request
           .getRequestDispatcher(response.encodeURL("/components/error.jsp?type=form"))
           .forward(request, response);
       return;
     }
   } else if (request.getParameter("list") != null
       && request.getParameter("list").equals("course")) {
     request.getRequestDispatcher("/components/CourseList").forward(request, response);
   } else if (request.getParameter("list") != null
       && request.getParameter("list").equals("branch")) {
     request
         .getRequestDispatcher(
             "/components/BranchList?course_id=" + request.getParameter("course_id"))
         .forward(request, response);
   } else if (request.getParameter("list") != null
       && request.getParameter("list").equals("class")) {
     request
         .getRequestDispatcher(
             "/components/ClassList?branch_id=" + request.getParameter("branch_id"))
         .forward(request, response);
   }
 }
Beispiel #3
0
  /** @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */
  protected void doPost(HttpServletRequest request, HttpServletResponse response)
      throws ServletException, IOException {
    /* Check Login Status */
    request
        .getRequestDispatcher("/components/CLS?user_type=admin&returnType=redirect")
        .include(request, response);
    if (response.isCommitted()) return; // CLS preempting
    /* Get connection */
    HttpSession session = request.getSession();
    Connection conn = null;
    synchronized (session) {
      DBConnector dbcon = (DBConnector) session.getAttribute("dbcon"); // fetch
      // an
      // existing
      // instance
      if (dbcon == null) { // if none found, create a new one
        dbcon = new DBConnector();
        session.setAttribute("dbcon", dbcon);
      }
      conn = dbcon.getConnection();
    }
    if (request.getParameter("do") != null && request.getParameter("do").equals("add")) {
      /* Add New Subject */
      request
          .getRequestDispatcher(response.encodeURL("/admin/subjectRecords.jsp?do=add"))
          .forward(request, response);
      return;
    } else if (request.getParameter("do") != null && request.getParameter("do").equals("save")) {
      /* Save New Record */

      String query = "insert into pietons.subject(class_id, name) values(?,?)";
      try {
        PreparedStatement ps = conn.prepareStatement(query);
        ps.setInt(1, Integer.parseInt(request.getParameter("class_id")));
        ps.setString(2, request.getParameter("name"));
        ps.execute();
        request
            .getRequestDispatcher(response.encodeURL("/admin/subjectRecords.jsp?do=save"))
            .forward(request, response);
      } catch (SQLException e) {
        // TODO Auto-generated catch block
        System.out.println(e.toString());
        request
            .getRequestDispatcher(response.encodeURL("/components/error.jsp?type=form"))
            .forward(request, response);
        return;
      }
      return;
    }
    /* Show list of subjects */
    if (request.getParameter("start") == null
        || request.getParameter("start").equals("")
        || request.getParameter("perpage") == null
        || request.getParameter("perpage").equals("")) {
      response.sendRedirect(response.encodeURL("/ITEA/admin/SubjectRecords?start=0&perpage=10"));
      return;
    }
    /* Extract List of Classes */
    String order_by = "";
    if (request.getParameter("order_by") != null) {
      order_by = request.getParameter("order_by");
    } else order_by = "id";
    String query =
        "select id, class_id, name, lectures_held, valid"
            + " from pietons.subject order by "
            + order_by;
    Statement st;
    int noOfRows = 0;
    try {
      st = conn.createStatement();
      /* Find No. of Records */
      ResultSet rschk = st.executeQuery(query);
      while (rschk.next()) {
        noOfRows++;
      }
      /* Instantiate noOfRows Number of SubjectBean Objects */
      SubjectBean[] sb = new SubjectBean[noOfRows];
      ResultSet rs = st.executeQuery(query);
      for (int i = 0; i < noOfRows; i++) {
        rs.next();

        sb[i] = new SubjectBean();
        sb[i].setId(rs.getInt("id"));
        sb[i].setClass_id(rs.getInt("class_id"));
        sb[i].setName(rs.getString("name"));
        sb[i].setLectures_held(rs.getInt("lectures_held"));
        sb[i].setValid(rs.getInt("valid"));
      }

      request.setAttribute("sb", sb);
      request.setAttribute("sb_no", noOfRows);
      request.setAttribute("perpage", Integer.parseInt(request.getParameter("perpage").toString()));
      request.setAttribute("start", Integer.parseInt(request.getParameter("start").toString()));
      request
          .getRequestDispatcher(response.encodeURL("/admin/subjectRecords.jsp"))
          .forward(request, response);
    } catch (SQLException e) {
      // TODO Auto-generated catch block
      System.out.println(e.toString());
      request
          .getRequestDispatcher(response.encodeURL("/components/error.jsp?type=database"))
          .forward(request, response);
      return;
    }
  }