List of relative() Examples

Examples of 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
javax.sql.rowset.FilteredRowSet.relative()
javax.sql.rowset.JdbcRowSet.relative()
javax.sql.rowset.spi.SyncResolver.relative()
org.apache.harmony.sql.internal.rowset.SyncResolverImpl.relative()
org.apache.ojb.broker.accesslayer.OJBIterator.relative()
Moves the cursor a relative number of rows, either positive or negative. Attempting to move beyond the first/last row in the iterator positions the cursor before/after the the first/last row. Calling relative(0) is valid, but does not change the cursor position. @param row the row to move to in this iterator, by relative number
org.springbyexample.mvc.bind.annotation.RestRequestResource.relative()

Examples of java.sql.ResultSet.relative()

        Statement s3 = createStatement();
        int updateCount = s3.executeUpdate
            ("update t1 set A=" + newValue + 
             " where current of " + rs.getCursorName());
        
        rs.relative(0);
        SQLWarning warn = s3.getWarnings();
        assertWarning(warn, CURSOR_OPERATION_CONFLICT);
        assertTrue("Expected rs.rowUpdated() to be false", !rs.rowUpdated());
        assertTrue("Expected rs.rowDeleted() to be false", !rs.rowDeleted());
        assertEquals("Did not expect the resultset to be updated", oldValue, rs.getInt(2));

View Full Code Here

Examples of java.sql.ResultSet.relative()

        
        Statement s4 = createStatement();
        updateCount = s4.executeUpdate("delete from t1 where current of " +
                                       rs.getCursorName());
        
        rs.relative(0);
        warn = s4.getWarnings();
        assertWarning(warn, CURSOR_OPERATION_CONFLICT);
        assertTrue("Expected rs.rowUpdated() to be false", !rs.rowUpdated());
        assertTrue("Expected rs.rowDeleted() to be false", !rs.rowDeleted());
        assertEquals("Did not expect the resultset to be updated", oldValue, rs.getInt(2));

View Full Code Here

Examples of java.sql.ResultSet.relative()


        // Test that it is possible to move using relative from insertRow
        currentPosition = rs.getRow();
        rs.moveToInsertRow();
        rs.updateInt(1, currentPosition + 1000);
        rs.relative(2);
        assertEquals("CurrentPosition should be " + (currentPosition + 2), 
                rs.getRow(), currentPosition + 2);
        // should be able to delete the row
        rs.deleteRow();

View Full Code Here

Examples of java.sql.ResultSet.relative()

        
        // call positioning methods
        rs.next();
        rs.next();
        rs.previous();
        rs.relative(1);
        rs.absolute(3);
        rs.relative(-1);
        rs.first();
        rs.last();
        rs.beforeFirst();

View Full Code Here

Examples of java.sql.ResultSet.relative()

        rs.next();
        rs.next();
        rs.previous();
        rs.relative(1);
        rs.absolute(3);
        rs.relative(-1);
        rs.first();
        rs.last();
        rs.beforeFirst();
        rs.afterLast();

View Full Code Here

Examples of java.sql.ResultSet.relative()

                    numGrabbed = 0;
                }


                if(pageNum != 1){
                    // now move the cursor to the correct position
                    rs.relative(startNum);                    
                }


                // grab the rest
                while (rs.next() && numGrabbed < pageSize) {
                    String wInstId = rs.getString("workflow_instance_id");

View Full Code Here

Examples of java.sql.ResultSet.relative()

                        numGrabbed = 0;
                    }


                    // now move the cursor to the correct position
                    if (pageNum != 1) {
                        rs.relative(startNum - 1);
                    }


                    // grab the rest
                    while (rs.next() && numGrabbed < pageSize) {
                        String productId = rs.getString("product_id");

View Full Code Here

Examples of java.sql.ResultSet.relative()

                            numGrabbed = 0;
                        }


                        // now move the cursor to the correct position
                        if(pageNum != 1){
                            rs.relative(startNum-1);
                        }


                        // grab the rest
                        while (rs.next() && numGrabbed < pageSize) {
                            String productId = rs.getString("product_id");

View Full Code Here

Examples of java.sql.ResultSet.relative()

                    numGrabbed = 0;
                }


                if(pageNum != 1){
                    // now move the cursor to the correct position
                    rs.relative(startNum);                    
                }


                // grab the rest
                while (rs.next() && numGrabbed < pageSize) {
                    String wInstId = rs.getString("workflow_instance_id");

View Full Code Here

Examples of java.sql.ResultSet.relative()

                        numGrabbed = 0;
                    }


                    // now move the cursor to the correct position
                    if (pageNum != 1) {
                        rs.relative(startNum - 1);
                    }


                    // grab the rest
                    while (rs.next() && numGrabbed < pageSize) {
                        String productId = rs.getString("product_id");

View Full Code Here

0 1 2 3 4 5

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.