1600 PMP mock questions 1400 CAPM mock questions 800 SCJP 6 mock questions 600 OCAJP 7 mock questions 590 OCPJP 7 mock questions 556 SCWCD 5 mock questions 500 OCEJWCD 6 mock questions pdfDownload (java,struts, hibernet etc)

JDBC Tutorials

Q. What is Batch Updates Using Statements in JDBC ?

Batch Updates calls to database as a chunk.
If you want to run more than one sql statement in a single database call then you have to go for Batch Update.
All Insert in single data base call and single transaction ( if one fail the all fail)

For Example :
public class TestDB {
public static void main(String[] args) {
try {

/** Loading the driver*/

Class.forName("com.oracle.jdbc.Driver");

/** Getting Connection*/
Connection con = DriverManager.getConnection("jdbc:oracle://localhost:3306/test","test","test");

/** Creating Statement*/
con.setAutoCommit(false); // This means after all insert then commit at last
Statement stmt = con.createStatement();
        stmt.addBatch("INSERT INTO EMP VALUES(1,'Ram1')");
        stmt.addBatch("INSERT INTO EMP VALUES(2,'Ram2')");
        stmt.addBatch("INSERT INTO EMP VALUES(3,'Ram3')");
        stmt.addBatch("INSERT INTO EMP VALUES(4,'Ram4')");
        int [] updateCounts= stmt.executeBatch();
        con.commit();
        con.setAutoCommit(true);
        /// All Insert in single data base call and single transaction ( if one fail the all fail)

stmt.close();
con.close();

} catch (Exception e) {

e.printStackTrace();
}
     }
}

Reviews and Comments


PMP, CAPM, PMI is a registered certification mark of the Project Management Institute, Inc

Copyright © www.techfaq360.com 2016


About US | Contact US | Privacy Policy | Terms and Conditions  | Website disclaimer  | Cancellation and Refund Policy  | Shipping & Delivery Policy