Example usage for javax.sql.rowset JoinRowSet addRowSet

Introduction

In this page you can find the example usage for javax.sql.rowset JoinRowSet addRowSet.

Prototype

public void addRowSet(RowSet[] rowset, String[] columnName) throws SQLException;

Source Link

Document

Adds one or more RowSet objects contained in the given array of RowSet objects to this JoinRowSet object and sets the match column for each of the RowSet objects to the match columns in the given array of column names.

Usage

From source file:com.oracle.tutorial.jdbc.JoinSample.java

public void testJoinRowSet(String supplierName) throws SQLException {

    CachedRowSet coffees = null;/*from w  w  w  .ja  v  a 2  s. c  om*/
    CachedRowSet suppliers = null;
    JoinRowSet jrs = null;

    try {
        coffees = new CachedRowSetImpl();
        coffees.setCommand("SELECT * FROM COFFEES");
        coffees.setUsername(settings.userName);
        coffees.setPassword(settings.password);
        coffees.setUrl(settings.urlString);
        coffees.execute();

        suppliers = new CachedRowSetImpl();
        suppliers.setCommand("SELECT * FROM SUPPLIERS");
        suppliers.setUsername(settings.userName);
        suppliers.setPassword(settings.password);
        suppliers.setUrl(settings.urlString);
        suppliers.execute();

        jrs = new JoinRowSetImpl();
        jrs.addRowSet(coffees, "SUP_ID");
        jrs.addRowSet(suppliers, "SUP_ID");

        System.out.println("Coffees bought from " + supplierName + ": ");
        while (jrs.next()) {
            if (jrs.getString("SUP_NAME").equals(supplierName)) {
                String coffeeName = jrs.getString(1);
                System.out.println("     " + coffeeName);
            }
        }
    } catch (SQLException e) {
        JDBCTutorialUtilities.printSQLException(e);
    } finally {
        if (jrs != null) {
            jrs.close();
        }
        if (suppliers != null) {
            suppliers.close();
        }
        if (coffees != null) {
            coffees.close();
        }
    }
}

---