Package javax.sql.rowset

Examples of javax.sql.rowset.WebRowSet.absolute()

411
412
413
414
415
416
417
418
419
420
421
        assertProperties(doc, webRs);
        assertMetadata(doc, webRs);
        assertData(doc, webRs);

        webRs.absolute(2);

        rs = st.executeQuery("SELECT * FROM USER_INFO");
        strWriter = new StringWriter();
        webRs.writeXml(rs, strWriter);

View Full Code Here
189
190
191
192
193
194
195
196
197
198
199
        webRs.setTypeMap(map);

        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()
View Full Code Here
195
196
197
198
199
200
201
202
203
204
205
        webRs.updateInt(1, 44);
        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();
View Full Code Here
199
200
201
202
203
204
205
206
207
208
209
        // update a row but not call updateRow()
        assertTrue(webRs.absolute(2));
        webRs.updateInt(1, 22);

        // delete a row
        assertTrue(webRs.absolute(3));
        webRs.deleteRow();

        // insert a row
        webRs.moveToInsertRow();
        webRs.updateInt(1, 77);
View Full Code Here
234
235
236
237
238
239
240
241
242
243
244
    public void testWriteXML_Update() throws Exception {
        WebRowSet webRs = newWebRowSet();
        rs = st.executeQuery("SELECT * FROM USER_INFO");
        webRs.populate(rs);

        webRs.absolute(3);
        webRs.updateString(2, "update3");

        webRs.writeXml(strWriter);

        assertTrue(webRs.isAfterLast());
View Full Code Here
285
286
287
288
289
290
291
292
293
294
295
        webRs = newWebRowSet();
        rs = st.executeQuery("SELECT * FROM USER_INFO");
        webRs.populate(rs);

        assertTrue(webRs.absolute(3));
        webRs.moveToInsertRow();
        webRs.updateString(2, "insert5");
        webRs.updateInt(1, 5);
        webRs.insertRow();
        webRs.moveToCurrentRow();
View Full Code Here
312
313
314
315
316
317
318
319
320
321
322
    public void testWriteXML_Delete() throws Exception {
        WebRowSet webRs = newWebRowSet();
        rs = st.executeQuery("SELECT * FROM USER_INFO");
        webRs.populate(rs);

        webRs.absolute(3);
        webRs.deleteRow();

        assertEquals(0, webRs.getRow());

        webRs.writeXml(strWriter);
View Full Code Here
333
334
335
336
337
338
339
340
341
342
343
    public void testWriteXML_Update_Delete() throws Exception {
        WebRowSet webRs = newWebRowSet();
        rs = st.executeQuery("SELECT * FROM USER_INFO");
        webRs.populate(rs);

        webRs.absolute(3);
        webRs.updateString(2, "update3");

        webRs.deleteRow();

        webRs.writeXml(strWriter);
View Full Code Here
352
353
354
355
356
357
358
359
360
361
362
        webRs = newWebRowSet();
        rs = st.executeQuery("SELECT * FROM USER_INFO");
        webRs.populate(rs);

        webRs.absolute(3);
        webRs.updateString(2, "update3");
        webRs.updateRow();

        webRs.deleteRow();

View Full Code Here
411
412
413
414
415
416
417
418
419
420
421
        assertProperties(doc, webRs);
        assertMetadata(doc, webRs);
        assertData(doc, webRs);

        webRs.absolute(2);

        rs = st.executeQuery("SELECT * FROM USER_INFO");
        strWriter = new StringWriter();
        webRs.writeXml(rs, strWriter);

View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.