Given the following code: PreparedStatement ps = connection.prepareStatement("select firstName, mi, lastName from Student where

Question

2 years ago

13

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?

Computers and Technology

1 answer:

katen-ka-za [31] · Answer 1 · 2022-09-12T20:05:23+03:00

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.