Examples of java.sql.ResultSet.deleteRow()

java.sql.ResultSet.deleteRow()
Deletes the current row from the ResultSet and from the underlying database. @throws SQLException if a database error happens


        rs.afterLast();
        checkDetectabilityCallsOutsideRow(rs, "on afterLast row");


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


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

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.updateInt(2, 666);
        rs.updateRow();
        checkDetectabilityCallsOutsideRow(rs, "after FO updateRow");


        rs.next();
        rs.deleteRow();
        checkDetectabilityCallsOutsideRow(rs, "after FO deleteRow");


        while (rs.next()) {};
        checkDetectabilityCallsOutsideRow(rs, "after FO emptied out");

View Full Code Here

        rs.updateInt(2,42);
        rs.insertRow();


        // Delete a row
        rs.previous();
        rs.deleteRow();


        // .. and see that a hole is left in its place
        rs.previous();
        rs.next();
        assertTrue(rs.rowDeleted());

View Full Code Here

    }


    public void delete() {
        try {
            ResultSet resultSet = scrollResultSet();
            resultSet.deleteRow();
            isDeleted = true;
            isModified = false;
            isNew = false;
        } catch (SQLException e) {
            MessageUtil.showErrorDialog("Could not delete row at index " + getIndex() + ".", e);

View Full Code Here

      String whereClause = getWhereClause(folder, key);
      resultSet = getTableResultSet(folder, whereClause, true);
      if (resultSet != null) {
                startResultSet(resultSet);
        if (resultSet.next()) {
          resultSet.deleteRow();
          if (getConnection().getAutoCommit() == false) {
              getConnection().commit();
          }
        }
                else {

View Full Code Here

        assertTrue(test1.next());
        assertEquals(1, test1.getInt("a"));
        assertEquals(10,test1.getInt("data"));
        commit();
        try {
            test1.deleteRow();
            fail("Should be unable to delete row!");
        } catch (SQLException e) { assertSQLState("XJ083", e); }
        assertTrue(test1.next());
        assertEquals(1, test1.getInt("a"));
        assertEquals(20,test1.getInt("data"));

View Full Code Here

        assertEquals(10,test1.getInt("data"));
        commit();
        assertTrue(test1.next());
        assertEquals(1, test1.getInt("a"));
        assertEquals(20,test1.getInt("data"));
        test1.deleteRow();
        commit();
        assertTrue(test1.next());
        assertEquals(1, test1.getInt("a"));
        assertEquals(30,test1.getInt("data"));
        assertTrue(test1.next());

View Full Code Here

        rs.updateInt(2,42);
        rs.insertRow();


        // Delete a row
        rs.previous();
        rs.deleteRow();


        // .. and see that a hole is left in its place
        rs.previous();
        rs.next();
        assertTrue(rs.rowDeleted());

View Full Code Here

        assertEquals("Did not expect the resultset to be updated", oldValue, rs.getInt(2));
        assertTrue("Expected rs.rowDeleted() to be false", !rs.rowDeleted());
        assertTrue("Expected rs.rowUpdated() to be false", !rs.rowUpdated());
        
        rs.clearWarnings();
        rs.deleteRow();
        warn = rs.getWarnings();
        assertWarning(warn, CURSOR_OPERATION_CONFLICT);
        rs.relative(0);
        assertTrue("Expected rs.rowUpdated() to be false", !rs.rowUpdated());
        assertTrue("Expected rs.rowDeleted() to be false", !rs.rowDeleted());

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.