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


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

View Full Code Here


        rs.first();
        updateClobWithUpdateCharacterStream(rs);
        rs.next();
        updateClobWithUpdateCharacterStream(rs);
        rs.relative(3);
        updateClobWithUpdateCharacterStream(rs);
        rs.absolute(7);
        updateClobWithUpdateCharacterStream(rs);
        rs.previous();
        updateClobWithUpdateCharacterStream(rs);

View Full Code Here


        rs.first();
        checkContentsBeforeAndAfterUpdatingBlob(rs);
        rs.next();
        checkContentsBeforeAndAfterUpdatingBlob(rs);
        rs.relative(3);
        checkContentsBeforeAndAfterUpdatingBlob(rs);
        rs.absolute(7);
        checkContentsBeforeAndAfterUpdatingBlob(rs);
        rs.previous();
        checkContentsBeforeAndAfterUpdatingBlob(rs);

View Full Code Here


        rs.first();
        updateBlobWithUpdateBinaryStream(rs);
        rs.next();
        updateBlobWithUpdateBinaryStream(rs);
        rs.relative(3);
        updateBlobWithUpdateBinaryStream(rs);
        rs.absolute(7);
        updateBlobWithUpdateBinaryStream(rs);
        rs.previous();
        updateBlobWithUpdateBinaryStream(rs);

View Full Code Here

        concurrency);
    ResultSet rs = stmt1.executeQuery("select * from testRelative");


    rs.next(); // First Record
    assertEquals("work1", rs.getString("name"));
    rs.relative(2);
    assertEquals("work3", rs.getString("name"));
    assertEquals(false, rs.isFirst());
    assertEquals(false, rs.isLast());
    assertEquals(false, rs.isAfterLast());
    rs.relative(-2);

View Full Code Here

    rs.relative(2);
    assertEquals("work3", rs.getString("name"));
    assertEquals(false, rs.isFirst());
    assertEquals(false, rs.isLast());
    assertEquals(false, rs.isAfterLast());
    rs.relative(-2);
    assertEquals("work1", rs.getString("name"));


    rs.relative(10);
    try {
      /*

View Full Code Here

    assertEquals(false, rs.isLast());
    assertEquals(false, rs.isAfterLast());
    rs.relative(-2);
    assertEquals("work1", rs.getString("name"));


    rs.relative(10);
    try {
      /*
       * Attempting to move beyond the first/last row in the result set
       * positions the cursor before/after the the first/last row.
       * Therefore, attempting to get value will throw an exception.

View Full Code Here

        concurrency);
    ResultSet rs = stmt1.executeQuery("select * from testRelative");


    rs.next(); // First Record
    assertEquals("work1", rs.getString("name"));
    rs.relative(2);
    assertEquals("work3", rs.getString("name"));
    assertEquals(false, rs.isFirst());
    assertEquals(false, rs.isLast());
    assertEquals(false, rs.isAfterLast());
    rs.relative(-2);

View Full Code Here

    rs.relative(2);
    assertEquals("work3", rs.getString("name"));
    assertEquals(false, rs.isFirst());
    assertEquals(false, rs.isLast());
    assertEquals(false, rs.isAfterLast());
    rs.relative(-2);
    assertEquals("work1", rs.getString("name"));


    rs.relative(10);
    try {
      /*

View Full Code Here

    assertEquals(false, rs.isLast());
    assertEquals(false, rs.isAfterLast());
    rs.relative(-2);
    assertEquals("work1", rs.getString("name"));


    rs.relative(10);
    try {
      /*
       * Attempting to move beyond the first/last row in the result set
       * positions the cursor before/after the the first/last row.
       * Therefore, attempting to get value now will throw an exception.

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.