File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Unable to match database value with string

 
vanan saravanan
Ranch Hand
Posts: 95
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Pie
Posts: 42966
73
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
vanan saravanan
Ranch Hand
Posts: 95
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you Ulf Dittmer. Works perfectly now.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic