Advertisement
Guest User

Untitled

a guest
Jul 6th, 2017
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.19 KB | None | 0 0
  1. <html>
  2. <head>
  3. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  4. <title>JSP Page</title>
  5. </head>
  6. <body>
  7. <%@ page import="java.sql.*"%>
  8. <%@page import="java.sql.Connection.*" %>
  9. <%@page import="java.sql.DriverManager.*" %>
  10.  
  11. <%
  12. String user = request.getParameter("userName");
  13. String pass = request.getParameter("password");
  14. //Class.forName("com.mysql.jdbc.Driver");
  15. Connection conn = null;
  16. String url = "jdbc:mysql://localhost:8080/";
  17. String dbName = "Rak";
  18. String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
  19. String userName = "sa";
  20. String password = "Access#123";
  21. Class.forName(driver).newInstance();
  22. conn = DriverManager.getConnection(url + dbName, userName, password);
  23. Statement st = conn.createStatement();
  24. ResultSet rs;
  25. rs = st.executeQuery("select LoginName,Password from Users where LoginName='" + user + "' and Password='" + pass + "'");
  26. if (rs.next()) {
  27. session.setAttribute("userid", userName);
  28. response.sendRedirect("success.jsp");
  29. } else {
  30. out.println("Invalid password <a href='index.jsp'>try again</a>");
  31. }
  32. %>
  33. </body>
  34. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement