• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

ResultSet and count urgent please help

 
santosh vashist
Greenhorn
Posts: 25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,
I am using a ResultSet to retriev data from database. After the action i want to know whether any record is present or not.
What i have done is I have used
if(Rs.next())
{
out.println("present")
}
The problem is My result set returns only one record and if i say rs.next() to check the presence of any record the pointer will move to first record.
Next if i have to take the record to some variable i use
while (rs.next())
{
temp=rs.getString("name");
}
here i am getting an exception as because the pointer has already moved and there is no record.
So how to check for presence of any record in a resultset without using .next() method.
it would be greate if any body tells the solution for this.
thanks in advance
santosh
 
Carl Trusiak
Sheriff
Posts: 3341
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Only call next() test in the condition of the while loop. It will give you the results your after. If there aren't any results returned, the very first call to while(rs.next()) will return false and the code inside will not be executed.
------------------
Hope This Helps
Carl Trusiak, SCJP2
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic