Interested to Buy Any Domain ? << Click Here >> for more details...
Hi my doubt is that preparedStatement is a interface means
which has no implemenation.plz go thru the code below
String sql = "SELECT * FROM movies WHERE year_made = ?";
prest = con.prepareStatement(sql);
prest.setInt(1,2002);
ResultSet rs1 = prest.executeQuery();
Now setInt and executeQuery how it works since it is
interface it does not have implementation how it works, how
executeQuery returns result from database as executequery
method has no implementation even in Statement interface.
- 4 Answers
- 9802 Views
- Cybermate, Hexaware, I also Faced
- E-Mail Answers
Answer Posted / kanu
Since the prepared statement is a precompiled statement and
this SQL statement is sent to the DBMS right away, where it
is compiled. As a result, the PreparedStatement object
contains not just an SQL statement, but an SQL statement
that has been precompiled. This means that when the
PreparedStatement is executed, the DBMS can just run the
PreparedStatement SQL statement without having to compile
it first.
| Is This Answer Correct ? | 4 Yes | 8 No |
Post New Answer View All Answers
What packages are used by jdbc?
What is the reason why we need a jdbcrowset like the wrapper around resultset?
Is jdbc faster than odbc?
Where jdbc drivermanager class is used?
What port does jdbc use?
What is odbc. how is it related to sql cli?
What is jdbc connection string?
Give a way to check that all result sets have bin accessed and update counts are generated by execute method.
Is jdbc faster than hibernate?
What is the difference between jdbc and jndi?
What are the differences between stored procedure and functions?
What is DML?
What is difference between statement and preparedstatement in jdbc?
Describe how the jdbc application works.
What are clob and blob data types in jdbc?
