Java Forum

Ask Question   UnAnswered
Home » Forum » Java       RSS Feeds

Get records count

  Asked By: Jason    Date: Feb 25    Category: Java    Views: 886

I have used a " prepareStatement " to search a table like code below.After running executeQuery, how can I distinguish number of records ? I want to print message if no data found.

PreparedStatement state = con.prepareStatement("SELECT * FROM tbname WHERE name = ?");
inputSearch =JOptionPane.showInputDialog( "Enter name to search " );
ResultSet result = state.executeQuery();



1 Answer Found

Answer #1    Answered By: Patricia Johnson     Answered On: Feb 25

you can get resultset.next() value to check if the result  set is empty or not.
for getting the number  of result :: you can count  it by an iteration on resultset.next()

Didn't find what you were looking for? Find more on Get records count Or get search suggestion and latest updates.