Package javax.sql.rowset

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

788
789
790
791
792
793
794
795
796
797
798
    public void testCreateCopy2() throws Exception {

        CachedRowSet copy = crset.createCopy();

        copy.absolute(3);
        crset.absolute(3);

        copy.updateString(2, "updated");
        assertEquals("updated", copy.getString(2));
        assertEquals("test3", crset.getString(2));
View Full Code Here
371
372
373
374
375
376
377
378
379
380
381
        crsetShared.acceptChanges();
        assertEquals(CachedRowSetListenerTest.EVENT_ROWSET_CHANGED, listener
                .getTag());

        // when move the duplicate's cursor, the original shouldn't be affected
        crsetShared.absolute(1);
        assertEquals(1, crsetShared.getInt(1));
        assertEquals(3, crset.getInt(1));
    }

    public void testcreateCopyNoConstraints() throws Exception {
View Full Code Here
366
367
368
369
370
371
372
373
374
375
376
        jrs.addRowSet(crset2, 1);
        assertTrue(jrs.isBeforeFirst());

        jrs = newJoinRowSet();
        jrs.addRowSet(crset, 1);
        crset2.absolute(1);
        jrs.addRowSet(crset2, 1);
        assertTrue(jrs.isBeforeFirst());

        crset.last();
        jrs = newJoinRowSet();
View Full Code Here
389
390
391
392
393
394
395
396
397
398
399
        crset.last();
        jrs = newJoinRowSet();
        jrs.addRowSet(crset, 1);
        assertTrue(jrs.isLast());
        crset2.absolute(1);
        jrs.addRowSet(crset2, 1);
        assertTrue(jrs.isBeforeFirst());
    }

    public void testJoin_Update() throws Exception {
View Full Code Here
481
482
483
484
485
486
487
488
489
490
491
            if (jrs.getInt(1) == 3) {
                assertTrue(jrs.rowDeleted());
            }
        }

        crset2.absolute(6);
        crset2.deleteRow();

        crset2.beforeFirst();
        while (crset2.next()) {
            if (crset2.getInt(1) == 4) {
View Full Code Here
642
643
644
645
646
647
648
649
650
651
652
        CachedRowSet crset2 = newNoInitialInstance();
        rs = st.executeQuery("select * from books");
        crset2.populate(rs);

        crset2.absolute(3);
        crset2.deleteRow();

        jrs.addRowSet(crset2, 1);

        rowNum = 0;
View Full Code Here
690
691
692
693
694
695
696
697
698
699
700
        CachedRowSet crset2 = newNoInitialInstance();
        rs = st.executeQuery("select * from books");
        crset2.populate(rs);

        crset2.absolute(3);
        crset2.deleteRow();
        crset2.setShowDeleted(true);

        jrs.addRowSet(crset2, 1);

View Full Code Here
737
738
739
740
741
742
743
744
745
746
747
        CachedRowSet crset2 = newNoInitialInstance();
        rs = st.executeQuery("select * from books");
        crset2.populate(rs);

        crset2.absolute(3);
        crset2.deleteRow();
        crset2.setShowDeleted(true);

        jrs.addRowSet(crset2, 1);
        jrs.setShowDeleted(false);
View Full Code Here
250
251
252
253
254
255
256
257
258
259
260
        assertEquals("Updated 4", jrs.getString(2));

        // TODO It is Strange. According to spec, the returned rowset should
        // maintain
        // the update occured in the joinrowset.
        returnRowset.absolute(4);
        assertEquals("test4", returnRowset.getString(2));

        jdbcRs.absolute(3);
        jdbcRs.updateString(2, "Updated 3");
        jdbcRs.updateRow();
View Full Code Here
257
258
259
260
261
262
263
264
265
266
267
        jdbcRs.absolute(3);
        jdbcRs.updateString(2, "Updated 3");
        jdbcRs.updateRow();

        returnRowset.absolute(3);
        assertEquals("test3", returnRowset.getString(2));

        jdbcRs.close();
    }
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.