• Post Reply Bookmark Topic Watch Topic
  • New Topic

a basic question

 
Arul Jose
Ranch Hand
Posts: 131
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

how do you execute this query?

select count(*) from tablename;

the return type is int right?

so how do you execute, i mean

using stmt.execute or executeUpdate or executeQuery ???
 
latha yeduguri
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can do that with stmt.executeQuery.
 
Kj Reddy
Ranch Hand
Posts: 1704
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Use executeQuery() method. It will return you ResultSet.
Using getInt() method of ResultSet you can get the count.
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 36017
427
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Arul,
Note that you have to point to the first row before you call rs.next(). So it looks like:
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!