aspose file tools*
The moose likes JDBC and the fly likes Unable to match database value with string Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Unable to match database value with string" Watch "Unable to match database value with string" New topic
Author

Unable to match database value with string

vanan saravanan
Ranch Hand

Joined: Jun 02, 2006
Posts: 95
I'm trying to redirect my user based on the value in the database but somehow my code doesnt seem to work. Even if the value of Status is "Pending" in the database it goes to

response.sendRedirect("deletestudentlist.jsp"); instead of

response.sendRedirect("viewstudentlist.jsp");

The problem i presume is in (status1 == "Pending") but not sure what is wrong. Please do help. Thank you.



rst1 = stm1.executeQuery("select Status from appraisal");
String status1 ="";
while(rst1.next()){
status1 = rst1.getString("Status") ;

}

if(status1 == "Pending"){
response.sendRedirect("viewstudentlist.jsp");
} else{
response.sendRedirect("deletestudentlist.jsp");
}
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42602
    
  65
Strings are not compared using "==", they're compared using the "equals" method. "==" tests the equality of the two String references, not the equality of the string contents.
[ October 25, 2006: Message edited by: Ulf Dittmer ]

Ping & DNS - my free Android networking tools app
vanan saravanan
Ranch Hand

Joined: Jun 02, 2006
Posts: 95
Thank you Ulf Dittmer. Works perfectly now.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Unable to match database value with string