将一个student.txt文件的数据导入mysql数据库中.txt

java 的代码

将一个student.txt文件的数据导入MySQL数据库中一张student1表中: 
import java.io.*; 
import java.sql.*; 
import java.util.*; 

public class TextToDataBase { 

/** 
* @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/exercise1","root","root"); 

pstm=con.prepareStatement("insert into student1 (ID,name,age,gendar,score) values(?,?,?,?,?)"); 


fr=new FileReader("D:\\Exercise\\student.txt"); 
br=new BufferedReader(fr); 


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

String s=br.readLine(); 
        StringTokenizer st=new StringTokenizer(s); 
    
        int ID=Integer.parseInt(st.nextToken()); 
        String name=st.nextToken(); 
        int age=Integer.parseInt(st.nextToken()); 
        String gendar=st.nextToken(); 
        int score=Integer.parseInt(st.nextToken()); 
        
pstm.setInt(1,ID); 
pstm.setString(2,name); 
pstm.setInt(3,age); 
pstm.setString(4,gendar); 
pstm.setInt(5,score); 
pstm.executeUpdate(); 
} 
br.close(); 
pstm.close(); 
con.close(); 
} catch (ClassNotFoundException e) { 
e.printStackTrace(); 
} catch (SQLException e) { 

e.printStackTrace(); 
} catch (FileNotFoundException e) { 

e.printStackTrace(); 
} catch (IOException e) { 

e.printStackTrace(); 
} 
} 
} 

注意:将student.txt文件内容建成如下形式: 
1  张三      20  male  80 
2  lisi      24  female  86 
3  wangwu    25  male    93 
4  liuliu    36  female  89 
5  zhaoqi    29  male    81