Getting the Cursor Position in a Scrollable Result Set - Java JDBC

Java examples for JDBC:ResultSet

  1. HOME
  2. Java
  3. JDBC
  4. ResultSet

Description

Getting the Cursor Position in a Scrollable Result Set

Demo Code

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Main {

  public static void main(String[] argv) {
    try {/*www  . j  a  v  a  2s .  co  m*/
      Connection connection = null;
      // Create a scrollable result set
      Statement stmt = connection.createStatement(
          ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
      ResultSet resultSet = stmt.executeQuery("SELECT * FROM my_table");

      // Get cursor position
      int pos = resultSet.getRow();            // 0
      boolean b = resultSet.isBeforeFirst();   // true

      // Move cursor to the first row
      resultSet.next();

      // Get cursor position
      pos = resultSet.getRow();                // 1
      b = resultSet.isFirst();                 // true

      // Move cursor to the last row
      resultSet.last();

      // Get cursor position
      pos = resultSet.getRow();                // If table has 10 rows, value would be 10
      b = resultSet.isLast();                  // true

      // Move cursor past last row
      resultSet.afterLast();

      // Get cursor position
      pos = resultSet.getRow();                // If table has 10 rows, value would be 11
      b = resultSet.isAfterLast();             // true
  } catch (SQLException e) {
  }
  }
}

Related Tutorials