List of updateRow() Examples

Examples of updateRow()

com.nearinfinity.honeycomb.mysql.HandlerProxy.updateRow()
com.sun.star.sdbc.XResultSetUpdate.updateRow()
java.sql.ResultSet.updateRow()
Updates the database with the new contents of the current row of this ResultSet object. @throws SQLException
javax.sql.rowset.CachedRowSet.updateRow()
javax.sql.rowset.FilteredRowSet.updateRow()
javax.sql.rowset.JdbcRowSet.updateRow()
javax.sql.rowset.WebRowSet.updateRow()
javax.sql.rowset.spi.SyncResolver.updateRow()
net.bnubot.bot.database.AccountResultSet.updateRow()
net.bnubot.db.Account.updateRow()
net.bnubot.db.BNLogin.updateRow()
net.bnubot.db.Command.updateRow()
org.apache.derby.iapi.sql.dictionary.TabInfo.updateRow()
Updates a set of base rows in a catalog with same index key on an index and updates all the corresponding index rows.
LOCKING: exclusive row locking @param key key row @param newRows new version of the set of rows @param indexNumber index that key operates @param indicesToUpdate array of booleans, one for each index on the catalog.if a boolean is true, that means we must update the corresponding index because changes in the newRow affect it. @param colsToUpdate int array of columns to be updated (1 based). Ifnull, all cols are updated @param tc transaction controller @exception StandardException Thrown on failure
org.apache.derby.iapi.sql.execute.RowChanger.updateRow()
Update a row in the table and perform associated index maintenance. @param oldBaseRow the old image of the row. @param newBaseRow the new image of the row. @param baseRowLocation the row's base conglomeratelocation @exception StandardException Thrown on error
org.apache.harmony.sql.internal.rowset.SyncResolverImpl.updateRow()
org.h2.result.UpdatableRow.updateRow()
Update a row in the database. @param current the old row @param updateRow the new row @throws SQLException if the row has been deleted
org.lealone.result.UpdatableRow.updateRow()
Update a row in the database. @param current the old row @param updateRow the new row @throws SQLException if the row has been deleted

Examples of java.sql.ResultSet.updateRow()

                ps.executeUpdate();                
                fail("Expected exception to be thrown on positioned update " + 
                     "since cursor is not positioned");
            } else {
                rs.updateInt(1, -1);
                rs.updateRow();
                fail("Expected exception to be thrown on updateRow() since " +
                     "cursor is not positioned");
            }
        } catch (SQLException e) {
            assertSQLState("Unexpected SQLState when updating row after commit",

View Full Code Here

Examples of java.sql.ResultSet.updateRow()

        if (positioned) {
            ps.setInt(1, -1);
            ps.executeUpdate();                
        } else {
            rs.updateInt(1, -1);
            rs.updateRow();
        }
        
        s.close();
        ps.close();

View Full Code Here

Examples of java.sql.ResultSet.updateRow()

        rs.updateInt(2, newCol2);
        assertEquals("Expected the resultset to be updated after updateInt", 
                     newCol2, rs.getInt(2));
        assertTrue("Expected rs.rowUpdated() to be false before updateRow", 
                   !rs.rowUpdated());
        rs.updateRow();
        
        assertTrue("Expected rs.rowUpdated() to be true after updateRow", 
                   rs.rowUpdated());
        assertEquals("Expected the resultset detect the updates of previous " + 
                     "updateRow", newCol2, rs.getInt(2));

View Full Code Here

Examples of java.sql.ResultSet.updateRow()

        assertEquals("Expected updateXXX to have no effect after " +
                     "cancelRowUpdated", oldCol3, rs.getInt(3));
        assertEquals("Expected the resultset detect the updates of previous " +
                     "updateRow after cancelRowUpdated", newCol2, rs.getInt(2));
        rs.updateInt(3, newCol3);
        rs.updateRow();
        assertEquals("Expected the resultset to be updated after updateInt", 
                     newCol3, rs.getInt(3));
        rs.cancelRowUpdates();
        
        assertEquals("Expected the resultset detect the updates of previous" +

View Full Code Here

Examples of java.sql.ResultSet.updateRow()

        assertEquals("Expected the resultset to be updated after updateNull", 
                     0, rs.getInt(2));
        assertTrue("Expected wasNull to be true after updateNull", rs.wasNull());
        assertTrue("Expected rs.rowUpdated() to be false before updateRow", 
                   !rs.rowUpdated());
        rs.updateRow();
        
        assertTrue("Expected rs.rowUpdated() to be true after updateRow", 
                   rs.rowUpdated());
        assertEquals("Expected the resultset detect the updates of previous " + 
                     "updateRow", 0, rs.getInt(2));

View Full Code Here

Examples of java.sql.ResultSet.updateRow()

        assertEquals("Expected updateXXX to have no effect after " +
                     "cancelRowUpdated", oldCol3, rs.getInt(3));
        assertEquals("Expected the resultset detect the updates of previous " +
                     "updateRow after cancelRowUpdated", 0, rs.getInt(2));
        rs.updateNull(3);
        rs.updateRow();
        assertEquals("Expected the resultset to be updated after updateNull", 
                     0, rs.getInt(3));
        rs.cancelRowUpdates();
        
        assertEquals("Expected the resultset detect the updates of previous" +

View Full Code Here

Examples of java.sql.ResultSet.updateRow()


        
        try {
            rs.moveToInsertRow();
            rs.updateInt(1, currentPosition + 2000);
            rs.updateRow();
        } catch (SQLException se) {
            assertEquals("Expected exception", 
                    se.getSQLState().substring(0, 5), 
                    INVALID_CURSOR_STATE_NO_CURRENT_ROW);
        }

View Full Code Here

Examples of java.sql.ResultSet.updateRow()

            // Update the key of every second row.
            int key = rs.getInt(1);
            if (key%2==0) {
                int newKey = -key;
                rs.updateInt(1, newKey);
                rs.updateRow();
            }
        }
        PreparedStatement ps = prepareStatement
            ("select * from t1 where id=?");
        for (int i=0; i<recordCount; i++) {

View Full Code Here

Examples of java.sql.ResultSet.updateRow()

        assertEquals("Expected one row to be updated", 1,
                     ps.executeUpdate());
        
        rs.updateInt(2, -555);
        rs.updateInt(3, -777);
        rs.updateRow();
        
        PreparedStatement ps2 = prepareStatement
            ("select * from t1 where id=?");
        ps2.setInt(1, -primaryKey);
        ResultSet rs2 = ps2.executeQuery();

View Full Code Here

Examples of java.sql.ResultSet.updateRow()

        assertEquals("Expected one row to be updated", 1,
                     ps.executeUpdate());
        rs.updateInt(1, primaryKey*10);
        rs.updateInt(2, -555);
        rs.updateInt(3, -777);
        rs.updateRow();
        
        PreparedStatement ps2 =
            prepareStatement("select * from t1 where id=?");
        ps2.setInt(1, primaryKey*10);
        ResultSet rs2 = ps2.executeQuery();

View Full Code Here

0 1 2 3 4 5 6

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.