Guest User

Untitled

a guest
Nov 4th, 2018
136
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.56 KB | None | 0 0
  1. import java.sql.*;
  2. import javax.servlet.http.*;
  3. import java.io.*;
  4. import javax.servlet.RequestDispatcher;
  5. import javax.servlet.ServletException;
  6.  
  7. public class validation extends HttpServlet
  8. {
  9. static PrintWriter pw = null;
  10. public void doPost(HttpServletResponse response, HttpServletRequest request) throws ClassNotFoundException, SQLException, IOException, ServletException
  11. {
  12. pw = response.getWriter();
  13. String username = request.getParameter("username");
  14. String password = request.getParameter("password");
  15. RequestDispatcher rd = request.getRequestDispatcher("new.html");
  16. Class.forName("java.sql.Driver");
  17. Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/timetabledb", "root","`");
  18. Statement stmt = con.createStatement();
  19. ResultSet rs = stmt.executeQuery("select password from users where username = '"+username+"';");
  20. if(rs.next()==false)
  21. {
  22. pw.println("No such user found!");
  23. }
  24. else
  25. {
  26. if(password.equals(rs.getString("password")))
  27. {
  28. rd.forward(request, response);
  29. }
  30. else
  31. {
  32. pw.println("Invalid credentials!");
  33. }
  34. }
  35. rs.close();
  36. }
  37. }
  38.  
  39. <!DOCTYPE html>
  40. <html>
  41. <head>
  42. <title>Login Page - SGMS</title>
  43. <link rel="stylesheet" href="main.css" />
  44. </head>
  45.  
  46. <body>
  47. <div id = "container">
  48. <div class = "welcome-head">
  49. Welcome
  50. </div>
  51. <div class = "sw-head">
  52. Semi-Automatic Schedule Generator & Maintenance Software
  53. </div>
  54. <span class="logo">
  55. <img src="logo.gif" alt="Logo"/>
  56. </span>
  57. <div class = "form">
  58. <form method="POST" action="validation">
  59. <label for="inp-usr" class="inp">
  60. <input type="text" name="username" id="inp-usr" placeholder="&nbsp;" required="required">
  61. <span class="label">Username</span>
  62. <span class="border"></span>
  63. </label>
  64. <br>
  65. <label for="inp-pwd" class="inp">
  66. <input type="password" name="password" id="inp-pwd" placeholder="&nbsp;" required="required">
  67. <span class="label">Password</span>
  68. <span class="border"></span>
  69. </label>
  70. <br><br><br>
  71. <button class="validate-btn" onclick="show();">
  72. Validate
  73. </button>
  74. </form>
  75. </div>
  76. </div>
  77. </body>
  78.  
  79. </html>
Add Comment
Please, Sign In to add comment