Java reads the local TXT file and inserts the database

2. Package com.cniia.ny.web.control.configManage;
   
4. 
   
6. 
   
8. Import Java.io.BufferedReader;
   
10. Import Java.io.File;
    
12. Import Java.io.FileReader;
    
14. Import java.io.IOException;
    
16. Import java.sql.Connection;
    
18. Import Java.sql.DriverManager;
    
20. Import java.sql.PreparedStatement;
    
22. Import Java.sql.ResultSet;
    
24. Import java.sql.SQLException;
    
26. Import java.util.ArrayList;
    
28. Import java.util.List;
    
30. Import Java.util.Scanner;
    
32. 
    
34. 
    
36. public class Insertintodb {
    
38. Read Text operations
    
40. public static string[] Writetodat (String path) {
    
42. File File = new file (path);
    
44. list<string> list = new arraylist<string> ();
    
46. String []strings = null;
    
48. try {
    
50. BufferedReader bw = new BufferedReader (new FileReader (file));
    
52. String line = null;
    
54. Because I do not know a few rows of data, it is first saved in the list collection
    
56. while (line = Bw.readline ()) = null) {
    
58. List.add (line);
    
60. }
    
62. Bw.close ();
    
64. } catch (IOException e) {
    
66. E.printstacktrace ();
    
68. }
    
70. Determining the length of an array
    
72. strings = new String[list.size ()];
    
74. for (int i=0;i<list.size (); i++) {
    
76. string s = (string) list.get (i);
    
78. Strings[i] = s;
    
80. }
    
82. return strings;
    
84. }
    
86. Connecting to a database
    
88. public static Connection getconnection (String data,string user,string pwd) {
    
90. 
    
92. Connection conn = null;
    
94. try {
    
96. Class.forName ("Com.mysql.jdbc.Driver");
    
98. conn = Drivermanager.getconnection ("jdbc:mysql://127.0.0.1:3306/" + Data + "? Characterencoding=utf-8", user, PWD);
    
100. } catch (Exception e) {
     
102. E.printstacktrace ();
     
104. }
     
106. Return conn;
     
108. }
     
110. Insert a database, only for one field
     
112. public static Boolean Insertinto (String data,string table,string field,string user,string pwd,string []str) {
     
114. try {
     
116. Connection conn = getconnection (DATA,USER,PWD);
     
118. Conn.setautocommit (FALSE);
     
120. String sql = "INSERT into" + Table + "(" + Field + ") VALUES (?);";
     
122. PreparedStatement pstmt = conn.preparestatement (sql);
     
124. for (int i = 0; i < str.length; i++) {
     
126. Pstmt.setstring (1, str[i]);
     
128. Pstmt.executeupdate ();
     
130. Conn.commit ();
     
132. }
     
134. Conn.commit ();
     
136. return true;
     
138. } catch (SQLException e) {
     
140. TODO auto-generated Catch block
     
142. E.printstacktrace ();
     
144. return false;
     
146. }
     
148. 
     
150. }
     
152. public static string[] query (String data,string table,string field,string user,string pwd) {
     
154. try {
     
156. String []STR = null;
     
158. int i = 0;
     
160. Connection conn = getconnection (DATA,USER,PWD);
     
162. String sql = "Select" + Field + "from" + Table + ";";
     
164. PreparedStatement pstmt = conn.preparestatement (sql);
     
166. ResultSet rs = Pstmt.executequery ();
     
168. while (Rs.next ()) {
     
170. Str[i] = rs.getstring (field);
     
172. i++;
     
174. }
     
176. return str;
     
178. } catch (SQLException e) {
     
180. TODO auto-generated Catch block
     
182. E.printstacktrace ();
     
184. return null;
     
186. }
     
188. 
     
190. }
     
192. public static void Main (string[] args) {
     
194. String []STR2 = null;
     
196. String []STR = null;
     
198. String []STR3 = null;
     
200. Boolean flage1 = true;
     
202. Boolean flage2 = true;
     
204. Boolean flage3 = true;
     
206. System.out.println ("Please enter the absolute path of the target file:");
     
208. Scanner sc = new Scanner (system.in);
     
210. String path = Sc.next ();
     
212. while (Flage3) {
     
214. if (Path!=null&&!path.equals ("")) {
     
216. Flage3 = false;
     
218. str = writetodat (path);
     
220. }else {
     
222. SYSTEM.OUT.PRINTLN ("Input cannot be empty");
     
224. }
     
226. }
     
228. System.out.println ("Please enter the database name of the desired connection, table name, field name (only one), user name, password," # "separated:");
     
230. String stra = Sc.next ();
     
232. while (Flage1) {
     
234. if (Stra!=null&&!stra.equals ("")) {
     
236. Flage1 = false;
     
238. while (Flage2) {
     
240. if (Stra.indexof ("#") >=0) {
     
242. Flage2 = false;
     
244. STR2 = Stra.split ("#");
     
246. }else {
     
248. SYSTEM.OUT.PRINTLN ("You have entered a wrong format, please re-enter");
     
250. }
     
252. }
     
254. }else {
     
256. SYSTEM.OUT.PRINTLN ("Input cannot be empty");
     
258. }
     
260. }
     
262. Boolean B = Insertinto (str2[0], str2[1], str2[2], str2[3], str2[4],str);
     
264. if (b) {
     
266. System.out.println ("Insert succeeded!");
     
268. }else {
     
270. System.out.println ("Insert failed!");
     
272. }
     
274. STR3 = Query (Str2[0], str2[1], str2[2], str2[3], str2[4]);
     
276. for (int i = 0; i < str3.length; i++) {
     
278. System.out.println (Str3[i]);
     
280. }
     
282. }
     
284. 
     
286. }
     

Copy Code

Java reads the local TXT file and inserts the database