Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to check if resultset has only one row or more?

 
Vidya Moorthy
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have to do a query to a table. If resultset has only one row, I have to set the bean in one particular way and if the resultset has multiple rows in a different way.
I tried


The problem with this code is even if the row count from the query is one, it sets ABC into the bean.
Should I try to get the count and then check if count > 1? If that is the case, then I have to do two queries, one to get the count and the other to do the query itself. Please advise.
Thanks in advance
Vidyaram

 
Paul Clapham
Sheriff
Posts: 21579
33
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Just read the records to find out how many there are:


But if it were me I would be considering writing a query involving "count(*)" rather than potentially returning a large number of rows just to ignore them.
 
Seetharaman Venkatasamy
Ranch Hand
Posts: 5575
Eclipse IDE Java Windows XP
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Paul Clapham wrote:But if it were me I would be considering writing a query involving "count(*)" rather than potentially returning a large number of rows just to ignore them.

Indeed; this is the best way
 
Vidya Moorthy
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you for posting the answers quickly!

Vidyaram
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic