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

           rs.absolute(5);
           assertEquals(6,rs.getInt(1));
           assertEquals(5, rs.getRow());
           rs.close();
           rs = ps_c1.executeQuery();
           rs.absolute(13);
           assertNoCurrentRow(rs);
           
           rs.previous();
           assertEquals(13, rs.getInt(1));
           assertEquals(12, rs.getRow());

View Full Code Here

           rs.previous();
           assertEquals(13, rs.getInt(1));
           assertEquals(12, rs.getRow());
           rs.close();
           rs = ps_c1.executeQuery();
           rs.absolute(-13);
           assertNoCurrentRow(rs);
           rs.next();
           assertEquals(2, rs.getInt(1));
           assertEquals(1,rs.getRow());
           rs.close();

View Full Code Here

            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));
            rs.close();
            // since JCC gets 64 results and then scrolls within them

View Full Code Here

            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));
            rs.next();
            assertEquals(4,rs.getInt(1));
            rs.close();
            ps_c1.close();

View Full Code Here

            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));
            rs.close();
            ps_c1.close();

View Full Code Here

            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));
            rs.close();
            ps_c1.close();
            // try sensitive scroll cursors bug 4677
            ps_c1 = conn.prepareStatement("select * from t1",ResultSet.TYPE_SCROLL_SENSITIVE,

View Full Code Here

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

View Full Code Here

            Connection conn = getConnection();
            conn.setAutoCommit(false);
            PreparedStatement ps_c1 = conn.prepareStatement("select * from t1",
                        ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY );
            ResultSet rs = ps_c1.executeQuery();
            rs.absolute(0);
            assertNoCurrentRow(rs);
            rs.close();
            
            rs = ps_c1.executeQuery();
            rs.relative(0);

View Full Code Here

            rs.next();
            assertEquals("b", rs.getString(1).trim());
            assertEquals(2, rs.getInt(2));
            assertEquals(1, rs.getRow());
            
            rs.absolute(12);
            assertEquals("m",rs.getString(1).trim());
            assertEquals(13, rs.getInt(2));
            assertEquals(12, rs.getRow());
            
            rs.absolute(-11);

View Full Code Here

            rs.absolute(12);
            assertEquals("m",rs.getString(1).trim());
            assertEquals(13, rs.getInt(2));
            assertEquals(12, rs.getRow());
            
            rs.absolute(-11);
            assertEquals("c",rs.getString(1).trim());
            assertEquals(3, rs.getInt(2));
            assertEquals(2,rs.getRow());
            
            rs.absolute(13);

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.