Examples of java.sql.ResultSet.afterLast()

java.sql.ResultSet.afterLast()
Moves the Cursor to the end of the ResultSet, after the last row. @throws SQLException if a database error happens


        // Test that it is possible to move afterLast from insertRow
        currentPosition = rs.getRow();
        rs.moveToInsertRow();
        rs.updateInt(1, currentPosition + 1000);
        rs.afterLast();
        assertTrue("isAfterLast() should return true", rs.isAfterLast());
        rs.previous();
        assertEquals("CurrentPosition should be " + lastRow, 
                rs.getRow(), lastRow);
        assertTrue("isLast() should return true", rs.isLast());

View Full Code Here

        rs.moveToCurrentRow(); // needed until to DERBY-1322 is fixed


        rs.beforeFirst();
        checkDetectabilityCallsOutsideRow(rs, "on beforeFirst row");


        rs.afterLast();
        checkDetectabilityCallsOutsideRow(rs, "on afterLast row");


        rs.first();
        rs.deleteRow();
        checkDetectabilityCallsOutsideRow(rs, "after deleteRow");

View Full Code Here

        rs.absolute(3);
        rs.relative(-1);
        rs.first();
        rs.last();
        rs.beforeFirst();
        rs.afterLast();
        
        // close result set and statement
        rs.close();
        s.close();
    }

View Full Code Here

                connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                                           ResultSet.CONCUR_READ_ONLY);


            ResultSet srs = statement.executeQuery("select * from t1 limit 2");


            srs.afterLast();


            while (srs.previous()) {
                String name = srs.getString(2);
                float  id   = srs.getFloat(1);

View Full Code Here

        rs.absolute(3);
        rs.relative(-1);
        rs.first();
        rs.last();
        rs.beforeFirst();
        rs.afterLast();
        
        // close result set and statement
        rs.close();
        s.close();
    }

View Full Code Here


        // Test that it is possible to move afterLast from insertRow
        currentPosition = rs.getRow();
        rs.moveToInsertRow();
        rs.updateInt(1, currentPosition + 1000);
        rs.afterLast();
        assertTrue("isAfterLast() should return true", rs.isAfterLast());
        rs.previous();
        assertEquals("CurrentPosition should be " + lastRow, 
                rs.getRow(), lastRow);
        assertTrue("isLast() should return true", rs.isLast());

View Full Code Here

        rs.moveToCurrentRow(); // needed until to DERBY-1322 is fixed


        rs.beforeFirst();
        checkDetectabilityCallsOutsideRow(rs, "on beforeFirst row");


        rs.afterLast();
        checkDetectabilityCallsOutsideRow(rs, "on afterLast row");


        rs.first();
        rs.deleteRow();
        checkDetectabilityCallsOutsideRow(rs, "after deleteRow");

View Full Code Here

        // done
        rs.close();


        // Empty result set tests (DERBY-992)
        rs = s_i_r.executeQuery("select * from t where 1=0");
        rs.afterLast();
        assertFalse("afterLast() on empty RS should be no-op", rs.isAfterLast());
        rs.beforeFirst();
        assertFalse("beforeFirst() on empty RS should be no-op", rs
                .isBeforeFirst());

View Full Code Here

        assertFalse(rs.previous());
        rs.close();
        rs = s_i_r.executeQuery("values 1, 2, 3, 4, 5, 6");
        assertNotNull(rs);


        rs.afterLast();
        // Iterate backwards thru RS, expect only 5 rows.
        for (int index = 1; index < 6; index++) {
            assertTrue(rs.previous());


        }

View Full Code Here

        }
        // We should not see another row (only maxRows, not total)
        assertFalse(rs.next());


        // Start from afterLast and verify maxRows
        rs.afterLast();
        // Iterate backwards thru RS, expect only (maxRows - 1) rows.
        for (int index = 1; index < maxRows + 1; index++) {
            assertTrue(rs.previous());
            assertEquals(maxRows - index + 1, rs.getInt(1));
        }

View Full Code Here

0 1 2 3 4 5 6

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.