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
- 9799 Views
- Cybermate, Hexaware, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kaviarasan
Good Question .
Berofe Writing the prepared statement ...
every one of us ill load the driver by using
Class.forName("Some driver which has the Driver class")
Here the this Driver Class/object triggers out the other
classes in which that class implements the neccessary
interface for the operation ....
preparedStatement ps=connection.getPreparedstatement();
this function ill returns the object from the Driver
instancianted class
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / shaik
If ur doubt is "PreparedStatement is an interface, how can
we have an object for it" , then ans is.
PreparedStatement object is the object of one of the
implementation class(that implements PreparedStatement(I))
of PreparedStatement(I).
| Is This Answer Correct ? | 2 Yes | 3 No |
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 |
what is the meaning of following code snippets Class c=class.forName(driverClassName); Driver d=(driver)c.newInstance();
Is jpa faster than jdbc?
What are the steps involved in establishing a connection using jdbc in java?
Is jdbc database independent?
What is an escape syntax?
what is rowset?
Explain the difference between inner and outer join ?
Which package is used for jdbc application?
Why resultset is used in java?
What does the jdbc resultsetmetadata interface?
What is jdbc architecture in java?
How does jdbc driver work?
Core Java 
