Examples of java.sql.ResultSet.relative()

java.sql.ResultSet.relative()
Moves the cursor position up or down by a specified number of rows. If the new position is beyond the start or end rows, the cursor position is set before the first row/after the last row. @param rows a number of rows to move the cursor - may be positive or negative @return true if the new cursor position is on a row, false otherwise @throws SQLException if a database error happens


        assertTrue(rs.last());
        assertEquals(3, rs.getInt(1));
        assertEquals(3, rs.getRow());


        assertTrue(rs.relative(0));
        assertEquals(3, rs.getRow());


        assertTrue(rs.relative(-1));
        assertEquals(2, rs.getRow());

View Full Code Here

        assertEquals(3, rs.getRow());


        assertTrue(rs.relative(0));
        assertEquals(3, rs.getRow());


        assertTrue(rs.relative(-1));
        assertEquals(2, rs.getRow());


        assertTrue(rs.relative(1));
        assertEquals(3, rs.getRow());

View Full Code Here

        assertEquals(3, rs.getRow());


        assertTrue(rs.relative(-1));
        assertEquals(2, rs.getRow());


        assertTrue(rs.relative(1));
        assertEquals(3, rs.getRow());


        assertFalse(rs.relative(100));
        assertTrue(rs.isAfterLast());

View Full Code Here

        assertEquals(2, rs.getRow());


        assertTrue(rs.relative(1));
        assertEquals(3, rs.getRow());


        assertFalse(rs.relative(100));
        assertTrue(rs.isAfterLast());


        assertFalse(rs.absolute(0));
        assertEquals(0, rs.getRow());

View Full Code Here

                System.out.println(tmpIndex);
            }


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


                tmpIndex = scrollableSet.getInt(3);


                System.out.println(tmpIndex);
            }

View Full Code Here


      ArrayList<CacheData> entryList = new ArrayList<CacheData>();


      ResultSet rs = pstmt.executeQuery();


      rs.relative(offset);
      while (rs.next()) {
        byte []keyHash = rs.getBytes(1);


        byte []valueHash = rs.getBytes(2);
        byte []cacheHash = rs.getBytes(3);

View Full Code Here


      ArrayList<CacheData> entryList = new ArrayList<CacheData>();


      ResultSet rs = pstmt.executeQuery();


      rs.relative(offset);
      while (rs.next()) {
        byte []keyHash = rs.getBytes(1);


        byte []valueHash = rs.getBytes(2);
        byte []cacheHash = rs.getBytes(3);

View Full Code Here

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


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

View Full Code Here

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


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

View Full Code Here

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


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

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.