Examples of java.sql.ResultSet.last()

java.sql.ResultSet.last()
Shifts the cursor position to the last row of the ResultSet. @return true if the new position is in a legitimate row, false if theResultSet contains no rows. @throws SQLException if there is a database error

                                ResultSet.CONCUR_UPDATABLE);
        final ResultSet rs = 
            stmt.executeQuery("SELECT * from " + 
                              BLOBDataModelSetup.getBlobTableName());
        println("Last");
        rs.last();
        
        final int newVal = rs.getInt(1) + 11;
        final int newSize = rs.getInt(2) / 2;
        testUpdateBlobWithResultSetMethods(rs, newVal, newSize);

View Full Code Here

            assertEquals(12, rs.getRow());
            rs.close();
   
            rs = ps_c1.executeQuery();
            // do last first
            rs.last();
            assertEquals("m",rs.getString(1).trim());
            assertEquals(13, rs.getInt(2));
            assertEquals(12, rs.getRow());
            
            assertFalse(rs.next());

View Full Code Here

            assertEquals(12, rs.getRow());
            
            assertFalse(rs.next());
            assertNoCurrentRow(rs);
           
            rs.last();
            assertEquals("m",rs.getString(1).trim());
            assertEquals(13, rs.getInt(2));
            assertEquals(12, rs.getRow());
            
            rs.previous();

View Full Code Here

            rs.next();
            assertEquals("l",rs.getString(1).trim());
            assertEquals(12, rs.getInt(2));
            assertEquals(2, rs.getRow());
            
            rs.last();
            assertEquals("m",rs.getString(1).trim());
            assertEquals(13, rs.getInt(2));
            assertEquals(3, rs.getRow());
            
            rs.previous();

View Full Code Here

           assertEquals(13, rs.getInt(1));
           assertEquals(12, rs.getRow());
           
           rs.relative(1);
           assertNoCurrentRow(rs);
           rs.last();
           assertEquals(13, rs.getInt(1));
           assertEquals(12,rs.getRow());
           
           rs.relative(-11);
           assertEquals(2,rs.getInt(1));

View Full Code Here

            assertEquals(1,rs.getInt(1));
            rs.next();
            assertEquals(2,rs.getInt(1));
            rs.previous();
            assertEquals(1,rs.getInt(1));
            rs.last();
            assertEquals(5,rs.getInt(1));
            rs.absolute(2);
            assertEquals(2, rs.getInt(1));
            rs.relative(2);
            assertEquals(4,rs.getInt(1));

View Full Code Here

            rs = ps_c1.executeQuery();
            rs.next();
            assertEquals(1,rs.getInt(1));
            rs.close();
            rs = ps_c1.executeQuery();
            rs.last();
            assertEquals(5,rs.getInt(1));
            rs.close();
            rs = ps_c1.executeQuery();
            rs.absolute(3);
            assertEquals(3,rs.getInt(1));

View Full Code Here

            ps_c1 = conn.prepareStatement("select * from tab1",ResultSet.TYPE_SCROLL_INSENSITIVE,
                    ResultSet.CONCUR_READ_ONLY);
            rs = ps_c1.executeQuery();
            rs.first();
            assertEquals(1,rs.getInt(1));
            rs.last();
            assertEquals(70,rs.getInt(1));
            rs.absolute(65);
            assertEquals(65,rs.getInt(1));
            rs.absolute(-1);
            assertEquals(70,rs.getInt(1));

View Full Code Here

                rs.getInt(3) + ")");
        rs.updateInt(2, 3);
        println("T1: updateInt(2, 3);");
        rs.updateRow();
        println("T1: updateRow()");
        rs.last(); // Go to last tuple
        println("T1: Read last Tuple:(" + rs.getInt(1) + "," +
                rs.getInt(2) + "," +
                rs.getInt(3) + ")");
        rs.updateInt(2, 3);
        println("T1: updateInt(2, 3);");

View Full Code Here

                rs.getInt(3) + ")");
        rs.updateInt(2, 3);
        println("T1: updateInt(2, 3);");
        rs.updateRow();        
        println("T1: updateRow()");
        rs.last(); // Go to last tuple
        println("T1: Read last Tuple:(" + rs.getInt(1) + "," +
                rs.getInt(2) + "," +
                rs.getInt(3) + ")");
        rs.updateInt(2, 3);
        println("T1: updateInt(2, 3);");

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.