Say Employee_Table has fields like EMP_NO, EMP_NAME, etc. In java, try this:
try{ Connection conn =...//opening connection. PreparedStament ps = con.prepareStatement("Select conn.setAutoCommit(false); Statement stmt = conn.createStatement(); stmt.addBatch( sql 1st insert stmt1 ); stmt.addBatch( sql 2nd insert stmt1 ); ... .... // Set a named savepoint. Savepoint svpt = conn.setSavepoint("NewSavepoint"); ... stmt.addBatch( sql nth insert stmt ); .... if(some condition) { } else //condition not satisfies then rollback { conn.rollback(svpt); } int rowsAfted = stmt.executeBatch( ); conn.commit(); //this commits only the statements before set savepoint method } catch(..) { .. }