How to convert ResultSet into a useful integer?

Question

I am trying to perform an SQL query to see how many records there are in my table. The SQL that I'm using for this is SELECT COUNT(*) FROM myTable; The query is then being executed and stored in a ResultSet.

int recordNumber = 0;
    String sqlString = "SELECT COUNT(*) FROM myTable;";
    try {
        ResultSet resultSet = stmt.executeQuery(sqlString);
        resultSet.next();
        recordNumber = Integer.parseInt(rst);
    } catch (Exception e) {}

My questions is how do I get the number of records out of the ResultSet?

Mureinik · Accepted Answer · 2016-03-03 21:08:44Z

6

A ResultSet has a series of getXYZ(int) methods to retrieve columns from it by their relative index and corresponding getXYZ(String) methods to retrieve those columns by their alias. In your case, using the index variant getInt(int) would be the easiest:

recordNumber = resultSet.getInt(1);

answered Mar 3, 2016 at 21:08

Mureinik

316k54 gold badges400 silver badges405 bronze badges

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

Comments

Abdelhak · Accepted Answer · 2016-03-03 21:13:16Z

4

Try to use this query adding a name count to column like this :

  String sqlString = "SELECT COUNT(*) as count FROM myTable";

And then with getInt(..) you can retrieve the value like this:

    if(resultSet.next())
     recordNumber = resultSet.getInt(count);// with name of column

Or using the index of column like this:

    if(resultSet.next())
     recordNumber = resultSet.getInt(1);

edited Mar 3, 2016 at 21:13

answered Mar 3, 2016 at 21:06

Abdelhak

8,4154 gold badges25 silver badges37 bronze badges

1 Comment

rkosegi Over a year ago

why you call Integer.parseInt where ResultSet#getInt already returns int?

Collectives™ on Stack Overflow

How to convert ResultSet into a useful integer?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related