Getting the number of Rows from a MySQL table using Java

Question

I've seen a lot of similar questions which try to achieve this by using a while loop to count the entries. But I was hoping that there would be a way similar to this which could work? String SQL = "SELECT Name FROM (table name) TABLE WHERE SCHEMA

    PreparedStatement statement = conn.prepareStatement(SQL);
    ResultSet a = statement.executeQuery();
    System.out.println(a);

select count(foo) from bar + int numRows = result.getInt(1) in a separate query would work without much data traffic and without a loop — dly
– dly, Commented Aug 19, 2015 at 11:07
possible duplicate of Get Number of Rows returned by ResultSet in Java — Jordi Castilla
– Jordi Castilla, Commented Aug 19, 2015 at 11:09

Uma Kanth · Accepted Answer · 2015-08-19 11:00:16Z

1

Maybe you could use count.

SELECT COUNT(column_name) FROM table_name;

Or you could do it using a variable.

int count = 0;
while(rs.next())
  count ++;

edited Aug 19, 2015 at 11:00

answered Aug 19, 2015 at 10:58

Uma Kanth

5,6292 gold badges22 silver badges43 bronze badges

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

1 Comment

Danyal Sandeelo Over a year ago

he will have to query again to get the data

Community · Accepted Answer · 2017-05-23 12:29:42Z

0

ResultSet.last() followed by ResultSet.getRow() will give you the row count, but it may not be a good idea as it can mean reading the entire table over the network and throwing away the data

if(rs.last()){
   rowCount = rs.getRow(); 
   rs.beforeFirst();
}

via : How do I get the size of a java.sql.ResultSet?

edited May 23, 2017 at 12:29

CommunityBot

11 silver badge

answered Aug 19, 2015 at 11:00

Danyal Sandeelo

12.4k10 gold badges57 silver badges90 bronze badges

Collectives™ on Stack Overflow

Getting the number of Rows from a MySQL table using Java

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related