index.jsp
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP</title>
</head>
<body>
<form method="post" action="login.jsp">
<center>
<table border="1" width="30%" cellpadding="3">
<thead>
<tr>
<th colspan="2">Login Here</th>
</tr>
</thead>
<tbody>
<tr>
<td>User Name</td>
<td><input type="text" name="uname" value="" /></td>
</tr>
<tr>
<td>Password</td>
<td><input type="password" name="pass" value="" /></td>
</tr>
<tr>
<td><input type="submit" value="Login" /></td>
<td><input type="reset" value="Reset" /></td>
</tr>
<tr>
<td colspan="2">Yet Not Registered!! <a href="reg.jsp">Register Here</a></td>
</tr>
<tr>
<td colspan="2">Login as <a href="root.html"> ROOT </a></td>
</tr>
</tbody>
</table>
</center>
</form>
</body>
</html>
normal user login:-
login.jsp
<%@ page import ="java.sql.*" %>
<%
String userid = request.getParameter("uname");
String pwd = request.getParameter("pass");
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/Login",
"jayesh", "jayesh");
Statement st = con.createStatement();
ResultSet rs;
rs = st.executeQuery("select * from members where uname='" + userid + "' and pass='" + pwd + "'");
if (rs.next()) {
session.setAttribute("userid", userid);
//out.println("welcome " + userid);
//out.println("<a href='logout.jsp'>Log out</a>");
response.sendRedirect("success.jsp");
} else {
out.println("Invalid password <a href='index.jsp'>try again</a>");
}
%>
normal user
logout.jsp
<%
session.setAttribute("userid", null);
session.invalidate();
response.sendRedirect("index.jsp");
%>
reg.html
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP</title>
</head>
<body>
<form method="post" action="login.jsp">
<center>
<table border="1" width="30%" cellpadding="3">
<thead>
<tr>
<th colspan="2">Login Here</th>
</tr>
</thead>
<tbody>
<tr>
<td>User Name</td>
<td><input type="text" name="uname" value="" /></td>
</tr>
<tr>
<td>Password</td>
<td><input type="password" name="pass" value="" /></td>
</tr>
<tr>
<td><input type="submit" value="Login" /></td>
<td><input type="reset" value="Reset" /></td>
</tr>
<tr>
<td colspan="2">Yet Not Registered!! <a href="reg.jsp">Register Here</a></td>
</tr>
<tr>
<td colspan="2">Login as <a href="root.html"> ROOT </a></td>
</tr>
</tbody>
</table>
</center>
</form>
</body>
</html>
normal user login:-
login.jsp
<%@ page import ="java.sql.*" %>
<%
String userid = request.getParameter("uname");
String pwd = request.getParameter("pass");
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/Login",
"jayesh", "jayesh");
Statement st = con.createStatement();
ResultSet rs;
rs = st.executeQuery("select * from members where uname='" + userid + "' and pass='" + pwd + "'");
if (rs.next()) {
session.setAttribute("userid", userid);
//out.println("welcome " + userid);
//out.println("<a href='logout.jsp'>Log out</a>");
response.sendRedirect("success.jsp");
} else {
out.println("Invalid password <a href='index.jsp'>try again</a>");
}
%>
normal user
logout.jsp
<%
session.setAttribute("userid", null);
session.invalidate();
response.sendRedirect("index.jsp");
%>
reg.html
<%@page contentType="text/html" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Registration</title> </head> <body> <form method="post" action="registration.jsp"> <center> <table border="1" width="30%" cellpadding="5"> <thead> <tr> <th colspan="2">Enter Information Here</th> </tr> </thead> <tbody> <tr> <td>First Name</td> <td><input type="text" name="fname" value="" /></td> </tr> <tr> <td>Last Name</td> <td><input type="text" name="lname" value="" /></td> </tr> <tr> <td>Email</td> <td><input type="text" name="email" value="" /></td> </tr> <tr> <td>User Name</td> <td><input type="text" name="uname" value="" /></td> </tr> <tr> <td>Password</td> <td><input type="password" name="pass" value="" /></td> </tr> <tr> <td><input type="submit" value="Submit" /></td> <td><input type="reset" value="Reset" /></td> </tr> <tr> <td colspan="2">Already registered!! <a href="index.jsp">Login Here</a></td> </tr> </tbody> </table> </center> </form> </body> </html>
registration.jsp
<%@ page import ="java.sql.*" %> <% String user = request.getParameter("uname"); String pwd = request.getParameter("pass"); String fname = request.getParameter("fname"); String lname = request.getParameter("lname"); String email = request.getParameter("email"); Class.forName("com.mysql.jdbc.Driver"); Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/Login", "jayesh", "jayesh"); Statement st = con.createStatement(); //ResultSet rs; int i = st.executeUpdate("insert into members(first_name, last_name, email, uname, pass, regdate) values ('" + fname + "','" + lname + "','" + email + "','" + user + "','" + pwd + "', CURDATE())"); if (i > 0) { //session.setAttribute("userid", user); response.sendRedirect("welcome.jsp"); // out.print("Registration Successfull!"+"<a href='index.jsp'>Go to Login</a>"); } else { response.sendRedirect("index.jsp"); } %>
Rootlogin
root.html
<!DOCTYPE html> <!-- To change this license header, choose License Headers in Project Properties. To change this template file, choose Tools | Templates and open the template in the editor. --> <!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title> Root Login </title> </head> <body> <form method="post" action="root.jsp"> <center> <table border="1" width="30%" cellpadding="3"> <thead> <tr> <th colspan="2">ROOT Login Here</th> </tr> </thead> <tbody> <tr> <td>User Name</td> <td><input type="text" name="uname" value="" /></td> </tr> <tr> <td>Password</td> <td><input type="password" name="passwd" value="" /></td> </tr> <tr> <td><input type="submit" value="Login" /></td> <td><input type="reset" value="Reset" /></td> </tr> </tbody> </table> </center> </form> </body> </html>
root.jsp
<%@page contentType="text/html" pageEncoding="UTF-8"%> <%@page import="java.sql.*" %> <%@page import="java.io.*" %> <!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title> Root Login </title> </head> <body> <% String r_name= request.getParameter("uname"); String r_password= request.getParameter("passwd"); Connection conn=null; Statement stmt = null; ResultSet rs = null,rs1=null; try{ Class.forName("com.mysql.jdbc.Driver"); conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/Login","jayesh","jayesh"); // out.println("<br>connection established "); stmt = conn.createStatement(); rs = stmt.executeQuery("select root_name,root_password from root_detail"); String name="",password="";boolean flag=false; while(rs.next()){ name = rs.getString(1); password = rs.getString(2); if(name.equals(r_name) && password.equals(r_password)){ session.setAttribute("rootid", r_name); //out.print("<br>user is : " + name + " <br> Password is : "+ password ); flag = true; response.sendRedirect("root_success.jsp"); break; } else{ flag = false; } } if(!flag){ //out.print("user name and password is not valid."); out.println("Invalid username & password <a href='root.html'>try again</a>"); //response.sendRedirect("root.html"); } } catch(Exception e){ out.print("Exception :" + e); } finally{ conn.close(); } %> </body> </html>
root_success.jsp
<% if ((session.getAttribute("rootid") == null) || (session.getAttribute("rootid") == "")) { %> You are not logged in<br/> <a href="root.html">Please Login</a> <%} else { %> Welcome <%=session.getAttribute("rootid")%> <a href='root_logout.jsp'>Log out</a> <% } %>
normal user
success.jsp
<% if ((session.getAttribute("userid") == null) || (session.getAttribute("userid") == "")) { %> You are not logged in<br/> <a href="index.jsp">Please Login</a> <%} else { %> Welcome <%=session.getAttribute("userid")%> <a href='logout.jsp'>Log out</a> <% } %>
root logout
rootlogout.jsp
<% session.setAttribute("rootid", null); session.invalidate(); response.sendRedirect("root.html"); %>
0 Comments