Package javax.sql.rowset

Examples of javax.sql.rowset.FilteredRowSet.beforeFirst()

468
469
470
471
472
473
474
475
476
477
478
        /*
         * Remove filter
         */
        filteredRowSet.setFilter(null);
        filteredRowSet.beforeFirst();
        index = 0;
        while (filteredRowSet.next()) {
            index++;
            if (index == 5) {
                /*
 
View Full Code Here
673
674
675
676
677
678
679
680
681
682
683
        assertFalse(filteredRowSet.next());
        assertTrue(filteredRowSet.isAfterLast());

        assertTrue(filteredRowSet.nextPage());

        filteredRowSet.beforeFirst();

        assertTrue(filteredRowSet.next());
        assertEquals(5, filteredRowSet.getInt(1));

        assertFalse(filteredRowSet.next());
View Full Code Here
73
74
75
76
77
78
79
80
81
82
83
        /*
         * Set Filter: RangeOne
         */
        Predicate range = new RangeOne();
        filteredRowSet.setFilter(range);
        filteredRowSet.beforeFirst();
        int index = 0;
        while (filteredRowSet.next()) {
            index++;
            assertTrue(filteredRowSet.getString(2).indexOf("test") != -1);
        }
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
        /*
         * Set another Filter: RangeTwo
         */
        range = new RangeTwo();
        filteredRowSet.setFilter(range);
        filteredRowSet.beforeFirst();
        index = 0;
        boolean isSecondRowFiltered = true;
        while (filteredRowSet.next()) {
            index++;
            if ("test2".equals(filteredRowSet.getString(2))) {
View Full Code Here
104
105
106
107
108
109
110
111
112
113
114
        /*
         * Remove Filter
         */
        filteredRowSet.setFilter(null);
        filteredRowSet.beforeFirst();
        index = 0;
        while (filteredRowSet.next()) {
            index++;
            assertEquals(index, filteredRowSet.getInt(1));
        }
View Full Code Here
267
268
269
270
271
272
273
274
275
276
277
        assertFalse(filteredRowSet.relative(-2));

        RangeOne range = new RangeOne();
        filteredRowSet.setFilter(range);

        filteredRowSet.beforeFirst();
        assertTrue(filteredRowSet.relative(2));
        assertEquals(3, filteredRowSet.getInt(1));
        assertEquals(3, filteredRowSet.getRow());
        assertFalse(filteredRowSet.relative(-2));
        assertTrue(filteredRowSet.isBeforeFirst());
View Full Code Here
416
417
418
419
420
421
422
423
424
425
426
        /*
         * Although the new row is inserted, it is invalid through
         * evaluate(RowSet rs). Therefore, the inserted row is not visible.
         */
        filteredRowSet.beforeFirst();
        int index = 0;
        while (filteredRowSet.next()) {
            index++;
            assertEquals(index + 1, filteredRowSet.getInt(1));
        }
View Full Code Here
447
448
449
450
451
452
453
454
455
456
457
        /*
         * Remove filter
         */
        filteredRowSet.setFilter(null);
        filteredRowSet.beforeFirst();
        index = 0;
        while (filteredRowSet.next()) {
            index++;
            if (index == 5) {
                /*
 
View Full Code Here
652
653
654
655
656
657
658
659
660
661
662
        assertFalse(filteredRowSet.next());
        assertTrue(filteredRowSet.isAfterLast());

        assertTrue(filteredRowSet.nextPage());

        filteredRowSet.beforeFirst();

        assertTrue(filteredRowSet.next());
        assertEquals(5, filteredRowSet.getInt(1));

        assertFalse(filteredRowSet.next());
View Full Code Here
267
268
269
270
271
272
273
274
275
276
277
        assertFalse(filteredRowSet.relative(-2));

        RangeOne range = new RangeOne();
        filteredRowSet.setFilter(range);

        filteredRowSet.beforeFirst();
        assertTrue(filteredRowSet.relative(2));
        assertEquals(3, filteredRowSet.getInt(1));
        assertEquals(3, filteredRowSet.getRow());
        assertFalse(filteredRowSet.relative(-2));
        assertTrue(filteredRowSet.isBeforeFirst());
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.