Additional Notes
What JDBC method executes a PreparedStatement that returns a ResultSet?
Track: Java
Topic: SQL for Java Devs
Focus: PreparedStatements
Java: PreparedStatements
Answer
executeQuery(). Frame the concept in practical terms so you can explain it during interview discussion.
The `executeQuery()` method is used with a PreparedStatement to execute a SQL query that retrieves data, returning the result as a `ResultSet`. For instance, when fetching product details, you'd use `pstmt.executeQuery()` on a query like `SELECT * FROM products WHERE id =?`.
The `executeQuery()` method is used with a PreparedStatement to execute a SQL query that retrieves data, returning the result as a `ResultSet`. For instance, when fetching product details, you'd use `pstmt.executeQuery()` on a query like `SELECT * FROM products WHERE id =?`.
Topics: Java PreparedStatements SQL for Java Devs