Package javax.sql.rowset

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

1232
1233
1234
1235
1236
1237
1238
1239
1240
1241
1242
        } catch (NullPointerException e) {
            // Expected.
        }

        jrs.execute();
        assertTrue(jrs.absolute(4));
        assertEquals(4, jrs.getInt(1));

        // Inserts a new row.
        jrs.moveToInsertRow();
        jrs.updateInt(1, 5);
View Full Code Here
1242
1243
1244
1245
1246
1247
1248
1249
1250
1251
1252
        jrs.updateInt(1, 5);
        jrs.updateString(2, "test5");
        jrs.insertRow();
        jrs.moveToCurrentRow();

        assertTrue(jrs.absolute(5));
        assertEquals(5, jrs.getInt(1));

        // Set autoCommit to false.
        jrs.setAutoCommit(false);
View Full Code Here
1254
1255
1256
1257
1258
1259
1260
1261
1262
1263
1264
        jrs.moveToInsertRow();
        jrs.updateInt(1, 6);
        jrs.updateString(2, "test6");
        jrs.insertRow();
        jrs.moveToCurrentRow();
        assertTrue(jrs.absolute(6));
        assertEquals(6, jrs.getInt(1));

        // Rollbacks
        jrs.rollback();
        try {
View Full Code Here
430
431
432
433
434
435
436
437
438
439
440
        assertEquals(ResultSet.TYPE_SCROLL_INSENSITIVE, jrs.getType());
        assertEquals(ResultSet.CONCUR_UPDATABLE, jrs.getConcurrency());
        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));
View Full Code Here
488
489
490
491
492
493
494
495
496
497
498
        JdbcRowSet jrs = newJdbcRowSet();
        jrs.setCommand("SELECT * FROM USER_INFO");
        jrs.setUrl(DERBY_URL);
        jrs.execute();

        assertTrue(jrs.absolute(3));
        assertEquals(3, jrs.getInt(1));
        assertEquals("test3", jrs.getString(2));
        jrs.updateString(2, "update3");
        assertFalse(jrs.rowUpdated());
        jrs.updateRow();
View Full Code Here
512
513
514
515
516
517
518
519
520
521
522
        JdbcRowSet jrs = newJdbcRowSet();
        jrs.setCommand("SELECT * FROM USER_INFO");
        jrs.setUrl(DERBY_URL);
        jrs.execute();

        assertTrue(jrs.absolute(-2));
        assertEquals("test3", jrs.getString(2));
        jrs.updateRow();
        assertFalse(jrs.rowUpdated());

        jrs.updateString(2, "too looooooooooooooooooooong");
View Full Code Here
532
533
534
535
536
537
538
539
540
541
542
        } catch (SQLException e) {
            // expected
        }

        try {
            assertTrue(jrs.absolute(1));
            fail("should throw SQLException");
        } catch (SQLException e) {
            // expected
        }
View Full Code Here
630
631
632
633
634
635
636
637
638
639
640
        jrs.updateString(2, "insert5");
        jrs.insertRow();
        jrs.moveToCurrentRow();

        // check the inserted row
        assertTrue(jrs.absolute(5));
        /*
         * If uncommenting the following line, then the inserted row which ID is
         * 6 would be invisible to JdbcRowSet.
         */
        // assertTrue(jrs.isLast());
View Full Code Here
289
290
291
292
293
294
295
296
297
298
299
        // 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();

        returnRowset.absolute(3);
        assertEquals("test3", returnRowset.getString(2));
View Full Code Here
253
254
255
256
257
258
259
260
261
262
263
        // 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();

        returnRowset.absolute(3);
        assertEquals("test3", returnRowset.getString(2));
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.