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(-11);
            assertEquals("c",rs.getString(1).trim());
            assertEquals(3, rs.getInt(2));
            assertEquals(2,rs.getRow());
            
            rs.absolute(13);
            assertNoCurrentRow(rs);
            assertEquals(0,rs.getRow());
            
            
            rs.absolute(-1);

View Full Code Here

            rs.absolute(13);
            assertNoCurrentRow(rs);
            assertEquals(0,rs.getRow());
            
            
            rs.absolute(-1);
            assertEquals("m",rs.getString(1).trim());
            assertEquals(13, rs.getInt(2));
            assertEquals(12, rs.getRow());
            rs.close();

View Full Code Here


        // Test with projection
        rs = stm.executeQuery(
            "select * from t1 where a + 1 < b offset 1 rows");
        // should yield 2 rows
        rs.absolute(2);
        assertTrue(rs.getInt(2) == 5);
        rs.updateInt(2, -5);
        rs.updateRow();
        rs.close();

View Full Code Here

                    throw new BadResumptionTokenException();
                }
                
                if (rs.getRow() != oldCount) {
//                  System.out.println("ExtendedJDBCOAICatalog.listIdentifiers: reuse of old resumptionToken?");
                    rs.absolute(oldCount);
                }
                
                int count;
                
                /* load the sets ArrayLists. */

View Full Code Here

                    throw new BadResumptionTokenException();
                }
                
                if (rs.getRow() != oldCount) {
//                  System.out.println("JDBCLimitedOAICatalog.listIdentifiers: reuse of old resumptionToken?");
                    rs.absolute(oldCount);
                }
                
                int count;
                
                /* load the sets ArrayLists. */

View Full Code Here

            }
            int count;
            
            if (rs.getRow() != oldCount) {
//              System.out.println("JDBCOAICatalog.listIdentifiers: reuse of old resumptionToken?");
                rs.absolute(oldCount);
            }
            
            /* load the headers and identifiers ArrayLists. */
            for (count = 0; count < maxListSize && rs.next(); ++count) {
                HashMap nativeItem = getColumnValues(rs);

View Full Code Here

                throw new BadResumptionTokenException();
            }
            
            if (rs.getRow() != oldCount) {
//              System.out.println("JDBCOAICatalog.listIdentifiers: reuse of old resumptionToken?");
                rs.absolute(oldCount);
            }
            
            int count;
            
            /* load the headers and identifiers ArrayLists. */

View Full Code Here

                    throw new BadResumptionTokenException();
                }
                
                if (rs.getRow() != oldCount) {
//                  System.out.println("JDBCOAICatalog.listIdentifiers: reuse of old resumptionToken?");
                    rs.absolute(oldCount);
                }
                
                int count;
                
                /* load the sets ArrayLists. */

View Full Code Here

        resultSetRowIndex = resultSetRowIndex + delta;
    }


    public ResultSet scrollResultSet() throws SQLException {
        ResultSet resultSet = getResultSet();
        resultSet.absolute(resultSetRowIndex);
        return resultSet;
    }


    public ResultSet getResultSet() {
        return getModel().getResultSet();

View Full Code Here

        checkContentsBeforeAndAfterUpdatingClob(rs);
        rs.next();
        checkContentsBeforeAndAfterUpdatingClob(rs);
        rs.relative(3);
        checkContentsBeforeAndAfterUpdatingClob(rs);
        rs.absolute(7);
        checkContentsBeforeAndAfterUpdatingClob(rs);
        rs.previous();
        checkContentsBeforeAndAfterUpdatingClob(rs);
        rs.last();
        checkContentsBeforeAndAfterUpdatingClob(rs);

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.