What is wrong with the following statement?
ResultSet result = statement.execute("SELECT * FROM emp WHERE empNum = '5'");
A)ResultSet should be String
B)execute should be executeQuery
C)execute should be prepareStatement
D)5 should not be used as an empNum value

Question

Quizplus · Accepted Answer

The method execute() should only be used for SQL statements that do not return a ResultSet such as INSERT, UPDATE, and DELETE statements. Since the statement in the example is a SELECT statement that returns data, the correct method to use is executeQuery().

What Is Wrong with the Following Statement