Package javax.sql.rowset

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

1392
1393
1394
1395
1396
1397
1398
1399
1400
1401
1402
            fail("Should throw SQLException " + "since no current row.");
        } catch (SQLException e) {
            // Expected.
        }

        jrs.first();
        int index = 0;
        while (jrs.next()) {
            index++;
        }
View Full Code Here
1405
1406
1407
1408
1409
1410
1411
1412
1413
1414
1415
        jrs.setShowDeleted(true);
        assertTrue(jrs.getShowDeleted());

        jrs.absolute(3);
        jrs.deleteRow();
        jrs.first();
        index = 0;
        while (jrs.next()) {
            index++;
        }
View Full Code Here
69
70
71
72
73
74
75
76
77
78
79
            fail("Should throw SQLException");
        } catch (SQLException e) {
            // expected, Invalid state
        }
        try {
            jrs.first();
            fail("Should throw SQLException");
        } catch (SQLException e) {
            // expected, Invalid state
        }
        try {
View Full Code Here
302
303
304
305
306
307
308
309
310
311
312
        jrs.execute();

        jrs.beforeFirst();
        assertTrue(jrs.isBeforeFirst());
        assertTrue(jrs.next());
        assertTrue(jrs.first());
        assertFalse(jrs.previous());
        assertTrue(jrs.isBeforeFirst());
        assertTrue(jrs.absolute(1));
        assertTrue(jrs.first());
        assertEquals(1, jrs.getInt(1));
View Full Code Here
306
307
308
309
310
311
312
313
314
315
316
        assertTrue(jrs.next());
        assertTrue(jrs.first());
        assertFalse(jrs.previous());
        assertTrue(jrs.isBeforeFirst());
        assertTrue(jrs.absolute(1));
        assertTrue(jrs.first());
        assertEquals(1, jrs.getInt(1));

        assertTrue(jrs.relative(3));
        assertEquals(4, jrs.getInt(1));
        assertTrue(jrs.previous());
View Full Code Here
314
315
316
317
318
319
320
321
322
323
324
        assertTrue(jrs.relative(3));
        assertEquals(4, jrs.getInt(1));
        assertTrue(jrs.previous());
        assertEquals(3, jrs.getInt(1));
        assertTrue(jrs.relative(-2));
        assertTrue(jrs.first());

        assertTrue(jrs.absolute(10));
        assertEquals(10, jrs.getInt(1));
        assertTrue(jrs.last());
        assertFalse(jrs.next());
View Full Code Here
977
978
979
980
981
982
983
984
985
986
987
            fail("should throw SQLException");
        } catch (SQLException e) {
            // expected
        }
        try {
            jrs.first();
            fail("should throw SQLException");
        } catch (SQLException e) {
            // expected
        }
        try {
View Full Code Here
1260
1261
1262
1263
1264
1265
1266
1267
1268
1269
1270
        assertEquals(6, jrs.getInt(1));

        // Rollbacks
        jrs.rollback();
        try {
            jrs.first();
            fail("After rolling back, jrs can't do anything except close.");
        } catch (NullPointerException e) {
            // Expected.
        }
View Full Code Here
399
400
401
402
403
404
405
406
407
408
409
        jrs = newJdbcRowSet();
        jrs.setUrl(DERBY_URL);
        jrs.setCommand("SELECT * FROM USER_INFO WHERE ID >= ?");
        jrs.setInt(1, 2);
        jrs.execute();
        assertTrue(jrs.first());
        assertEquals(2, jrs.getInt(1));

        // change the query condition
        jrs.setInt(1, 3);
        jrs.execute();
View Full Code Here
405
406
407
408
409
410
411
412
413
414
415
        assertEquals(2, jrs.getInt(1));

        // change the query condition
        jrs.setInt(1, 3);
        jrs.execute();
        assertTrue(jrs.first());
        assertEquals(3, jrs.getInt(1));

        // change the command
        jrs.setCommand("SELECT * FROM USER_INFO WHERE NAME = 'hermit'");
        jrs.execute();
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.