Exemplo n.º 1
0
 protected void doPost(HttpServletRequest request, HttpServletResponse response)
     throws ServletException, IOException {
   response.setContentType("text/html;charset=UTF-8");
   PrintWriter out = response.getWriter();
   try {
     Database database = new Database();
     ProjectManager projectManager = new ProjectManager();
     String message = null;
     Connection connection = database.Get_Connection();
     message = projectManager.InsertMessage(connection, request, response);
     if (message != null) {
       out.println("<div>" + message + "</div>");
     } else {
       out.println("false");
     }
   } catch (Exception ex) {
     out.println("Error: " + ex.getMessage());
   } finally {
     out.close();
   }
 }
Exemplo n.º 2
0
  /** @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */
  protected void doPost(HttpServletRequest request, HttpServletResponse response)
      throws ServletException, IOException {
    // TODO Auto-generated method stub

    // Set response content type
    response.setContentType("text/html");

    PrintWriter out = response.getWriter();

    try {
      // Register JDBC driver
      // JDBC driver name and database URL
      //  Database credentials

      Database database = new Database();

      // Open a connection
      Connection conn = database.Get_Connection();

      String sname = null;

      String gname = null;
      String salutation = null;
      String desc = null;

      String email = null;
      String pw = null;
      String cpw = null;
      String pn = null;
      String add = null;
      String hr = null;
      String status = null;

      sname = request.getParameter("sName");
      gname = request.getParameter("gName");
      salutation = request.getParameter("salutation");
      desc = request.getParameter("cDesc");
      email = request.getParameter("cEmail");

      pw = request.getParameter("cPassword");

      cpw = request.getParameter("confirmPassword");

      pn = request.getParameter("cMobile");

      add = request.getParameter("cAddress");
      hr = request.getParameter("cHourlyRate");

      status = request.getParameter("status");

      out.println("Your Text = " + sname + "<br>");
      out.println("Your Text = " + gname + "<br>");
      out.println("Your Text = " + desc + "<br>");
      out.println("Your Text = " + email + "<br>");
      out.println("Your Text = " + pw + "<br>");
      out.println("Your Text = " + cpw + "<br>");
      out.println("Your Text = " + pn + "<br>");
      out.println("Your Text = " + add + "<br>");
      out.println("Your Text = " + hr + "<br>");
      out.println("Your Text = " + status + "<br>");
      java.util.Date dt = new java.util.Date();

      java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

      String currentTime = sdf.format(dt);
      // Execute SQL query
      Statement stmt = null;
      Statement user = null;
      stmt = conn.createStatement();

      user = conn.createStatement();
      ResultSet rs = null;
      int i =
          stmt.executeUpdate(
              "INSERT INTO `coach`(`coach_hourly_rate`, `coach_profile`) VALUES ('"
                  + hr
                  + "','"
                  + desc
                  + "')",
              Statement.RETURN_GENERATED_KEYS);

      // validate login to remember the row

      out.println(i);

      rs = stmt.getGeneratedKeys();
      while (rs.next()) {
        int key = rs.getInt(1);
        System.out.println("Key returned from getGeneratedKeys():" + rs.getInt(1));

        user.executeUpdate(
            "INSERT INTO `user`( `coach_id`, `email`, `password`, `surname`, `given_name`, `mobile`, `role`, `create_update_datetime`, `salutation`, `address`, `userStatus_id`) VALUES ('"
                + key
                + "','"
                + email
                + "','"
                + pw
                + "', '"
                + sname
                + "', '"
                + gname
                + "' , '"
                + pn
                + "', 'coach', '"
                + currentTime
                + "', '"
                + salutation
                + "', '"
                + add
                + "','"
                + status
                + "')");
        response.sendRedirect("manageCoachUser.jsp");
      }
      rs.close();

    } catch (SQLException se) {
      // Handle errors for JDBC
      se.printStackTrace();
    } catch (Exception e) {
      // Handle errors for Class.forName
      e.printStackTrace();
    }
  }