Question

Given the following code: 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

Answer:

In this question, the code will be given a run-time error.

Explanation:

In java programming, the database code will give a run-time error because cursor in the resultSet that is the object of the resultSet class not point any rows in the table and we must use the resultSet.next() function. This function passes the cursor value to the first row in resultSet class object and this function helps to pass the value in the cursor for the next row in the resultSet class object.