Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

What are the different types of drivers under jdbc?

849


Result set’s index starts with 0 or 1?

1038


What does connection pooling mean ?

979


In which ways is driver class is registered with drive manager?

925


What do you mean by odbc?

1015


What is in term of jdbc a datasource?

914


Why isn't the java.sql.DriverManager class being found?

995


How many types of jdbc drivers are available?

931


Explain about column name and getter method?

1060


Which of the attributes in the monitoring tab for a jdbc connection pool in the administrative console tell us how many clients are currently waiting for a connection?

911


What are the classes and methods used for sending sql statements to database?

1073


What is SQL Warning? How to retrieve SQL warnings in the JDBC program?

1038


Why prepared statements are faster?

942


What is database connection pooling? Advantages of using a connection pool?

1046


RowSetInternal caller and returns void. What can I do in the readData method?

972