inner if condition is turning out to be false

[Vishal Hegde]

if((Usr_ID.equals(rs.getString("login").trim()))&&(Passwd.equals(rs.getString("passwd").trim())))
             {
                    
                 if(rs.getString("type").trim().equals("admin"))
                 {
                     out.println("You are logged in as Admin");
                   }
 }

The first if statement I am able to get into but its not going within the second if statement, the user name and password is mapped with the type admin but still i am not getting the output "you are logged in as Admin"

[Jaikiran Pai]

Vishal Hegde wrote:

if(rs.getString("type").trim().equals("admin"))
{


[/code]

The first if statement I am able to get into but its not going within the second if statement, the user name and password is mapped with the type admin but still i am not getting the output "you are logged in as Admin"

That's simple then - whatever rs.getString("type") returns isn't equal to "admin" (case-sensitive). Have you debugged or tried printing out what rs.getString("type") returns?

[Vishal Hegde]

Yes I did i even checked with case sensitivity... its all fine its admin itself in the table but stilll not sure where i am getting wrong

[Matthew Brown]

Vishal Hegde wrote:Yes I did i even checked with case sensitivity... its all fine its admin itself in the table but stilll not sure where i am getting wrong

Don't check in the table, check the actual value being returned by rs.getString("type").

[Vishal Hegde]

Thanks a lot for your prompt response ...Really appreciate your kind support, the admin issue has been resolved now the issue is with the student login and the code i am tryin is as below

 while(rs.next())
            {
                
               
                
          
             if((Usr_ID.equals(rs.getString("login").trim()))&&(Passwd.equals(rs.getString("passwd").trim())))
             {
                 out.println(rs.getString("type").trim().equals("student"));
                 
                    
                 if(rs.getString("type").trim().equals("admin"))
                 {
                     
                     out.println("You are logged in as Admin");
                     RequestDispatcher adminlogin=request.getRequestDispatcher("Admin0.jsp");
                     adminlogin.forward(request, response);
                 }
                  if(rs.getString("type").trim().equals("student"))
                 {
                        out.println("Hey Student ");
                     RequestDispatcher s=request.getRequestDispatcher("Student0.jsp");
                     s.forward(request,response);
                 }
                 
                 
             }

I am inputting user id and password mapped to the type student..but not sure where it is getting stuck in this case

[Campbell Ritchie]

Are you using Java7? If so, consider using a switch-case structure instead of those else-ifs. Or consider creating a RequestDespatcher object, and retrieving it from a Map<String, RequestDespatcher>.

[Vishal Hegde]

Hi Campbell,

I am still using java6..Not sure what is the actual issue

[Vishal Hegde]

Is it because i am using RequestDispatcher twice I just removed requestDispatcher code and added simple

if the type is admin

out.println("In Admin");

if type is student

out.println("in student");

In this case the looping is working perfectly fine

[Vishal Hegde]

Problem resolvedddd

But still I am not able to understand where i was going wrong