Package javax.sql.rowset

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

411
412
413
414
415
416
417
418
419
420
421
        assertEquals(3, jrs.getInt(1));

        // change the command
        jrs.setCommand("SELECT * FROM USER_INFO WHERE NAME = 'hermit'");
        jrs.execute();
        assertTrue(jrs.first());
        assertEquals(1, jrs.getInt(1));
        assertFalse(jrs.next());

        jrs.close();
    }
View Full Code Here
428
429
430
431
432
433
434
435
436
437
438
        jrs.execute();

        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));
View Full Code Here
548
549
550
551
552
553
554
555
556
557
558
        JdbcRowSet jrs = newJdbcRowSet();
        jrs.setCommand("SELECT * FROM USER_INFO");
        jrs.setUrl(DERBY_URL);
        jrs.execute();

        assertTrue(jrs.first());
        jrs.deleteRow();

        try {
            jrs.getInt(1);
            fail("should throw SQLException");
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.