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

        assertEquals(3, rs.getRow());


        assertFalse(rs.absolute(4));
        assertTrue(rs.isAfterLast());


        assertFalse(rs.absolute(5));
        assertTrue(rs.isAfterLast());


        assertTrue(rs.previous());
        assertEquals(3, rs.getRow());

View Full Code Here

        cs.close();
    }
            
    @Test public void testGetCurrentRecord() throws SQLException {
        ResultSet cs =  helpExecuteQuery();
        cs.absolute(103);
        assertEquals(" Current record doesn't match with expected one.", new Integer(103), ((ResultSetImpl)cs).getCurrentRecord().get(0));                 //$NON-NLS-1$
        cs.close();
    }


    /** test close() without walking through any of the record*/

View Full Code Here

            if (op == 1) {
                boolean insert = row < 0;
                if (insert) {
                    rs.moveToInsertRow();
                } else {
                    rs.absolute(row);
                }
                for (int i = 0; i < rs.getMetaData().getColumnCount(); i++) {
                    String x = attributes.getProperty("r" + row + "c" + (i + 1));
                    unescapeData(x, rs, i + 1);
                }

View Full Code Here

                    rs.insertRow();
                } else {
                    rs.updateRow();
                }
            } else if (op == 2) {
                rs.absolute(row);
                rs.deleteRow();
            } else if (op == 3) {
                // cancel
            }
        } catch (Throwable e) {

View Full Code Here

                System.out.println("index at 0 is !=0");
            }


            //we go from 0 to 1000 with absolute and a gap of 100
            for (int i = 0; i <= 1000; i += 100) {
                scrollableSet.absolute(i + 1);


                tmpIndex = scrollableSet.getInt(3);


                System.out.println(tmpIndex);
            }

View Full Code Here

    if (! rs.isBeforeFirst())
    {
      System.out.println("expected to be before the 1st row");
      passed = false;
    }
                if (rs.absolute(0))
                {
      System.out.println("absolute(0) expected to return false");
      passed = false;
                }
    if (! rs.isBeforeFirst())

View Full Code Here

    {
      System.out.println("relative(-1) expected to return false on empty result set");
      passed = false;
    }


    if (rs.absolute(0))
    {
      System.out.println("absolute(0) expected to return false on empty result set");
      passed = false;
    }
    if (rs.absolute(1))

View Full Code Here

    if (rs.absolute(0))
    {
      System.out.println("absolute(0) expected to return false on empty result set");
      passed = false;
    }
    if (rs.absolute(1))
    {
      System.out.println("absolute(1) expected to return false on empty result set");
      passed = false;
    }

View Full Code Here

    {
      System.out.println("absolute(1) expected to return false on empty result set");
      passed = false;
    }


    if (rs.absolute(-1))
    {
      System.out.println("absolute(-1) expected to return false on empty result set");
      passed = false;
    }

View Full Code Here

                }


                rs.last();
                int rows = rs.getRow();
                
                rs.absolute(rows/2);
                if (rs.relative(-1 * (rows))) {
                    System.out.println("relative(" + -1 * (rows) + ") should return false, position outside of the resultSet");
                    
                }
                if (!rs.isBeforeFirst()) {

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.