package dbtest; import java.sql.Connection; import java.sql.ResultSet; import java.sql.Statement; public class BatchUpdate { public static void main(String[] args) throws Exception { Connection conn=DbUtil.getConnection(); Statement st=null; try { System.out.println("start at: "+new java.util.Date()); st=conn.createStatement(); for(int i=0; i<1000; i++) { st.addBatch("Insert Into db1.View1 (SourceSystemId, AirlineCode, SubCd, Code1, Code2, TrackingPeriod, SomeValue) values " +"('ZA', 'ZA', '01', 'RV', '02', 'D', "+i+")"); } st.executeBatch(); System.out.println("end at: "+new java.util.Date()); } catch (Exception e) { e.printStackTrace(System.out); } finally { if(st!=null) st.close(); } System.out.println("done with Batch Insert"); } }