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();
}
}
}
java导入txt文件进入mysql
最新推荐文章于 2024-08-22 09:42:15 发布