Examples of java.sql.ResultSet.last()

java.sql.ResultSet.last()
Shifts the cursor position to the last row of the ResultSet. @return true if the new position is in a legitimate row, false if theResultSet contains no rows. @throws SQLException if there is a database error

            (ResultSet.TYPE_SCROLL_INSENSITIVE,
             ResultSet.CONCUR_UPDATABLE);
        s.setCursorName(getNextCursorName());
        ResultSet rs = s.executeQuery("select * from t1");
        
        rs.last();
        rs.next();
        int newKey = 0;
        while(rs.previous()) {
            // Update the secondary key of all rows
            rs.updateInt(2, newKey--);

View Full Code Here

            (ResultSet.TYPE_SCROLL_INSENSITIVE,
             ResultSet.CONCUR_UPDATABLE);
        s.setCursorName(getNextCursorName());
        ResultSet rs = s.executeQuery("select * from t1");
        
        rs.last();
        int indexedKey = rs.getInt(2);
        PreparedStatement ps =
            prepareStatement("update t1 set a = ? where a= ?");
        ps.setInt(1, -indexedKey);
        ps.setInt(2, indexedKey);

View Full Code Here

        
        s.setCursorName(getNextCursorName());
        ResultSet rs =
            s.executeQuery("select * from t1");
        
        rs.last();
        lastRow = rs.getRow();
        
        rs.beforeFirst();
        
        rs.next();

View Full Code Here


        // Test that it is possible to move to last row from insertRow
        currentPosition = rs.getRow();
        rs.moveToInsertRow();
        rs.updateInt(1, currentPosition + 1000);
        rs.last();
        assertEquals("CurrentPosition should be " + lastRow, 
                rs.getRow(), lastRow);
        assertTrue("isLast() should return true", rs.isLast());
        // should be able to delete the row
        rs.deleteRow();

View Full Code Here


        rs.first();
        rs.deleteRow();
        checkDetectabilityCallsOutsideRow(rs, "after deleteRow");


        rs.last();
        rs.deleteRow();
        checkDetectabilityCallsOutsideRow(rs, "after deleteRow of last row");


        rs.close();
        s.close();

View Full Code Here

        rs.previous();
        rs.relative(1);
        rs.absolute(3);
        rs.relative(-1);
        rs.first();
        rs.last();
        rs.beforeFirst();
        rs.afterLast();
        
        // close result set and statement
        rs.close();

View Full Code Here


    ps.execute();


    ResultSet result = ps.getResultSet();


    result.last();


    Object[][] rows = new Object[result.getRow()][6];


    result.beforeFirst();

View Full Code Here

               " AND (Directories.DropDate < '" + start +"' OR Directories.DropDate IS NULL)" +
               " AND (Files.DropDate < '" + start + "' OR Files.DropDate IS NULL))" +
               " AND addDate < '" + start + "' ORDER BY addDate";
      System.out.println(query);
      ResultSet rs = contentQuery.executeQuery(query);
      rs.last();
      System.out.println(rs.getRow());
      if (rs.getRow() == 0)
        {
        fileContentStart = start;
        }

View Full Code Here

        }
      rs.close();
      //now query the change table for changes between the contents and the start time for the replay
      //and apply those changes to the initial state before sending
      rs = contentQuery.executeQuery(buildChangeSetQuery(fileContentStart, start, path));
      rs.last();
      if (rs.getRow() != 0)
        {
        rs.first();
        for (rs.first(); !rs.isAfterLast(); rs.next())
          {

View Full Code Here

    try
      {
      Statement st = conn.createStatement();
      System.out.println(buildChangeSetQuery(start, end, path));
        rs = st.executeQuery(buildChangeSetQuery(start, end, path));
        rs.last();
        if(rs.getRow() == 0)
          {
          rs.close();
          return;
          }

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.