java导入txt文件进入mysql

来源:互联网 发布:精通 d3.js pdf 编辑:程序博客网 时间:2024/06/13 10:37
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();}}}