How to check object result is more then 0 in Java

Question

I have the following code to get and return records count from the database and assign it into the object.

rs = stmt.executeQuery( "SELECT COUNT(*) FROM TEST" );

I have the following code to check whether records is found:

    if (rs.next() && rs.getString( 1 ).equals( "1" )) {
        logger.info( "DID Find Records !!! " );
    } else {
        logger.info( "DID NOT Find Records !!! " );
    }

How can I check return records is more then 0 in this case?

why don't you do `if (rs.next() && rs.getInt(1) > 0 ))` instead of `if (rs.next() && rs.getString( 1 ).equals( "1" ))`? or did I misunderstand your question? — Kartik, Aug 28 '18 at 01:31
looks like just `if (rs.next())` is fine. refer: https://stackoverflow.com/questions/867194/java-resultset-how-to-check-if-there-are-any-results — Troy Young, Aug 28 '18 at 01:39

score 1 · Accepted Answer · answered Aug 28 '18 at 01:38

1

Replace

if (rs.next() && rs.getString( 1 ).equals( "1" ))

by

if (rs.next() && rs.getInt(1) > 0))

answered Aug 28 '18 at 01:38

Kartik

7,677
4
28
50

SagarScript · Answer 2 · 2018-08-31T02:54:51.067

0

You will need to use an alias, then extract the returned count from rs as an integer, simply change your code to this:

  rs = stmt.executeQuery( "SELECT COUNT(*) FROM TEST AS TESTCOUNT" );
  rs.next();
  if (rs.getInt("TESTCOUNT") > 0) {
    logger.info( "DID Find Records !!! " );
  } else {
    logger.info( "DID NOT Find Records !!! " );
  }

where 'TESTCOUNT' is the alias name given.

edited Aug 31 '18 at 02:54

answered Aug 28 '18 at 01:19

SagarScript

1,145
11
15

Your code is missing `rs.next()`. Result sets are initially positioned **before** the first row, not on the first row. – Mark Rotteveel Aug 28 '18 at 09:50

score 0 · Answer 3 · answered Aug 28 '18 at 01:21

0

rs.getString( 1 ) contains value of row count from database. Just parse it to Integer to the number of rows

 if (rs!=null && rs.next()) {
        logger.info( "DID Find Records !!! " );
        logger.info( "RowCount "+ Integer.valueOf(rs.getString( 1 )));
    } else {
        logger.info( "DID NOT Find Records !!! " );
    }

answered Aug 28 '18 at 01:21

sc1234

23
1
4

There is not need to use `Integer.valueOf(rs.getString( 1 ))`, using `rs.getInt(1)` works well enough. And `executeQuery` should **never** return `null`, so that null-check is unnecessary. – Mark Rotteveel Aug 28 '18 at 09:51
Then an exception would be thrown. – Mark Rotteveel Aug 29 '18 at 06:58

score 0 · Answer 4 · answered Aug 28 '18 at 01:22

Make it to a int variable and do the checks...!

ResultSet rs = .....;

int count = -1;

if (rs.next())
    count = rs.getInt(1);

if (count <= 0)
{
    logger.info("no records");
}
else if (count == 1)
{
    logger.info("found 1 record");
}
else
{
    logger.info("found more...");
}bb

How to check object result is more then 0 in Java

4 Answers4