Get Data from a ResultSet : Query ResultSet « Database « Java Tutorial

  1. The result set maintains a reference to the current row called the cursor.
  2. The cursor is positioned before the first row when a result set is created.
  3. When a result set's next() method is called, the cursor moves to the first row of the resultset, and that row becomes the current row.

20.6.Query ResultSet
20.6.1.ResultSet's Methods to Access Columns by Index
20.6.2.ResultSet's Methods to Access Columns by Name
20.6.3.ResultSet: A SQL query returns a ResultSet containing the requested data
20.6.4.Get Data from a ResultSet
20.6.5.Retrieving the Value of a Column Using the Index Number
20.6.6.Retrieving the Value of a Column Using the Column Name
20.6.7.Selecting all rows from a table and creates a result set:
20.6.8.If you Do Not Know the Name, Position, and Type of Each Column, how to get value from ResultSet
20.6.9.Determine If a Fetched Value Is NULL
20.6.10.Get int value from ResultSet
20.6.11.Get the Number of Rows in a Database Table
20.6.12.Limit the Number of Rows Returned from a SQL Query
20.6.13.Checking for a Warning Using a ResultSet Object
20.6.14.Convert a ResultSet to XML
20.6.15.Converting types: DATE to String