Working with Databases - Java 8 Recipes - page 483

Successfully connected
100: JUNEAU, JOSH
101: DEA, CARL
102: BEATY, MARK
103: GUIME, FREDDY
104: JOHN, OCONNER
105: TESTER, JOE
110: TESTER, JOE
111: OCONNER, JOHN
1: 100 - Java 8 Recipes
2: 100 - Java 7 Recipes
3: 100 - Java EE 7 Recipes
4: 100 - Introducing Java EE 7
5: 103 - Java 7 Recipes
6: 101 - Java 7 Recipes
7: 111 - Java 7 Recipes
8: 102 - Java 7 Recipes
9: 101 - Java FX 2.0 - Introduction by Example
111: Java 7 Recipes - JOHN OCONNER
103: Java 7 Recipes - FREDDY GUIME
102: Java 7 Recipes - MARK BEATY
101: Java FX 2.0 - Introduction by Example - CARL DEA
101: Java 7 Recipes - CARL DEA
100: Introducing Java EE 7 - JOSH JUNEAU
100: Java EE 7 Recipes - JOSH JUNEAU
100: Java 7 Recipes - JOSH JUNEAU
100: Java 8 Recipes - JOSH JUNEAU
How It Works
A JoinRowSet is a combination of two or more populated RowSet objects. It can
be used to join two RowSet objects based on key/value relationships, just as if it were
a SQL JOIN query. In order to create a JoinRowSet , you must first populate two or
more RowSet objects with related data, and then they can each be added to the
JoinRowSet to create the combined result.
In the solution to this recipe, the tables that are queried are named
BOOK_AUTHOR, BOOK , and AUTHOR_WORK . The BOOK_AUTHOR table contains a