MCQs > IT & Programming > Java > Choose the right syntax for a preparedStatement using ? as a placeholder for values namely CUSTOMER_ID,PRICE to be substituted while inserting values in the table ORDER: PreparedStatement ps=con.prepareStatement('INSERT INTO ORDER (CUSTOMER_ID ,PRICE) VALUES(?,?)');

Java MCQs

Choose the right syntax for a preparedStatement using ? as a placeholder for values namely CUSTOMER_ID,PRICE to be substituted while inserting values in the table ORDER:

PreparedStatement ps=con.prepareStatement("INSERT INTO ORDER (CUSTOMER_ID ,PRICE) VALUES(?,?)");


Answer

Correct Answer: ps.clearParameters(); <br>ps.setInt(1,3); ps.setDouble(2,790.50); ps.executeUpdate(); 

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Java Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it

search

Java Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it