PreparedStatement automatically close ResultSet (use try-with

PreparedStatement automatically close ResultSet (use try-with resultset The result set is an object that represents a set of data ResultSet rs = ; while (()) { System resultset ResultSet maintains cursorpointer which points to a single row of the query results Using navigational and getter methods provided by

resultset A prepared SQL query is executed and its ResultSet is returned ResultSet, Execute a SQL statement that returns a single

resultset The result of running a SELECT statement using the executeQuery() method is a ResultSet object, which contains the resulting rows of the SELECT statement  ResultSet is an interface present in package It is used to accommodate multiple rows returned by the SQL statement