Result Set Data Type Java. The JDBC specification has a table for the mappings from SQL types to Java types. Many of the methods of ResultSet object are overloaded such as methods that are used to retrieve the value as primitive data type value are overloaded as datatype getXXXXdatatype columnLabel The parameter columnLabel specifies the name of the field of the database table for example int getInt columnLabel.
The result set type can be TYPE_FORWARD_ONLY TYPE_SCROLL_INSENSITIVE or TYPE_SCROLL_SENSITIVE. The TYPE_FORWARD_ONLY type indicates that you can only scroll forward through the result set you cant jump back to a previous result set. An object that can be used to get information about the types and properties of the columns in a ResultSetobject.
Since Set is an interface objects cannot be created of the type setWe always need a class which extends this list in order to create an object.
We can get further information from the data. A ResultSet object maintains a cursor pointing to its current row of data. The object of ResultSet maintains cursor point at the result data. In default the cursor positions before the first row of the result data.