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
- 9480 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
Does jdbc use ssl?
What is the full form of jdbc and what is its purpose?
What are the jdbc statements?
Why would you use setautocommit(false) in jdbc?
What are the advantages of using preparedstatement over statement?
What is the different between ResultSet and RowSet?
Write a program JDBCcode forfetching student database with SQL.
Name the new features added in jdbc 4.0.
What is jdbc and why is it required?
Describe the steps needed to execute a sql query using jdbc.
How to insert and delete a row programmatically? (new feature in JDBC 2.0)
What are the main steps in java to make JDBC connectivity?
What are four types of JDBC driver?
Is it possible to connect to multiple databases simultaneously?
What is phantom read and which isolation level prevents it?
