Guest User

Untitled

a guest
Nov 18th, 2018
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.76 KB | None | 0 0
  1. public class NewUser extends HttpServlet {
  2.  
  3. /**
  4. * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
  5. * methods.
  6. *
  7. * @param request servlet request
  8. * @param response servlet response
  9. * @throws ServletException if a servlet-specific error occurs
  10. * @throws IOException if an I/O error occurs
  11. */
  12. protected void processRequest(HttpServletRequest request, HttpServletResponse response)
  13. throws ServletException, IOException {
  14. response.setContentType("text/html;charset=UTF-8");
  15.  
  16. HttpSession session = request.getSession(false);
  17.  
  18. String [] query = new String[5];
  19. query[0] = (String)request.getParameter("username");
  20. query[1] = (String)request.getParameter("password");
  21. query[2] = (String)request.getParameter("confPassword");
  22. query[3] = (String)request.getParameter("name");
  23. query[4] = (String)request.getParameter("address");
  24.  
  25.  
  26. Jdbc jdbc = (Jdbc)session.getAttribute("dbbean");
  27.  
  28. if (jdbc == null)
  29. request.getRequestDispatcher("/WEB-INF/conErr.jsp").forward(request, response);
  30.  
  31. else {
  32. jdbc.insert(query);
  33. request.setAttribute("message", query[0]+" has been registered successfully!");
  34. }
  35.  
  36. public void insert(String[] str){
  37. PreparedStatement ps = null;
  38. try {
  39. ps = connection.prepareStatement("INSERT INTO CUSTOMER VALUES (?,?,?,?)",PreparedStatement.RETURN_GENERATED_KEYS);
  40. ps.setString(1, str[0].trim());
  41. ps.setString(2, str[1]);
  42. ps.setString(3, str[3]);
  43. ps.setString(4, str[4]);
  44. ps.executeUpdate();
  45.  
  46. ps.close();
  47. System.out.println("1 row added.");
  48. } catch (SQLException ex) {
  49. Logger.getLogger(Jdbc.class.getName()).log(Level.SEVERE, null, ex);
  50. }
  51.  
  52. }
  53.  
  54. # | Username | Password | Name | Address | ID
Add Comment
Please, Sign In to add comment