Rowset usage in Java

Compared to ResultSet, the rowset default is scrollable, updatable, serializable result sets. and used as JavaBean. Therefore, it can be conveniently transmitted on the network. Used to synchronize data at both ends. For offline rowset, when the program creates the rowset, it has read the data from the database to memory, so it can take full advantage of the computer's memory. Thus reducing the load on the server.
JAVA7 provides a rowsetprovider that can be used to obtain Rowsetfactory objects using the Rowsetprovider.newfactory () method. There are five commonly used methods in Rowsetfactory to obtain an instance of rowset. respectively: CachedRowSet createcachedrowset (); Webrowset Createwebrowset (); Joinrowset Createjoinrowset (); Fileterrowset Createfilterrowset (); Jdbcrowset Createjdbcrowset (); The rowset interface defines several common methods: SetUrl (String URL); Setusername (String name); SetPassword (String password); SetCommand (String sql); Execute (); Populate (Result R); From the above method, you can see that there are two ways to populate rowset with data: A good ResultSet is created, and populate (ResultSet) is passed to rowset, URLs, and so on, to rowset and execute SQL with execute. An important property of rowset is that it has interfaces in its sub-interfaces that can be implemented offline, such as CachedRowSet and its sub-interfaces: its sub-interfaces have webrowset,webrowset and sub-interfaces Filteredrowset,joinrowset