Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

resultset or prepared stmt?.

 
Arun Martin
Ranch Hand
Posts: 64
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi,
this is one of the questions from the mock exams.
question:
---------
import java.sql.*;
Additional code here
Connection c; c=DriverManager.getConnection("jdbc:msql://host:12/dta");
String str = "update employee set salary=50000
where lname=\'jones\'";
What code would execute the SQL statement above?
options:
-------
Choice 1
Statement s = c.createStatement();
ResultSet rs = s.executeUpdate(str);
Choice 2
PreparedStatement s = c.prepareStatement(str);
ResultSet rs = s.executeUpdate();
Choice 3
c.setSQL(str);
ResultSet rs = c.execute();
Choice 4
ResultSet rs = c.executeUpdate(str);
Choice 5
CallableStatement s = c.createCall(str);
ResultSet rs = s.executeCall();
what would be the appropriate answer?.
arun.
 
Thomas Paul
mister krabs
Ranch Hand
Posts: 13974
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
1 and 2 are wrong because executeUpdate does not return a ResultSet object.
3 is wrong because there is no such method as setSQL() for a Connection object.
4 is wrong because there is no method executeUpdate() for a Connection object.
5 is wrong because there is no such method as createCall in a Connection object and no such method as executeCall() in a CallableStatement object.
So the correct answer is none of the above.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic