ResultSet: relative(int rows) : ResultSet « java.sql « Java by API






ResultSet: relative(int rows)

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

public class Main {

  public static void main(String[] args) throws Exception {
    try {
      String url = "jdbc:odbc:yourdatabasename";
      String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
      String user = "guest";
      String password = "guest";

      Class.forName(driver);
      Connection connection = DriverManager.getConnection(url, user, password);

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

      String sqlQuery = "SELECT EMPNO, EName, Job, MGR, HIREDATE FROM EMP";

      ResultSet rs = stmt.executeQuery(sqlQuery);

      int rowSize = 0;
      while (rs.next()) {
        rowSize++;
      }

      System.out.println("Number of Rows in ResultSet is: " + rowSize);
      if (rowSize == 0) {
        System.out.println("Since there are no rows, exiting...");
        System.exit(0);
      }

      int cursorPosition = Math.round(rowSize / 2);

      System.out.println("Moving to position: " + cursorPosition);
      rs.absolute(cursorPosition);
      System.out.println("Name: " + rs.getString(2));

      rs.relative(-1);

      cursorPosition = rs.getRow();
      System.out.println("Moving to position: " + cursorPosition);
      System.out.println("Name: " + rs.getString(2));

      System.out.println("Moving to the first row");
      while (!rs.isFirst()) {
        rs.previous();
      }
      System.out.println("Name: " + rs.getString(2));
      connection.close();
    } catch (Exception e) {
      System.err.println(e);
    }
  }
}
           
         
  








Related examples in the same category

1.ResultSet.CLOSE_CURSORS_AT_COMMIT
2.ResultSet.CONCUR_READ_ONLY
3.ResultSet.CONCUR_UPDATABLE
4.ResultSet.HOLD_CURSORS_OVER_COMMIT
5.ResultSet.TYPE_SCROLL_INSENSITIVE
6.ResultSet.TYPE_SCROLL_SENSITIVE
7.ResultSet: TYPE_FORWARD_ONLY
8.ResultSet: absolute(int row)
9.ResultSet: beforeFirst()
10.ResultSet: cancelRowUpdates()
11.ResultSet: close()
12.ResultSet: deleteRow()
13.ResultSet: first()
14.ResultSet.getAsciiStream(int columnIndex)
15.ResultSet: getBinaryStream(int columnIndex)
16.ResultSet: getBigDecimal(int columnIndex)
17.ResultSet: getBlob(int columnIndex)
18.ResultSet: getBlob(String colName)
19.ResultSet: getBytes(int columnIndex)
20.ResultSet: getClob(int columnIndex)
21.ResultSet: getConcurrency()
22.ResultSet: getDate(int columnIndex)
23.ResultSet: getDouble(String columnLabel)
24.ResultSet: getInt(int columnIndex)
25.ResultSet: getInt(String columnName)
26.ResultSet: getMetaData()
27.ResultSet: getObject(int columnIndex)
28.ResultSet: getObject(String columnLabel)
29.ResultSet: getRef(int columnIndex)
30.ResultSet: getRow()
31.ResultSet: getShort(String columnLabel)
32.ResultSet: getString(int columnIndex)
33.ResultSet: getString(String columnLabel)
34.ResultSet: getTime(int columnIndex)
35.ResultSet: getTimestamp(int columnIndex)
36.ResultSet: getType()
37.ResultSet: getWarnings()
38.ResultSet: insertRow()
39.ResultSet: isAfterLast()
40.ResultSet: isBeforeFirst()
41.ResultSet: isFirst()
42.ResultSet: last()
43.ResultSet: moveToInsertRow()
44.ResultSet: next()
45.ResultSet: previous()
46.ResultSet: refreshRow()
47.ResultSet: setFetchSize(int rows)
48.ResultSet: updateInt(String columnLabel, int x)
49.ResultSet: updateRow()
50.ResultSet: updateDouble(int columnIndex, double x)
51.ResultSet: updateString(String columnName, String x)
52.ResultSet: wasNull()