Guest User

Untitled

a guest
Jan 25th, 2018
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.14 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <meta charset="ISO-8859-1">
  5. <title>Insert title here</title>
  6. </head>
  7. <body>
  8. <form action="Registration" method="post" autocomplete="on">
  9. <fieldset>
  10. <legend>Registration Details:</legend>
  11. First Name &nbsp <input type="text" name="firstname" autofocus> &nbsp Middle name &nbsp <input type="text" name="middlename"> &nbsp Last Name &nbsp <input type="text" name="lastname"><br><br>
  12. Address &nbsp <br> <textarea name="address" rows="2" cols="25"></textarea>
  13. <br><br>
  14. Gender &nbsp <input type="radio" name="gender" value="male"> Male <input type="radio" name="gender" value="female"> Female<br><br>
  15. Mobile No. &nbsp <input type="text" name="mobileno"> <br><br>
  16. Email Id &nbsp <input type="email" name="emailid"> <br><br>
  17. Birth Date &nbsp <input type="date" name="birthday"><br><br>
  18. Username &nbsp <input type="text" name="username"><br><br>
  19. Password &nbsp <input type="password" name="password"><br><br>
  20. <input type="submit" value="Submit">
  21. </fieldset>
  22. </form>
  23. </body>
  24. </html>
  25.  
  26. import java.io.IOException;
  27. import java.io.PrintWriter;
  28. import java.sql.*;
  29. import javax.servlet.ServletException;
  30. import javax.servlet.annotation.WebServlet;
  31. import javax.servlet.http.HttpServlet;
  32. import javax.servlet.http.HttpServletRequest;
  33. import javax.servlet.http.HttpServletResponse;
  34.  
  35. /**
  36. * Servlet implementation class Registration
  37. */
  38. @WebServlet("/Registration")
  39. public class Registration extends HttpServlet {
  40.  
  41. private static final long serialVersionUID = 1L;
  42.  
  43. public void service(HttpServletRequest request, HttpServletResponse response)
  44. {
  45. }
  46. /**
  47. * @see HttpServlet#HttpServlet()
  48. */
  49. public Registration() {
  50. super();
  51. // TODO Auto-generated constructor stub
  52. }
  53.  
  54. /**
  55. * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
  56. */
  57. public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  58. // TODO Auto-generated method stub
  59.  
  60. //http://localhost:12093
  61. try {
  62. String firstname=request.getParameter("firstname");
  63. PrintWriter print = response.getWriter();
  64. print.println(firstname);
  65. Class.forName("com.mysql.jdbc.Driver");
  66. java.sql.Connection connection;
  67.  
  68. connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/registration","root","rohan");
  69. PreparedStatement ps=connection.prepareStatement("INSERT INTO reg_details (name) values ('rk');");
  70. //Statement stmt = connection.createStatement();
  71. // ResultSet result = stmt.executeQuery("INSERT INTO reg_details (name) values ('rohan');");
  72. ps.setString(1, firstname);
  73. ps.executeUpdate();
  74. // while(result.next())
  75. // {
  76. // PrintWriter print = response.getWriter();
  77. // print.println(result.getString("name"));
  78. // }
  79. } catch (SQLException | ClassNotFoundException e) {
  80. // TODO Auto-generated catch block
  81. e.printStackTrace();
  82. } catch (IOException e) {
  83. // TODO Auto-generated catch block
  84. e.printStackTrace();
  85. }
  86. }
  87. }
Add Comment
Please, Sign In to add comment