Working with Result Sets

When you work with the data contained in a SQL Server database, one method of manipulating the data is to use a result set. The Microsoft SQL Server 2005 JDBC Driver supports the use of result sets through the SQLServerResultSet object. By using the SQLServerResultSet object, you can retrieve the data returned from an SQL statement or stored procedure, update the data as needed, and then persist that data back to the database.

In addition, the SQLServerResultSet object provides methods for navigating through its rows of data, getting or setting the data that it contains, and for establishing various levels of sensitivity to changes in the underlying database.

Note

For more information about managing result sets, including their sensitivity to changes, see Managing Result Sets with the JDBC Driver.

The topics in this section describe different ways that you can use a result set to manipulate the data contained in a SQL Server database.

In This Section

Topic Description

Retrieving Result Set Data Sample

Describes how to use a result set to retrieve data from a SQL Server database and display it.

Modifying Result Set Data Sample

Describes how to use a result set to insert, retrieve, and modify data in a SQL Server database.

Caching Result Set Data Sample

Describes how to use a result set to retrieve large amounts of data from a SQL Server database, and to control how that data is cached on the client.

See Also

Other Resources

Sample JDBC Driver Applications