JDBC and Prepared Statements | Dataford Interview Questions

Explain the difference between JDBC Statement and PreparedStatement, and how you would parse and use the returned results from a query.

Use the query_results table below as the source of returned rows. Focus on how the result set should be read, filtered, and mapped into usable values.

Output

One row per returned query result row.
Columns: result_id, sql_text, row_count, status, parsed_value.
Ignore rows where status is NULL.
Sort by result_id ascending.

Schema

query_results

Column	Type	Description
result_idPK	INT	Unique identifier for the returned result row
sql_text	VARCHAR(500)	SQL text that was executed
row_count	INT	Number of rows returned by the query
status	VARCHAR(20)	Execution status for the returned row
parsed_value	VARCHAR(100)	Value parsed from the result set

Your question is JDBC and Prepared Statements. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem