Explanation/Reference:
Explanation:
!!! The given Code prints Error -- the second query clears the ResultSet !? ErrorMessage: Operation not
allowed after ResultSet closed
It would print A, if second Query i set to rs = stmt.executeQuery("SELECT ID FROM Customer"); // Line ***
It would print B, if Line *** is missing. //
The program compiles and runs fine. Both executeQuery statements will run. The first executeQuery
statement
(ResultSet rs = stmt.executeQuery(query);) will set the rs Resultset. It will be used in the while loop.
EmployIDs will be printed.
Note:
Executes the given SQL statement, which returns a single ResultSet object.
Parameters: sql - an SQL statement to be sent to the database, typically a static SQL SELECT statement
Returns: a ResultSet object that contains the data produced by the given query; never null