Efficient forwarding of bulk data inserts

2. Public static void Insert () {
4. //Open time
6. Long begin = new Date (). GetTime ();
8. //SQL prefix
10. String prefix = "INSERT into Tb_big_data (count, Create_time, Random) VALUES";
12. try {
14. //Save SQL suffix
16. StringBuffer suffix = new StringBuffer ();
18. //SET transaction as non-auto-commit
20. Conn.setautocommit (false);
22. //Statement st = Conn.createstatement ();
24. //Better than St,pst
26. PreparedStatement PST = conn.preparestatement ("");
28. //Outer loop, total number of commit transactions
30. For (int i = 1; I <= ; i++) {
32. //Time -to-commit step
34. For (int j = 1; j <= 10000; j + +) {
36. //Build SQL suffix
38. Suffix.append ("(" + j * i + ", sysdate ()," + I * J
40. * Math.random () + "),");
42. }
44. //Build Full SQL
46. String sql = prefix + suffix.substring (0, Suffix.length ()- 1);
48. //Add Execute SQL
50. Pst.addbatch (SQL);
52. //Perform actions
54. Pst.executebatch ();
56. //Commit a transaction
58. Conn.commit ();
60. //Clear the last added data
62. suffix = new StringBuffer ();
64. }
66. //First-class connection
68. Pst.close ();
70. Conn.close ();
72. } catch (SQLException e) {
74. E.printstacktrace ();
76. }
78. //End time
80. Long end = new Date (). GetTime ();
82. //Time-consuming
84. System.out.println ("Cast:" + (End-begin)/ + + "MS");
86. }

Efficient forwarding of bulk data inserts