Question

PreparedStatement ps = connection.prepareStatement("select firstName, mi, lastName from Student where lastName = ?"; ps.setString(1, "Smith"); ResultSet resultSet = ps.executeQuery(); System.out.println(resultSet.getString(1)); What would be the result?\

Answer 1

The answer to this question can be given as:

In this code, there will be a run-time error.

Explanation:

In the java (database code) this code will have a run-time error because the cursor in resultSet that is the object of the resultSet class does not point any row. we must use resultSet.next() function to pass the cursor to the first row in the resultSet. Finally, resultSet.next() function passes the cursor to the next row in the resultSet class object.