Package javax.sql.rowset

Examples of javax.sql.rowset.JdbcRowSet.last()

644
645
646
647
648
649
650
651
652
653
654
        jrs.updateInt(1, 6);
        jrs.updateString(2, "insert6");
        jrs.insertRow();
        jrs.moveToCurrentRow();

        assertTrue(jrs.last());
        assertEquals(6, jrs.getInt(1));
        assertTrue(jrs.previous());
        assertEquals(5, jrs.getInt(1));

        jrs.close();
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
            fail("Should throw SQLException");
        } catch (SQLException e) {
            // expected, Invalid state
        }
        try {
            jrs.last();
            fail("Should throw SQLException");
        } catch (SQLException e) {
            // expected, Invalid state
        }
        try {
View Full Code Here
318
319
320
321
322
323
324
325
326
327
328
        assertTrue(jrs.relative(-2));
        assertTrue(jrs.first());

        assertTrue(jrs.absolute(10));
        assertEquals(10, jrs.getInt(1));
        assertTrue(jrs.last());
        assertFalse(jrs.next());
        assertTrue(jrs.isAfterLast());

        assertTrue(jrs.relative(-2));
        assertEquals(9, jrs.getInt(1));
View Full Code Here
1273
1274
1275
1276
1277
1278
1279
1280
1281
1282
1283
        // Reconnect
        jrs = newJdbcRowSet();
        jrs.setUrl(DERBY_URL);
        jrs.setCommand("SELECT * FROM USER_INFO");
        jrs.execute();
        assertTrue(jrs.last());
        assertEquals(
                "Since the insert action was roll back, so the last row is 5, not 6.",
                5, jrs.getInt(1));

        jrs.close();
View Full Code Here
368
369
370
371
372
373
374
375
376
377
378
            assertEquals(DERBY_URL, jrs.getUrl());
        }

        jrs.setCommand("SELECT * FROM USER_INFO");
        jrs.execute();
        assertTrue(jrs.last());
        assertEquals(4, jrs.getInt(1));
        jrs.close();

        /*
         * recall execute() after close()
View Full Code Here
432
433
434
435
436
437
438
439
440
441
442
        assertTrue(jrs.getAutoCommit());
        assertTrue(jrs.first());
        assertEquals(2, jrs.getInt(1));
        assertTrue(jrs.absolute(2));
        assertEquals(3, jrs.getInt(1));
        assertTrue(jrs.last());
        assertEquals(4, jrs.getInt(1));
        assertTrue(jrs.previous());
        assertEquals(3, jrs.getInt(1));
        assertTrue(jrs.relative(-1));
        assertEquals(2, jrs.getInt(1));
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.