Check if MySQL result returning rows

Question

I have following Java code

// SELECT
String stringQuery  = "SELECT klucz, itemDATA, itemQTY, itemDUR FROM sellbox WHERE gracz =? "
                    + "ORDER BY czas DESC LIMIT 1";

PreparedStatement statement = this.connection.prepareStatement( stringQuery );
statement.setString( 1, playerName ); 

ResultSet queryResult = statement.executeQuery();
queryResult.first();

How to determine if it returned rows or not?

NPE · Accepted Answer · 2012-12-20 14:00:39Z

1

You could do:

ResultSet queryResult = statement.executeQuery();
if (queryResult.next()) {
   // process the data
}

answered Dec 20, 2012 at 14:00

NPE

503k114 gold badges970 silver badges1k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vinay Veluri · Accepted Answer · 2012-12-20 14:14:20Z

1

ResultSet provides next() to check the next rows. using ResultSet.first() it self gives false if invalid rows in ResultSet

Reference: ResultSet API

So using the same method, you can verify the rows in ResultSet without using ResultSet.next()

answered Dec 20, 2012 at 14:14

Vinay Veluri

6,8755 gold badges36 silver badges59 bronze badges

Comments

Subhrajyoti Majumder · Accepted Answer · 2012-12-20 14:24:36Z

1

I think this is the way -

ResultSet queryResult = statement.executeQuery();
if(queryResult.next())
  return true;
else
  return false;

edited Dec 20, 2012 at 14:24

answered Dec 20, 2012 at 14:00

Subhrajyoti Majumder

41.3k13 gold badges84 silver badges103 bronze badges

Collectives™ on Stack Overflow

Check if MySQL result returning rows

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related