将一个student.txt文件的数据导入MySQL数据库中一张student1表中

蔚落 2022-08-27 12:39 163阅读 0赞

将一个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