Examples of java.sql.ResultSet.absolute()

java.sql.ResultSet.absolute()
Moves the Cursor to a specified row number in the ResultSet. @param row The new row number for the Cursor @return true if the new Cursor position is on the ResultSet, falseotherwise @throws SQLException if a database error happens

        ResultSet rs = stmt.executeQuery("SELECT * FROM testrs");


        assertTrue(!rs.absolute(0));
        assertEquals(0, rs.getRow());


        assertTrue(rs.absolute( -1));
        assertEquals(6, rs.getRow());


        assertTrue(rs.absolute(1));
        assertEquals(1, rs.getRow());

View Full Code Here

        assertEquals(0, rs.getRow());


        assertTrue(rs.absolute( -1));
        assertEquals(6, rs.getRow());


        assertTrue(rs.absolute(1));
        assertEquals(1, rs.getRow());


        assertTrue(!rs.absolute( -10));
        assertEquals(0, rs.getRow());
        assertTrue(rs.next());

View Full Code Here

        assertEquals(6, rs.getRow());


        assertTrue(rs.absolute(1));
        assertEquals(1, rs.getRow());


        assertTrue(!rs.absolute( -10));
        assertEquals(0, rs.getRow());
        assertTrue(rs.next());
        assertEquals(1, rs.getRow());


        assertTrue(!rs.absolute(10));

View Full Code Here

        assertTrue(!rs.absolute( -10));
        assertEquals(0, rs.getRow());
        assertTrue(rs.next());
        assertEquals(1, rs.getRow());


        assertTrue(!rs.absolute(10));
        assertEquals(0, rs.getRow());
        assertTrue(rs.previous());
        assertEquals(6, rs.getRow());


        stmt.close();

View Full Code Here

        ResultSet rs = null;
        try {
            s = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            s.setFetchSize(toIndex - fromIndex);
            rs = s.executeQuery(statements.getFindAllIdsStatement());
            rs.absolute(fromIndex + 1);
            String[] ids = new String[toIndex - fromIndex];
            for (int row = 0; row < toIndex - fromIndex; row++) {
                ids[row] = rs.getString(1);
                if (!rs.next()) {
                    break;

View Full Code Here

    stat.execute("INSERT INTO test SELECT X FROM SYSTEM_RANGE(1, 200)");
    Statement s2 = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
        ResultSet.CONCUR_READ_ONLY);
    ResultSet rs = s2.executeQuery("SELECT * FROM test ORDER BY ID");
    for (int i = 100; i > 0; i--) {
      rs.absolute(i);
      assertEquals(i, rs.getInt(1));
    }
    stat.execute("DROP TABLE test");
  }

View Full Code Here

                resultSet = executeSelect(dbCall, statement, session);
                if (!isInBatchWritingMode(session)) {
                    readStatementsCount++;
                }
                if (!dbCall.shouldIgnoreFirstRowMaxResultsSettings() && dbCall.getFirstResult() != 0) {
                    resultSet.absolute(dbCall.getFirstResult());
                }
                ResultSetMetaData metaData = resultSet.getMetaData();
                dbCall.matchFieldOrder(resultSet, this, session);


                if (dbCall.isCursorReturned()) {

View Full Code Here

        if (resultSetType==ResultSet.TYPE_FORWARD_ONLY) {
            for (int i = 0; i < recordToUpdate; i++) {
                rs.next();
            }
        } else {
            rs.absolute(recordToUpdate);
        }
        
        commit();
        
        PreparedStatement ps =

View Full Code Here

    {
        Statement s = createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                                          ResultSet.CONCUR_UPDATABLE);
        s.setCursorName(getNextCursorName());
        ResultSet rs = s.executeQuery("select * from t1");
        rs.absolute(5);
        final int oldCol2 = rs.getInt(2);
        final int newCol2 = -2222;
        final int oldCol3 = rs.getInt(3);
        final int newCol3 = -3333;

View Full Code Here

    {
        Statement s = createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                                          ResultSet.CONCUR_UPDATABLE);
        s.setCursorName(getNextCursorName());
        ResultSet rs = s.executeQuery("select * from t1");
        rs.absolute(5);
        final int oldCol2 = rs.getInt(2);
        final int oldCol3 = rs.getInt(3);
        
        rs.updateNull(2);
        assertEquals("Expected the resultset to be updated after updateNull",

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.