The ResultSet Interface
A result set behaves something like an Enumeration or Iterator. This allows to iterate over the set of rows returned by a query.
The next() method is used to move to the first row, then all subsequent rows.
There is a large number of methods of the form:
XXX getXXX(int columnIndex)
that extract the contents of a column in the current row.
The one we will use most is getString(), which interprets the column as a String.
Note columnIndex starts at 1, not zero.
ResultSet has many other methods. Many were added in JDBC 2.0.