ram1234

Java Servlet Form validation

Nov 6th, 2017
36
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.58 KB | None | 0 0
  1. Design a form and perform server side validation
  2. INDEX CODE:
  3. <html>
  4. <head>
  5. <title>Login Form</title>
  6. <meta charset="UTF-8">
  7. <meta name="viewport" content="width=device-width, initial-scale=1.0">
  8. </head>
  9. <body style="margin-left: 25px;">
  10. <h1>
  11. Form Validation Login Page
  12. </h1>
  13. <form action="demoServlet">
  14. <br/><h3>Enter Username:<input type="text" name="username" style="margin-left: 20px;"></h3><br>
  15. <h3>Enter Password:<input type="password" name="pass" style="margin-left: 20px;"></h3><br><br>
  16. <input type="submit" value="Login" style="margin-left: 80px;">
  17. </form>
  18.  
  19. </body>
  20.  
  21. </html>
  22.  
  23. SERVELET CODE:
  24. importjava.io.IOException;
  25. importjava.io.PrintWriter;
  26. importjava.sql.Connection;
  27. importjava.sql.DriverManager;
  28. importjava.sql.ResultSet;
  29. importjava.sql.Statement;
  30. importjavax.servlet.ServletException;
  31. importjavax.servlet.http.HttpServlet;
  32. importjavax.servlet.http.HttpServletRequest;
  33. importjavax.servlet.http.HttpServletResponse;
  34.  
  35. public class demoServlet extends HttpServlet {
  36. Connection conn;
  37.  
  38. protected void processRequest(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {
  39. response.setContentType("text/html");
  40. PrintWriter out = response.getWriter();
  41. Connection conn = null;
  42.  
  43. try {
  44. String username = request.getParameter("username");
  45. String pass = request.getParameter("pass");
  46. String userName = "scse";
  47. String password = "scse";
  48. String url = "jdbc:mysql://localhost/scse";
  49. Class.forName("com.mysql.jdbc.Driver").newInstance();
  50. conn = DriverManager.getConnection(url, userName, password);
  51. Statement s = conn.createStatement();
  52. s.executeQuery("SELECT * FROM register where username = '" + username + "' && pass = '" + pass +"' " );
  53. ResultSetrs = s.getResultSet();
  54. while (rs.next()) {
  55. out.println(username+" is successfully logged in and you have validated your username and password.");
  56.  
  57. }
  58. rs.close();
  59. s.close();
  60.  
  61. } catch (Exception e) {
  62. out.println(e.toString());
  63. }
  64. finally {
  65. out.close();
  66. if (conn != null) {
  67. try {
  68. conn.close();
  69. out.println("Database connection terminated");
  70. } catch (Exception e) {
  71. }
  72. }
  73.  
  74. }
  75. }
  76.  
  77. @Override
  78. protected void doGet(HttpServletRequest request, HttpServletResponse response)
  79. throwsServletException, IOException {
  80. processRequest(request, response);
  81. }
  82.  
  83. @Override
  84. protected void doPost(HttpServletRequest request, HttpServletResponse response)
  85. throwsServletException, IOException {
  86. processRequest(request, response);
  87. }
  88. }
Add Comment
Please, Sign In to add comment