• 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
Marshal
Posts: 34214
341
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:
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic