Java updating resultset
The SELECT statement is the standard way to select rows from a database and view them in a result set. Result Set interface represents the result set of a database query.
A Result Set object maintains a cursor that points to the current row in the result set.
These properties are designated when the corresponding Statement that generates the Result Set is created. The Result Set interface contains a collection of update methods for updating the data of a result set.
JDBC provides the following connection methods to create statements with desired Result Set − The first argument indicates the type of a Result Set object and the second argument is one of two Result Set constants for specifying whether a result set is read-only or updatable. If you do not specify any Result Set type, you will automatically get one that is TYPE_FORWARD_ONLY. As with the get methods, there are two update methods for each data type − There are update methods for the eight primitive data types, as well as String, Object, URL, and the SQL data types in the package.
Submit a bug or feature For further API reference and developer documentation, see Java SE Documentation.
The SQL statements that read data from a database query, return the data in a result set.
The three statement creation methodscreate Statement, prepare Statement, and prepare Callallow you to specify a result set type and a result set concurrency.
The result set type can be type indicates that you can only scroll forward through the result set, you can't jump back to a previous result set.
* * THIS SOFTWARE IS PROVIDED BY THE AUTHOR AND CONTRIBUTORS ``AS IS'' AND ANY * EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE * DISCLAIMED.
Redistributions of source code must retain the above copyright notice, * this list of conditions and the following disclaimer. Redistributions in * binary form must reproduce the above copyright notice, this list of * conditions and the following disclaimer in the documentation and/or other * materials provided with the distribution.
The term "result set" refers to the row and column data contained in a Result Set object. Check the documentation for more information about using these SQL data types.