Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of statements?
- 4 Answers
- 19583 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / chandrarekha
Statement interface----createStatement() method is useful
to create statement object and to execute simple queries...
PreparedStatement interface---derived from the Statement
interface...preparestatement() method used to create
preparedstatement object and used to execute queries with
unknown parameters or where in the parameters are provided
at the run-time
CallabaleStatement interface----derived from the
preparedstatement interface and helpful in executing stored
procedures...prepareCall() method is used to create the
callabalestatement object
| Is This Answer Correct ? | 45 Yes | 6 No |
Answer / niranjanravi
statement
preparedstatement
callable sattement
| Is This Answer Correct ? | 29 Yes | 9 No |
Answer / rashmi
there are 3 types of statements used in jdbc
------
1.createStatement()
2.preparedStatement()
3.callableStatement()
createStatement returns the object of statement.through this we can call methods belongs
to the statement interface.preparedStatement returns the object of preparedstatement.through this we can call methods belongs
to the preparedstatement interface.
The difference b/w statement and preparedstatement is :
if we use statement the sql querry parses by the database server each and every time.when
we send the request. but by using preparedstatement the sql querry parses only once and that
parsed querry is used every time.
for example if there are 100 sql statements by using statement 100 parsings are necessary.
but by using preparedStatement the parsing is happened only once.so we can save the 99 parsings.
The callablestatement is used to call the storedprocedures.
| Is This Answer Correct ? | 15 Yes | 4 No |
How we can you use preparedstatement.
Are there any ODBC drivers that do not work with the JDBC- ODBC Bridge?
is that compulsory to have Primarykey-forignkey for joints (outer inner,equal)
What is encrypted connection?
What is difference between statement and preparedstatement in jdbc?
What is ojdbc?
What is phantom read and which isolation level prevents it?
How do I retrieve a whole row of data at once, instead of calling an individual ResultSet.getXXX method for each column?
What is jdbc url for mysql?
What is the function of setautocommit?
Which package is used for jdbc application?
What are the different types of locking in JDBC?
Core Java 
