Advertisement
Guest User

Untitled

a guest
Apr 11th, 2016
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.01 KB | None | 0 0
  1. </body>
  2. </html>
  3.  
  4. <%@ page language="java" contentType="text/html; charset=ISO-8859-1"
  5. pageEncoding="ISO-8859-1"%>
  6. <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
  7. <html>
  8. <head>
  9. <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
  10. <title></title>
  11. </head>
  12. <body>
  13.  
  14. <%@page import="java.sql.*" %>
  15. <%@page import="javax.sql.*"%>
  16. <%
  17. String un=request.getParameter("un");
  18. session.setAttribute("un",un);
  19. String pwd=request.getParameter("pwd");
  20. Class.forName("com.mysql.jdbc.Driver");
  21. Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mymailstore","root","");
  22. Statement st = con.createStatement();
  23. ResultSet rs=st.executeQuery("select * from users where un='"+un+"'");
  24.  
  25. if(rs.next())
  26. {
  27. if(rs.getString(2).equals(pwd))
  28. {
  29. out.println("welcome"+un);
  30. }
  31. else
  32. {
  33. out.println("Dear "+un+" you have entered Invalid password try again OR go ");
  34. }
  35. }
  36. else
  37. {out.println("no output");}
  38. %>
  39. <a href="index.html"><br>Home</a>
  40.  
  41. </body>
  42. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement