Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Process the result

The result of the SQL statement (SQL queries) are stored in a ResultSet object. To retrieve the data from the ResultSet we need to use the getXXX methods. These methods retrieve the data and convert it to a Java data type. There is a separate getXXX methods for each datatype. For example, getString( ) is used to retrieve a string value and getDate( ) is used to retrieve a date value. The getXXX methods take one argument, which is the index of the column in the ResultSet and return the value of the column. To move to the next row in the ResultSet we make use of the ResultSet.next( ) method.