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


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


        // Test that it is possible to move to previous row from insertRow

View Full Code Here

        // call positioning methods
        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


            srs.close();


            srs = statement.executeQuery("select * from t1 limit 2");


            srs.absolute(3);


            while (srs.previous()) {
                String name = srs.getString(2);
                float  id   = srs.getFloat(1);

View Full Code Here

                float  id   = srs.getFloat(1);


                System.out.println(name + "   " + id);
            }


            srs.absolute(2);


            while (srs.previous()) {
                String name = srs.getString(2);
                float  id   = srs.getFloat(1);

View Full Code Here

                float  id   = srs.getFloat(1);


                System.out.println(name + "   " + id);
            }


            srs.absolute(-1);


            while (srs.previous()) {
                String name = srs.getString(2);
                float  id   = srs.getFloat(1);

View Full Code Here


            s = "SELECT * FROM T";


            ResultSet rs = st.executeQuery(s);


            rs.absolute(10);
            rs.updateString(2, "UPDATE10");
            rs.updateRow();
            rs.absolute(11);
            rs.deleteRow();
            rs.moveToInsertRow();

View Full Code Here

            ResultSet rs = st.executeQuery(s);


            rs.absolute(10);
            rs.updateString(2, "UPDATE10");
            rs.updateRow();
            rs.absolute(11);
            rs.deleteRow();
            rs.moveToInsertRow();
            rs.updateInt(1, 1011);
            rs.updateString(2, "INSERT1011");
            rs.updateString(3, "0101");

View Full Code Here

    sqlBuffer.append(firstname);
    sqlBuffer.append("%'");
    ResultSet resultSet = null;
    try {
      resultSet = excecuteScrollableQuery(sqlBuffer.toString());      
      if(resultSet.absolute(startOffset)){
        int i = 0;
        do {
          User user = new User();
          user.setId(new Integer(resultSet.getInt("ID")));
          user.setFirstname(resultSet.getString("FIRSTNAME"));

View Full Code Here

    {
        Statement s = createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                                          ResultSet.CONCUR_UPDATABLE);
        s.setCursorName(getNextCursorName());
        ResultSet rs = s.executeQuery("select * from t1");
        rs.absolute(5);
        final int oldCol2 = rs.getInt(2);
        final int oldCol3 = rs.getInt(3);
        
        rs.updateNull(2);
        assertEquals("Expected the resultset to be updated after updateNull",

View Full Code Here


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


        // Test that it is possible to move to previous row from insertRow

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.