Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
- <title>JSP Page</title>
- </head>
- <body>
- <%@ page import="java.sql.*"%>
- <%@page import="java.sql.Connection.*" %>
- <%@page import="java.sql.DriverManager.*" %>
- <%
- String user = request.getParameter("userName");
- String pass = request.getParameter("password");
- //Class.forName("com.mysql.jdbc.Driver");
- Connection conn = null;
- String url = "jdbc:mysql://localhost:8080/";
- String dbName = "Rak";
- String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
- String userName = "sa";
- String password = "Access#123";
- Class.forName(driver).newInstance();
- conn = DriverManager.getConnection(url + dbName, userName, password);
- Statement st = conn.createStatement();
- ResultSet rs;
- rs = st.executeQuery("select LoginName,Password from Users where LoginName='" + user + "' and Password='" + pass + "'");
- if (rs.next()) {
- session.setAttribute("userid", userName);
- response.sendRedirect("success.jsp");
- } else {
- out.println("Invalid password <a href='index.jsp'>try again</a>");
- }
- %>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement