Computer scienceProgramming languagesJavaAdditional instrumentsJDBC

JDBC Prepared Statements

SQL keywords

Report a typo

What happens if we execute the following code:

String delete = "DELETE ? customers WHERE id = ?";

try (PreparedStatement preparedStatement = con.prepareStatement(delete)) {
    preparedStatement.setObject(1, "FROM");
    preparedStatement.setObject(2, "42");

    preparedStatement.executeUpdate();
}

Select one option from the list

It will delete a customer with id equals 42

It will execute successfully but do nothing

It will delete 42th row of the customer table

It will throw an SQL exception

___

Create a free account to access the full topic