多线程导入GB数据到MySQL

create table student(
    id int,
    name varchar(10)
);

package com.test;

import java.io.BufferedWriter;
import java.io.FileWriter;
import java.io.IOException;
import java.util.ArrayList;

/**
 * 
 * 此类描述的是：用来生成student,score表的模拟数据
 * @author: dmnrei@gmail.com
 * @version: 2013-10-17 下午3:52:09
 */
public class LX1017 {
    /**
     * 表记录数，默认一千万
     */
    static int recordNum = 10000000;

    public static void main(String[] args) throws IOException {
        // 生成学生表的sql文件
        generateStudent();
    }

    public static void generateStudent() throws IOException {
        FileWriter fileWriter2 = new FileWriter("student.sql", false);  
        BufferedWriter bufferedWriter = new BufferedWriter(fileWriter2);  

        StringBuffer sb = new StringBuffer(1024*1024);
        for(int i=1; i<=recordNum; i++) {
            String str = "insert into student values(" + i+ ", '" + i + "');";
            sb.append(str);
            sb.append("\n");

            if(i%10000 == 0) {
                bufferedWriter.write(sb.toString());
                bufferedWriter.flush();
                sb = new StringBuffer(1024*1024);
            }
        }
        bufferedWriter.close();
    }
}