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
- 9622 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 does the jdbc driver interface do?
How can I use the JDBC API to access a desktop database like Microsoft Access over the network?
Which is better jpa or jdbc?
Does jdbctemplate use prepared statements?
How do we call a stored procedure from jdbc?
What protocol does jdbc use?
What is odbc. how is it related to sql cli?
What is jdbc connection?
What do you mean by odbc?
Can I enable requests to a jdbc connection pool for a database connection to wait until a connection is available?
Where is jdbc used?
What is a merge field?
What are the different types of JDBC drivers?
What is odbc and jdbc in dbms?
Once I have the Java 2 SDK, Standard Edition, from Sun, what else do I need to connect to a database?
