Can we use the one instance of Statment to execute more
than one query ?
- 2 Answers
- 8501 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sachin
To make batch updates using a single statement with several
sets of input parameters, follow these basic steps:
Disable AutoCommit for the Connection object.
Invoke the prepareStatement method to create a
PreparedStatement object for the SQL statement with input
parameters.
For each set of input parameter values:
Execute setXXX methods to assign values to the input
parameters.
Invoke the addBatch method to add the set of input
parameters to the batch.
Invoke the executeBatch method to execute the statements
with all sets of parameters.
Check for errors. If no errors occurred:
Get the number of rows that were updated by each execution
of the SQL statement from the array that the executeBatch
invocation returns.
Invoke the commit method to commit the changes.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How can I instantiate and load a new CachedRowSet object from a non-JDBC source?
What port does jdbc use?
What is meant by jdbc?
What is drivermanager in jdbc?
What are the factors that the jdbc driver performance depends upon?
How to use JDBC API to call Stored Procedures?
What is jdbc driver manager?
How can you retrieve data from the resultset using jdbc?
Is jdbc object oriented?
Why can't I invoke the ResultSet methods afterLast and beforeFirst when the method next works?
What are the standard isolation levels defined by JDBC?
What are the different types of locking in JDBC?
What is an encrypted internet connection?
Explain creation of statement object with connection method create method with help of an example.
How many types of jdbc drivers are there?
