Exemplo n.º 1
0
  /**
   * Method execute
   *
   * @param mapping
   * @param form
   * @param request
   * @param response
   * @return ActionForward
   */
  public ActionForward displaylocations(
      ActionMapping mapping,
      ActionForm form,
      HttpServletRequest request,
      HttpServletResponse response) {
    LoginForm loginForm = (LoginForm) form;

    Connection geconn = ConnectionFactory.getConnection();

    String sql1 = "Select * from GE_LOCATION";

    ArrayList ar1_id = new ArrayList();
    ArrayList ar2_name = new ArrayList();

    try {
      Statement st = geconn.createStatement();
      ResultSet rs = st.executeQuery(sql1);

      while (rs.next()) {
        ar1_id.add(rs.getString("LOCATION_ID") + "-" + rs.getString("LOCATION_NM"));
        ar2_name.add(rs.getString("LOCATION_ID") + "-" + rs.getString("LOCATION_NM"));
      }

      loginForm.setAr1_id(ar1_id);
      loginForm.setAr2_name(ar2_name);

    } catch (SQLException e) {
      e.printStackTrace();
    }

    return mapping.findForward("logout");
  }
Exemplo n.º 2
0
  public ActionForward signIn(
      ActionMapping mapping,
      ActionForm form,
      HttpServletRequest request,
      HttpServletResponse response) {
    LoginForm loginForm = (LoginForm) form; // TODO Auto-generated method stub

    String location = loginForm.getLocation();
    String locationid = location.substring(0, location.lastIndexOf("-"));

    String username = loginForm.getUsername();

    String password = loginForm.getPassword();
    Connection geconn = ConnectionFactory.getConnection();

    HttpSession session = request.getSession();

    try {
      Statement st = geconn.createStatement();

      String sql1 =
          "Select * from GE_USER WHERE USER_NAME='"
              + username
              + "' "
              + "and PASSWORD='******' and LOCATION_ID="
              + "'"
              + location.substring(0, location.lastIndexOf("-"))
              + "'";
      ResultSet rs = st.executeQuery(sql1);

      if (rs.next()) {

        // Visitor Dashboard
        VisitorsDB vi = new VisitorsDB();
        ArrayList a1 = vi.getVisitorsDateWise(location.substring(0, location.lastIndexOf("-")));
        request.setAttribute("disvisitors", a1);

        session.setAttribute("LocationName", location);
        session.setAttribute("Locationid", location.substring(0, location.lastIndexOf("-")));
        session.setAttribute("UserName", username);
        session.setAttribute("GateNo", loginForm.getGateno());

        String id = session.getId();

        System.out.println("Getting id is &&&&&&&&&&&&" + id);

        // For Material Inward
        MatinwardDB mi = new MatinwardDB();
        ArrayList m1 = mi.getMatinwardDateWise(locationid);
        request.setAttribute("dismatinward", m1);

        // For Other Material Outward
        OthmatoutDB mo = new OthmatoutDB();
        ArrayList m2 = mo.getOthmatoutDateWise(locationid);
        request.setAttribute("disothermatout", m2);

        // GRAPH CREATION AND DISPLAY
        PieChart chartCreator = new PieChart();
        /** Create a PieDataSet* */
        String realPath = getServlet().getServletContext().getRealPath("/graph");
        /** Define a file location to save this chart */
        String fileLocation = realPath + "/" + id + ".jpg";
        // chartCreator.processgraphimage(fileLocation,
        // location.substring(0,location.lastIndexOf("-")));

        return mapping.findForward("home");
      } else {
        displaylocations(mapping, form, request, response);
        loginForm.setMessage("Location OR User name and Password does not match");
        return mapping.findForward("logout");
      }

    } catch (Exception e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }

    return mapping.findForward("home");
  }