What are the different types of statements?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is jdbc a middleware?

502


What do you mean by batch processing in jdbc?

525


How do I check in my code whether a maximum limit of database connections have been reached?

581


What is url in jdbc connection?

505


What are database warnings in jdbc and how can we handle database warnings in jdbc?

611






Is possible to open a connection to a database with exclusive mode with JDBC?

544


What is database deadlock ?

538


What is encrypted connection?

496


What is jsp and jdbc?

493


How many ways can you update a result set?

559


What does executequery return in java?

509


Explain how data flows from view to db and reverse

1630


I have the choice of manipulating database data using a byte[] or a java.sql.blob. Which has best performance?

483


What is the use of setFetchSize() and setMaxRows() methods in Statement?

519


What are different types of ResultSet?

582