JDBC Bulk execution of SQL insert operations

2. Package com.file;
6. Import Java.io.BufferedReader;
8. Import Java.io.FileReader;
10. Import java.util.ArrayList;
14. Public class Resolvfile {
16. public static string readfilecontent (String filepath) {
18. //1. Reading each row of records, saving to list
20. Arraylist<string> records = new arraylist<string> ();
22. try {
24. BufferedReader br = new BufferedReader (new FileReader (filepath));
28. String Arecord;
30. While ((Arecord = Br.readline ()) =null) {
32. Records.add (Arecord); //save each row of records read to list
34. }
36. Br.close (); //Close stream after run
38. } catch (Exception e) {
40. E.printstacktrace ();
42. }
44. //2. Process each record into an SQL statement or Save as an object (a. Remove the semicolon before and after the field B. stitching into SQL or saving as an object)
46. arraylist<string> recordlist = new arraylist<string> (); Used to save the generated SQL or object
48. For (int i = 0;i<records.size (); i++) {
50. String record = Records.get (i);
52. string[] Recarray = Minusquotation (Record.split (","));
56. //Splicing SQL statements or saving as objects
58. String recordsql = Getrecordsql (Recarray);
60. if (null!=recordsql) {
62. Recordlist.add (Recordsql);
64. }
66. }
68. //3. Bulk execution of SQL or saving objects
70. Batchexecutesql (recordlist);
72. return null;
74. }
76. public static int batchexecutesql (arraylist<string> sqllist) {
78. System.out.println ("can then execute SQL statements or save objects");
80. System.out.println ("======== bulk Execute SQL statement ==========");
82. System.out.println ("Add all statements to statment Stat");
84. For (int i = 0;i<sqllist.size (); i++) {
86. String string = Sqllist.get (i);
88. System.out.println ("by Stat.addbatch (SQL) to add the statement" +i+": '" +string+"'");
90. }
92. System.out.println ("Execute all SQL statements by Stat.executebatch ()");
94. System.out.println ("======== bulk Execute SQL statement end ==========");
96. //int count = Stat.executebatch ();
98. //return count;//Returns the number of statements executed
100. return sqllist.size ();
102. }
104. //Generate SQL for each record
106. public static String Getrecordsql (string[] recarray) {
108. if (null==recarray) {
110. return null;
112. }
114. String recordsql = "INSERT INTO TableName (sms,no,time) VALUES ('" +recarray[0]+"', '" +recarray[2]+"  ', ' "+recarray[5]+");
116. return recordsql;
118. }
120. /** 
122. * Remove the quotation marks at the beginning and end of each element in the array
124. * @param recarray the array to be processed
126. * @return-processed array
128. */
130. public Static string[] Minusquotation (string[] recarray) {
132. For (int i = 0; i < recarray.length; i++) {
134. String str = recarray[i];
136. if (null!=str) {
138. if (str.indexof ( "\" ") = =0)
140. str = str.substring (1,str.length ()); Remove the semicolon from the beginning
142. if (str.lastindexof ("\" ") = = (Str.length ()-1))
144. str = str.substring (0,str.length ()-1); //Remove the last semicolon
146. }
148. Recarray[i] = str;
150. }
152. return recarray;
154. }
156. public static void Main (string[] args) {
158. String filepath = "E:\\sxysms\\smstest.txt";
160. Readfilecontent (filepath);
162. }
164. }

JDBC Bulk execution of SQL insert operations