将一个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 802 lisi 24 female 863 wangwu 25 male 934 liuliu 36 female 895 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