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

        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

                assertSQLState("XJ061",se);
            else
                assertSQLState("XJ125",se);
        }
        try {
            rs.afterLast();
            fail("afterLast() not allowed on forward only result set");
        } catch(SQLException se) {
            if (usingEmbedded())
                assertSQLState("XJ061",se);
            else

View Full Code Here

            rs.next();
            assertEquals("c",rs.getString(1).trim());
            assertEquals(3, rs.getInt(2));
            assertEquals(2,rs.getRow());
            
            rs.afterLast();
            assertNoCurrentRow(rs);
            
            assertEquals(0,rs.getRow());
            assertFalse(rs.next());
            assertNoCurrentRow(rs);

View Full Code Here

            assertEquals(1, rs.getRow());
            rs.close();
            
            // afterLast first
            rs = ps_c1.executeQuery();
            rs.afterLast();
            assertNoCurrentRow(rs);
            rs.previous();
            
            assertEquals("m",rs.getString(1).trim());
            assertEquals(13, rs.getInt(2));

View Full Code Here

            rs.previous();
            assertEquals("l",rs.getString(1).trim());
            assertEquals(12, rs.getInt(2));
            assertEquals(2, rs.getRow());
            
            rs.afterLast();
            assertNoCurrentRow(rs);
            
            rs.previous();
            assertEquals("m",rs.getString(1).trim());
            assertEquals(13, rs.getInt(2));

View Full Code Here

            assertEquals(13, rs.getInt(2));
            assertEquals(3, rs.getRow());
            rs.close();
            // start at after ;ast/
            rs = ps_c1.executeQuery();
            rs.afterLast();
            assertNoCurrentRow(rs);
            
            rs.previous();
            assertEquals("m",rs.getString(1).trim());
            assertEquals(13, rs.getInt(2));

View Full Code Here

        catch (SQLException e)
        {
        }
        try
        {
            rs.afterLast();
            fail("afterLast() on a TYPE_FORWARD_ONLY resultset did not throw an exception on a TYPE_FORWARD_ONLY resultset");
        }
        catch (SQLException e)
        {
        }

View Full Code Here


    public void testBackward() throws SQLException
    {
        Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
        ResultSet rs = stmt.executeQuery("SELECT * FROM testrs");
        rs.afterLast();
        assertTrue(rs.previous());
        rs.close();
        stmt.close();
    }

View Full Code Here

    public void testEmptyResult() throws SQLException
    {
        Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
        ResultSet rs = stmt.executeQuery("SELECT * FROM testrs where id=100");
        rs.beforeFirst();
        rs.afterLast();
        assertTrue(!rs.first());
        assertTrue(!rs.last());
        assertTrue(!rs.next());
    }

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.