Advertisement
samuel34

Untitled

Jun 4th, 2017
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.87 KB | None | 0 0
  1. web.xml file.
  2.  
  3. <?xml version="1.0" encoding="UTF-8"?>
  4. <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1">
  5. <display-name>Register</display-name>
  6. <servlet>
  7. <servlet-name>Register</servlet-name>
  8. <servlet-class>Register</servlet-class>
  9. </servlet>
  10. <servlet-mapping>
  11. <servlet-name>Register</servlet-name>
  12. <url-pattern>/Register</url-pattern>
  13. </servlet-mapping>
  14. <welcome-file-list>
  15. <welcome-file>index.html</welcome-file>
  16. <welcome-file>index.htm</welcome-file>
  17. <welcome-file>index.jsp</welcome-file>
  18. <welcome-file>default.html</welcome-file>
  19. <welcome-file>default.htm</welcome-file>
  20. <welcome-file>default.jsp</welcome-file>
  21. </welcome-file-list>
  22. </web-app>
  23.  
  24. Register.java
  25.  
  26. import java.sql.PreparedStatement;
  27. import java.sql.SQLException;
  28.  
  29. import javax.servlet.ServletException;
  30. import javax.servlet.http.HttpServlet;
  31. import javax.servlet.http.HttpServletRequest;
  32. import javax.servlet.http.HttpServletResponse;
  33.  
  34.  
  35. @SuppressWarnings("serial")
  36. public class Register extends HttpServlet {
  37.  
  38. @Override
  39. protected void doPost(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException {
  40. PrintWriter out = response.getWriter();
  41. response.setContentType("text/html");
  42. String name = request.getParameter("userName");
  43. String pass = request.getParameter("userPass");
  44. String email = request.getParameter("userEmail");
  45. String country = request.getParameter("userCountry");
  46. try {
  47. Class.forName("com.mysql.jdbc.Driver");
  48. Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/register", "root", "#Tandy1997");
  49. PreparedStatement ps = con.prepareStatement("insert into register values(?,?,?,?)");
  50. ps.setString(1, name);
  51. ps.setString(2, pass);
  52. ps.setString(3, email);
  53. ps.setString(4, country);
  54. int x = ps.executeUpdate();
  55. if (x > 0) {
  56. out.println("You have Succefully Registered");
  57. }
  58. }
  59. catch (SQLException se) {
  60. System.out.println(se.getErrorCode());
  61. }
  62. catch (ClassNotFoundException e) {
  63. // TODO Auto-generated catch block
  64. e.printStackTrace();
  65. }
  66. }
  67. }
  68.  
  69. servlet.html .
  70.  
  71. <!DOCTYPE html>
  72. <html>
  73.  
  74. <body>
  75. <p>
  76. <h1>Hey your welcome!</h1></p>
  77. <form action="servlet/Register" method="post">
  78.  
  79. Name:<input type="text" name="userName"/><br/><br/>
  80. Password:<input type="password" name="userPass"/><br/><br/>
  81. Email Id:<input type="text" name="userEmail"/><br/><br/>
  82. Country:
  83. <select name="userCountry">
  84. <option>India</option>
  85. <option>Pakistan</option>
  86. <option>Uganda</option>
  87. <option>other</option>
  88. </select>
  89.  
  90. <br/><br/>
  91. <input type="submit" value="register"/>
  92.  
  93. </form>
  94. </body>
  95. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement