HELP TO FIX LOGIN LOGICAL ERROR

See more:

Javascript

JSP

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");
          }
%>