190191192193194195196197198199200
webRs.setKeyColumns(new int[] { 2, 1 }); // update a row assertTrue(webRs.absolute(4)); webRs.updateInt(1, 44); webRs.updateString(2, "update44"); webRs.updateRow(); // update a row but not call updateRow() assertTrue(webRs.absolute(2));
196197198199200201202203204205206
webRs.updateString(2, "update44"); webRs.updateRow(); // update a row but not call updateRow() assertTrue(webRs.absolute(2)); webRs.updateInt(1, 22); // delete a row assertTrue(webRs.absolute(3)); webRs.deleteRow();
204205206207208209210211212213214
assertTrue(webRs.absolute(3)); webRs.deleteRow(); // insert a row webRs.moveToInsertRow(); webRs.updateInt(1, 77); webRs.updateString(2, "insert77"); webRs.insertRow(); webRs.moveToCurrentRow(); webRs.writeXml(strWriter);
268269270271272273274275276277278
rs = st.executeQuery("SELECT * FROM USER_INFO"); webRs.populate(rs); webRs.moveToInsertRow(); webRs.updateString(2, "update3"); webRs.updateInt(4, 3); webRs.moveToCurrentRow(); webRs.writeXml(strWriter); assertTrue(webRs.isAfterLast());
288289290291292293294295296297298
webRs.populate(rs); assertTrue(webRs.absolute(3)); webRs.moveToInsertRow(); webRs.updateString(2, "insert5"); webRs.updateInt(1, 5); webRs.insertRow(); webRs.moveToCurrentRow(); webRs.next(); webRs.updateString(2, "update5"); webRs.updateInt(1, 6);
293294295296297298299300301302303
webRs.updateInt(1, 5); webRs.insertRow(); webRs.moveToCurrentRow(); webRs.next(); webRs.updateString(2, "update5"); webRs.updateInt(1, 6); strWriter = new StringWriter(); webRs.writeXml(strWriter); assertTrue(webRs.isAfterLast());