Examples of javax.sql.rowset.CachedRowSet.execute()

javax.sql.rowset.CachedRowSet.execute()
Populates this CachedRowSet object with data, using the given connection to produce the result set from which the data will be read. This method should close any database connections that it creates to ensure that this CachedRowSet object is disconnected except when it is reading data from its data source or writing data to its data source.
The reader for this CachedRowSet object will use conn to establish a connection to the data source so that it can execute the rowset's command and read data from the the resulting ResultSet object into this CachedRowSet object. This method also closes conn after it has populated this CachedRowSet object.
If this method is called when an implementation has already been populated, the contents and the metadata are (re)set. Also, if this method is called before the method acceptChanges has been called to commit outstanding updates, those updates are lost. @param conn a standard JDBC Connection object with validproperties @throws SQLException if an invalid Connection object is suppliedor an error occurs in establishing the connection to the data source @see #populate @see java.sql.Connection

        assertTrue(crset.next());
        assertEquals("test3", crset.getString(2));
        assertFalse(crset.next());


        CachedRowSet crsetCopy = crset.createCopy();
        crsetCopy.execute();
        assertEquals(DEFAULT_COLUMN_COUNT, crsetCopy.getMetaData()
                .getColumnCount());
        assertTrue(crsetCopy.next());
        assertEquals("test3", crsetCopy.getString(2));
        assertFalse(crsetCopy.next());

View Full Code Here

        assertEquals("test3", crsetCopy.getString(2));
        assertFalse(crsetCopy.next());


        crsetCopy.setCommand("SELECT * FROM USER_INFO WHERE NAME = ?");
        crsetCopy.setString(1, "test4");
        crsetCopy.execute();
        assertTrue(crsetCopy.next());
        assertEquals(4, crsetCopy.getInt(1));
        assertFalse(crsetCopy.next());


        crset.execute();

View Full Code Here

        CachedRowSet copyCrset = crset.createCopy();
        copyCrset.beforeFirst();
        assertTrue(copyCrset.next());
        assertEquals(3, copyCrset.getInt(1));
        assertFalse(copyCrset.next());
        copyCrset.execute();
        assertTrue(copyCrset.next());
        assertEquals(3, copyCrset.getInt(1));
        assertFalse(copyCrset.next());


        crset.setInt(1, 4);

View Full Code Here

        copyCrset.beforeFirst();
        assertTrue(copyCrset.next());
        assertEquals(3, copyCrset.getInt(1));
        assertFalse(copyCrset.next());


        copyCrset.execute();
        copyCrset.beforeFirst();
        assertTrue(copyCrset.next());
        assertEquals(3, copyCrset.getInt(1));
        assertFalse(copyCrset.next());

View Full Code Here

        assertTrue(copyCrset.next());
        assertEquals(3, copyCrset.getInt(1));
        assertFalse(copyCrset.next());


        copyCrset.setInt(1, 1);
        copyCrset.execute();
        assertTrue(copyCrset.next());
        assertEquals(1, copyCrset.getInt(1));
        assertFalse(copyCrset.next());


        crset.beforeFirst();

View Full Code Here

        CachedRowSet copyWebRs = webRs.createCopy();
        copyWebRs.beforeFirst();
        assertTrue(copyWebRs.next());
        assertEquals(3, copyWebRs.getInt(1));
        assertFalse(copyWebRs.next());
        copyWebRs.execute();
        assertTrue(copyWebRs.next());
        assertEquals(3, copyWebRs.getInt(1));
        assertFalse(copyWebRs.next());


        webRs.setInt(1, 4);

View Full Code Here

        copyWebRs.beforeFirst();
        assertTrue(copyWebRs.next());
        assertEquals(3, copyWebRs.getInt(1));
        assertFalse(copyWebRs.next());


        copyWebRs.execute();
        copyWebRs.beforeFirst();
        assertTrue(copyWebRs.next());
        assertEquals(3, copyWebRs.getInt(1));
        assertFalse(copyWebRs.next());

View Full Code Here

        assertEquals(3, copyWebRs.getInt(1));
        assertFalse(copyWebRs.next());


        copyWebRs.setInt(1, 1);
        copyWebRs.setString(2, "hermit");
        copyWebRs.execute();
        assertTrue(copyWebRs.next());
        assertEquals(1, copyWebRs.getInt(1));
        assertFalse(copyWebRs.next());


        webRs.beforeFirst();

View Full Code Here

        // Creates another cached rowset.
        CachedRowSet crset2;
        crset2 = newNoInitialInstance();
        crset2.setCommand("SELECT * FROM BOOKS");
        crset2.setUrl(DERBY_URL);
        crset2.execute();


        // Tests when there are on jdbcRowSet and one CachedRowSet.
        jrs.addRowSet(crset2, 1);
        jrs.addRowSet(crset, 1);

View Full Code Here

        // Creates another cached rowset.
        CachedRowSet crset2;
        crset2 = newNoInitialInstance();
        crset2.setCommand("SELECT * FROM BOOKS");
        crset2.setUrl(DERBY_URL);
        crset2.execute();
        crset2.setTableName("Table2");
        jrs.addRowSet(crset2, "AUTHORID");


        crset2 = newNoInitialInstance();
        crset2.setCommand("SELECT * FROM BOOKS");

View Full Code Here

0 1 2

TOP

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.