Get Number of Rows returned by ResultSet in Java

by

First, you should create Statement which can be move cursor by command:

Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);

Then retrieve the ResultSet as below:

ResultSet rs = stmt.executeQuery(...);

Move cursor to the latest row and get it:

if (rs.last()) {
    int rows = rs.getRow();
    // Move to beginning
    rs.beforeFirst();
    ...
}

Then rows variable will contains number of rows returned by sql

More Related Contents:

  1. MySQL query to get Records in Result set
  2. How do I get the size of a java.sql.ResultSet?
  3. Fastest way to write huge data in text file Java
  4. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  5. When to close Connection, Statement, PreparedStatement and ResultSet in JDBC
  6. Most efficient conversion of ResultSet to JSON?
  7. Checking for a null int value from a Java ResultSet
  8. JDBC driver throws “ResultSet Closed” exception on empty ResultSet
  9. JDBC ResultSet get columns with table alias
  10. Execute anonymous pl/sql block and get resultset in java
  11. ResultSet: Retrieving column values by index versus retrieving by label
  12. Bulk insert in Java using prepared statements batch update
  13. ResultSet.getString(1) throws java.sql.SQLException: Invalid operation at current cursor position
  14. How to get row count using ResultSet in Java?
  15. ResultSet: Exception: set type is TYPE_FORWARD_ONLY — why?
  16. How to get the number of columns from a JDBC ResultSet?
  17. How do I get the row count in JDBC?
  18. Convert a Result Set from SQL Array to Array of Strings
  19. specific date string format [duplicate]
  20. Java program to find a pallindrome [closed]
  21. Unix epoch time to Java Date object
  22. Java 8 Streams: multiple filters vs. complex condition
  23. Java Interfaces/Implementation naming convention [duplicate]
  24. Failed to resolve: com.google.firebase:firebase-core:16.0.1
  25. spring mvc rest service redirect / forward / proxy
  26. Should you always Code To Interfaces In Java [closed]
  27. How can I know if the request to the servlet was executed using HTTP or HTTPS?
  28. How to specify prefix for all controllers in Spring Boot?
  29. How do I parametrize response parsing in Java?
  30. Code for download video from Youtube on Java, Android

Leave a Comment