(LMS)
Login.java
package userLogin;
import connection.Databasecon;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import javax.xml.ws.Dispatch;
public class Login extends HttpServlet
{
private String
username = null;
private String
pass = null;
private String
userType = null;
private Connection
con = null;
private Statement
stmt = null;
private ResultSet
rs = null;
Databasecon dbcon
= new Databasecon();
@Override
public void
doPost(HttpServletRequest request, HttpServletResponse response)throws
ServletException, IOException
{
response.setContentType("text/html;charset=UTF-8");
PrintWriter
out = response.getWriter();
HttpSession
session = request.getSession(true);
session.setAttribute("username",request.getParameter("username"));
RequestDispatcher rds;
String
selectmode;
selectmode =
request.getParameter("userType");
/////////////////////////////////////////////////////////////
out.println("<html><head><meta
http-equiv='Content-Type' content='text/html; charset=iso-8859-1'
/><title> Link Software Library Management System </title><link
href='css/first.css' rel='stylesheet' /></head>");
out.println("<body><div id='header'><table
width='80%' height='147' border='0' align='center' cellpadding='0'
cellspacing='0' bgcolor='#FFFFFF'><!--DWLayoutTable--><tr><td
width='141' bgcolor='#F10403'><div
align='center'></div></td><td width='475' height='19'
background='Images/bg-1.gif'><div align='center'><span
class='style2'>LIBRARY MANAGEMENT SOFTWARE
</span></div></td>");
out.println("<td width='180'
background='Images/bg-1.gif'><div align='center'><span
class='style11'><strong><a href='signin.jsp' class='menu1'>Sign
in</a></strong> (For members)</span>
</div></td></tr><tr><td
bgcolor='#990000'><!--DWLayoutEmptyCell--> </td><td
height='19' colspan='2'
bgcolor='#990000'><!--DWLayoutEmptyCell--> </td></tr><tr><td
width='141' rowspan='3'
bgcolor='#990000'><!--DWLayoutEmptyCell--> </td><td
height='42' colspan='2' bgcolor='#990000'><div align='center'
class='style1 style26'>Link Software Library Management System
</div></td>");
out.println("</tr><tr><td height='14' colspan='2'
bgcolor='#990000'> </td></tr><tr><td
height='14' colspan='2' bgcolor='#990000'><div align='center' class='style22'><a
href='index.jsp' class='menu1'>Home</a> | <a href='aboutus.jsp'
class='menu1'>About us</a> | <a href='gallary.jsp'
class='menu1'>Gallery </a>| <a href='sitemap.jsp'
class='menu1'>Sitemap </a>|<a href='contact.jsp' class='menu1'>
Contact us </a></div></td></tr><tr><td
height='29' colspan='3' valign='top' bgcolor='#990000'
style='border-bottom:#F10403 thick
solid;'> </td><tr><td height='29' colspan='3'
valign='top' bgcolor='#FFFFCC'> </td><!-- <tr><td
height='29' colspan='3' valign='top' bgcolor='#990000'
style='border-bottom:#F10403 thick
solid;'> </td>--></table></div>");
out.println("<br /><br /><br /><br /><br
/>");
/////////////////////////////////////////////////////////////
if(dbcon!=null)
{
//////////////////////////////////////////////////////////////////////////////////////
if(selectmode.equals("Librarian"))
{
try
{
con = dbcon.getConnection();
stmt = con.createStatement();
String query = "select * from login where username =
'"+request.getParameter("username")+"' and password =
'"+request.getParameter("pass")+"' and userType =
'"+request.getParameter("userType")+"'"; // and
courname = "+request.getParameter("coursename")+" and year
= " + request.getParameter("year")+"";
rs
= stmt.executeQuery(query);
if(rs.next()==true)
{
if(rs.getString("status").equals("Active"))
{
session.setAttribute("username",
request.getParameter("username"));
rds =
request.getRequestDispatcher("UserControl/LibrarianLogin.jsp");
rds.forward(request,response);
}
else if(rs.getString("status").equals("DeActive"))
{
out.println("<h1 align='center' class='menu'>Librarian
Blocked by Administrator</h1>");
}
}
else
{
out.println("<h1 align = 'center' class = 'menu'>User Id and
Password is Invalid . Re-Enter Username or Password</h1>");
}
}
catch(Exception ex)
{
System.out.println("Connection Not Stablished");
}
}
/////////////////////////////////////////////////////////////////////////////////////////
if(selectmode.equals("Administrator"))
{
try
{
con = dbcon.getConnection();
stmt = con.createStatement();
String query = "select * from login where username =
'"+request.getParameter("username")+"' and password =
'"+request.getParameter("pass")+"' and userType =
'"+request.getParameter("userType")+"'"; // and
courname = "+request.getParameter("coursename")+" and year
= " + request.getParameter("year")+"";
rs
= stmt.executeQuery(query);
if(rs.next()==true)
{
session.setAttribute("username",
request.getParameter("username"));
rds = request.getRequestDispatcher("AdminControls/index.jsp");
rds.forward(request,response);
//out.println("Login Successful");
}
else
{
out.println("<h1 align = 'center' class = 'menu'>User Id and
Password is Invalid . Re-Enter Username or Password</h1>");
}
}
catch(Exception ex)
{
System.out.println("Connection Not
Stablished");
}
}
//////////////////////////////////////////////////////////////////////////////////
}
else
{
System.out.println("This is a Login Error");
}
/////////////////////////////////////////////////////
out.println("<br /><br /><br /><br /><br
/>");
out.println("<div align='left'><table width = '80%'
align='center'><tr><td>");
out.println("<a href='/LMS/index.jsp' class='menu'>Go to Home
Page</a></td></tr></table></div>");
out.println("<div id='footer'><table width='80%'
border='0' align='center' cellpadding='0' cellspacing='0'
bgcolor='#FFFFFF'><tr><td
colspan='3'> </td></tr><tr><td height='26'
colspan='3' bgcolor='#990000'><div align='center'><span
class='style22'><a href='index.jsp' class='menu1'>Home</a> |
<a href='aboutus.jsp' class='menu1'>About us</a> | <a href='gallary.jsp'
class='menu1'>Gallery </a>| <a href='sitemap.jsp'
class='menu1'>Sitemap </a>|<a href='contact.jsp' class='menu1'>
Contact us </a>
</span></div></td></tr><tr><td width='24%'
bgcolor='#990000'><div align='center'><span class='style15'>Copyright
© 2017 Link Software</span>
</div></td><td width='56%'><div align='center'><span
class='style17'><strong>Best view:</strong> 1024x724 Pixel
(Resolution) </span></div></td><td width='20%'
bgcolor='#990000'><div align='center' class='style23'><span
class='style19'><strong><u>Created & Designed
by:</u> <br /></strong>Balwant Chandel
</span></div></td></tr><tr><td
bgcolor='#990000'> </td><td
bgcolor='#990000'> </td><td
bgcolor='#990000'> </td></tr></table></div></body></html>");
/////////////////////////////////////////////////////
}
}
Now We Make web.XML to set the Login Action
<servlet>
<servlet-name>Login</servlet-name>
<servlet-class>userLogin.Login</servlet-class>
</servlet>
<servlet>
<servlet-name>studentid</servlet-name>
<servlet-class>userLogin.studentid</servlet-class>
</servlet>
Now the login functionality is completed ...
If this information is important to you , and you want to , I will continue writing some more details About Java, Servlet's, Android Programming Language, so click on the advertising, available on this page. This is motivate me for writing some more useful stuff, Thank's
Comments
Post a Comment