i am currently developing a login page for a web site which has 3 different homepages 1 for customers, 2 for employees 3 for the administrator, the code is supposed to decide the webpage that it is supposed to redirect to the correct homepage based on the role variable. i am facing a logical error, the code always ends up opening the home3 page. here is my code
--%>
<%@page import="java.sql.*"%>
<%
int id;
String role=request.getParameter("role");
if(role =="Customer")
{
id=3;
}
else if(role=="Employee")
{
id=2;
}
else
{
id=1;
}
String user=request.getParameter("user");
String pass=request.getParameter("pass");
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/flymywaysystem","root","12345");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from registeredcustomer where username='"+user+"' and password='"+pass+"'");
int count=0;
while(rs.next())
{
count++;
}
if(count>0)
{
switch (id) {
case 1: response.sendRedirect("home.jsp"); break;
case 2: response.sendRedirect("home2.jsp"); break;
case 3: response.sendRedirect("home3.jsp");break;
}
}
else
{
response.sendRedirect("login.jsp");
}
%>