i have only one login page. From same login page the admin and emp should login but different landing pages appear for respective admin and emp; edit code please. there is a type in the db if emp and admin. if emp credential matches the landing page should be different else admin credential matches the landing page should be different.
package ex.com;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.*;
import javax.servlet.http.HttpSession;
public class LoginServlet extends HttpServlet {
private static final long serialVersionUID = 102831973239L;
/**
* @see HttpServlet#HttpServlet()
*/
public LoginServlet() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String email= request.getParameter("useremail");
String password = request.getParameter("password");
String searchQuery = "select * from login where email='" + email
+ "' AND password='" + password + "'";
try {
Class.forName("com.mysql.jdbc.Driver");
}
catch (ClassNotFoundException e) {
System.out.println(e.getMessage());
}
try {
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "12345"
+ ""
+ ""
+ "");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(searchQuery);
boolean isEmpty = rs.next();
if (!isEmpty) {
// redirect to error page
request.getSession().removeAttribute("errorMessage");
request.getSession().setAttribute("errorMessage", "Invalid Credentials");
response.sendRedirect("admin.jsp");
}
else if (isEmpty) {
// fetch the session from request, create new session if session
// is not present in the request
HttpSession session = request.getSession(true);
session.setAttribute("FirstName", rs.getString("first_name"));
session.setAttribute("LastName", rs.getString("last_name"));
// redirect to success page
if("emp".equals(type))
{
response.sendRedirect("admin.jsp");
}
else if("hr".equals(type))
{
response.sendRedirect("emp.jsp");
}
}
}
}
catch (SQLException e) {
System.out.println("SQLException occured: " + e.getMessage());
e.printStackTrace();
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
}
}
Manav PandyaPosted May 11, 2017, 12:21 AM