Java BULK Insert Data (Oracle)

2. 8 seconds to add 20,000 data in bulk.
4. try {
6. String url = "Jdbc:oracle:thin: @IP: 1521:ORCL"; //ORCL is the SID of the database
8. String user = "Oracle";
10. String password = "Oracle";
12. StringBuffer sql = new StringBuffer ();
14. Sql.append ("INSERT into Ex_log (ex_log_id,ex_log_date) VALUES (?,?)");
16. Class.forName ("Oracle.jdbc.driver.OracleDriver");
18. Connection con = (Connection) drivermanager.getconnection (Url,user,password);
20. //Turn off transaction autocommit
22. Con.setautocommit (false);
26. Long startTime = System.currenttimemillis ();
28. PreparedStatement PST = (preparedstatement) con.preparestatement (sql.tostring ());
30. For (int i = 0; i < list.size (); i++) {
32. Exlog Exlog = (exlog) list.get (i);
34. Pst.setstring (1, Exlog.getexlogid ());
36. Pst.setstring (2, Exlog.getexlogdate ());
38. //Add a SQL command to the command list
40. Pst.addbatch ();
42. }
44. //Perform batch updates
46. Pst.executebatch ();
48. //Statement execution complete, commit this transaction
50. Con.commit ();
52. Long endTime = System.currenttimemillis ();
54. System.out.println ("spents:" + (Endtime-starttime));
56. Pst.close ();
58. Con.close ();
60. } catch (ClassNotFoundException e) {
62. E.printstacktrace ();
64. } catch (SQLException e) {
66. E.printstacktrace ();
68. }

Java BULK Insert Data (Oracle)