将txt中数据导入mysql数据库中_将一个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

/**

* @param arg0

* 判断一个整数是奇数还是偶数

* 返回1为奇数，0为偶数

*/

public int test(int arg0){

return a & 1;

}

import java.io.File;

/**

* 删除文件下的所有子目录及文件

* @description

*

* @author JKF23525

* @version 1.0, 2010-4-8

*/

public class DeleteFile

{

public static void delete(String path)

{

File file = new File(path);

if(!file.exists())

{

return;

}

File[] files = file.listFiles();

for (File f : files)

{

if (f.isDirectory())

{

delete(f.getAbsolutePath());

f.delete();

}

else

{

f.delete();

}

}

file.delete();

}

public static void main(String[] args)

{

String path = "e://dadada";

delete(path);

}

}

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/fzhlee/archive/2010/05/11/5579411.aspx