java txt到mysql_java导入txt文件进入mysql | 学步园

package importMysql;

import java.io.*;

import java.sql.*;

import java.util.*;

public class importTry {

/**

* @param args

* 本程序涉及文件IO,字符串分隔StringTokenizer,JDBC,数据库sql语句

*/

public static void main(String[] args) {

Connection con = null;

PreparedStatement pstm = null;

FileReader fr = null;

BufferedReader br = null;

try {

Class.forName("com.mysql.jdbc.Driver");

con = DriverManager.getConnection(

"jdbc:mysql://localhost:3306/test", "root", "123");

pstm = con

.prepareStatement("insert into testr (abc,def) values(?,?)");

fr = new FileReader("J://testR.txt");

br = new BufferedReader(fr);

for (int i = 0; i < 20; i++) {

String s = br.readLine();

StringTokenizer st = new StringTokenizer(s);

String abc = st.nextToken();

String def = st.nextToken();

pstm.setString(1, abc);

pstm.setString(2, def);

pstm.executeUpdate();

}

br.close();

pstm.close();

con.close();

System.out.println("插入成功");

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

} catch (FileNotFoundException e) {

e.printStackTrace();

} catch (IOException e) {

e.printStackTrace();

}

}

}