How to execute bulk number of queries at once?

Answer Posted / kalyan

we can update multiple statements using batch as follows

statemenent st = getconnection().getStatement();
st.addBatch(sql stat1);
st.addBatch(sql stat2) ;

....

st.executeBatch();

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is jdbc connection secure?

708


What is savepoint in jdbc?

708


How many types of jdbc drivers are available?

697


How does jdbc driver work?

747


Is it possible to connect to multiple databases? Using single statement can we update or extract data from two or three or many databases?

827


What is layer in communication?

664


How can we execute stored procedures?

775


How does JDBC API helps us in achieving loose coupling between Java Program and JDBC Drivers API?

856


explain about special characters?

760


Does jdbc use odbc?

709


What does adapter class provide?

718


Why is jdbc used?

711


How java can be connected to a database?

815


How does a custom RowSetReader get called from a CachedRowSet?

836


Give an example of code used for setting up connection with a driver.

731