Examples of javax.sql.rowset.JoinRowSet

javax.sql.rowset.JoinRowSet
ID is the first column jrs.addRowSet(bonus);
At this point, jrs is an inside JOIN of the two RowSet objects based on their EMP_ID columns. The application can now browse the combined data as if it were browsing one single RowSet object. Because jrs is itself a RowSet object, an application can navigate or modify it using RowSet methods.
```
 jrs.first(); int employeeID = jrs.getInt(1); String employeeName = jrs.getString(2); 
```
Note that because the SQL JOIN must be enforced when an application adds a second or subsequent RowSet object, there may be an initial degradation in performance while the JOIN is being performed.
The following code fragment adds an additional CachedRowSet object. In this case, the match column (EMP_ID) is set when the CachedRowSet object is added to the JoinRowSet object.
```
 ResultSet rs3 = stmt.executeQuery("SELECT * FROM 401K_CONTRIB"); CachedRowSet fourO1k = new CachedRowSetImpl(); four01k.populate(rs3); jrs.addRowSet(four01k, 1); 
```
The JoinRowSet object jrs now contains values from all three tables. The data in each row in four01k in which the value for the EMP_ID column matches a value for the EMP_ID column in jrs has been added to jrs.
4.0 JoinRowSet Methods
The JoinRowSet interface supplies several methods for adding RowSet objects and for getting information about the JoinRowSet object.
- Methods for adding one or more RowSet objects
  These methods allow an application to add one RowSet object at a time or to add multiple RowSet objects at one time. In either case, the methods may specify the match column for each RowSet object being added.
- Methods for getting information
  One method retrieves the RowSet objects in the JoinRowSet object, and another method retrieves the RowSet names. A third method retrieves either the SQL WHERE clause used behind the scenes to form the JOIN or a text description of what the WHERE clause does.
- Methods related to the type of JOIN
  One method sets the JOIN type, and five methods find out whether the JoinRowSet object supports a given type.
- A method to make a separate copy of the JoinRowSet object
  This method creates a copy that can be persisted to the data source.

        jrs = newJoinRowSet();
        jrs.addRowSet(crset, 1);
        StringWriter writer = new StringWriter();
        jrs.writeXml(writer);


        JoinRowSet another = newJoinRowSet();
        another.readXml(new StringReader(writer.getBuffer().toString()));


        assertCachedRowSetEquals(jrs, another);
    }

View Full Code Here

        assertTrue(jrs.rowInserted());


        StringWriter writer = new StringWriter();
        jrs.writeXml(writer);


        JoinRowSet another = newJoinRowSet();
        another.readXml(new StringReader(writer.getBuffer().toString()));


        if (System.getProperty("Testing Harmony") == "true") {
            assertCachedRowSetEquals(jrs, another);
        } else {
            // TODO why the output xml has no insert information.
            another.absolute(2);
            assertFalse(another.rowInserted());
            jrs.absolute(2);
            assertTrue(jrs.rowInserted());
        }
    }

View Full Code Here


        StringWriter writer = new StringWriter();


        jrs.writeXml(writer);


        JoinRowSet another = newJoinRowSet();
        another.readXml(new StringReader(writer.getBuffer().toString()));




        if (System.getProperty("Testing Harmony") == "true") {
            assertCachedRowSetEquals(jrs, another);
        } else {
            another.absolute(3);
            assertFalse(another.rowUpdated());
            jrs.absolute(3);
            assertTrue(jrs.rowUpdated());
            
            // TODO why the output xml has no update information.
            another.absolute(4);
            assertFalse(another.rowUpdated());
            jrs.absolute(4);
            assertTrue(jrs.rowUpdated());
        }
    }

View Full Code Here

    public void testWriteXmlLResultSet() throws Exception {
        StringWriter writer = new StringWriter();
        rs = st.executeQuery("select * from user_info");
        jrs.writeXml(rs, writer);
        
        JoinRowSet jrs2 = newJoinRowSet();
        jrs2.readXml(new StringReader(writer.getBuffer().toString()));
        assertCachedRowSetEquals(crset, jrs2);
    }

View Full Code Here

TOP

Related Classes of javax.sql.rowset.JoinRowSet

org.apache.harmony.sql.tests.internal.rowset.JoinRowSetTestCase

org.apache.harmony.sql.tests.internal.rowset.JoinRowSetWebRowSetTest

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.

Examples of javax.sql.rowset.JoinRowSet

4.0 JoinRowSet Methods

Related Classes of javax.sql.rowset.JoinRowSet

4.0 `JoinRowSet` Methods