JDBC RowSets Implementation Tutorial

TMJDBC RowSet Implementations TutorialMaydene Fisher with contributions fromJonathan Bruce, Amit Handa & Shreyas KaushikSun Microsystems Inc.4150 Network CircleSanta Clara, CA 95054USARevision 1.0Send comments to jdbc@sun.com 1 5RowSet Overview 5What Can RowSet Objects Do? 5Function as a JavaBeans™ Component 6Properties 6Event Notification 7Add Scrollability or Updatability 8Kinds of RowSet Objects 8Connected RowSet Objects 8Disconnected RowSet Objects 8 11JdbcRowSet 11Creating a JdbcRowSet Object 11Passing a ResultSet Object 12Using the Default Constructor 13Setting Properties 14Setting Parameters for the Command 15Using a JdbcRowSet Object 16Navigating a JdbcRowSet Object 17Updating a Column Value 18Inserting a Row 18Deleting a Row 19Code Sample 20 23CachedRowSet 23Setting Up a CachedRowSet Object 23Creating a CachedRowSet Object 24Using the Default Constructor 24Passing a SyncProvider Implementation 24Setting Properties 25Setting Key Columns 26Populating a CachedRowSet Object 26What a Reader Does 27Updating a CachedRowSet Object 28Updating a Column Value 29Inserting and Deleting Rows 29Updating the Data Source 30What a Writer Does 30Using the Default Implementation 31Using a SyncResolver Object 31Using Other SyncProvider Implementations 33 2Notifying Listeners 34Setting Up Listeners 34How Notification Works 35Accessing Large Amounts of Data 35Code Sample 37 ...