MySQL多线程完成10万条数据插入数据库

package com.eshore.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.Date;

public class Threadtest extends Thread {
	public void run() {
		String url = "jdbc:mysql://ip:port/test";
		String name = "com.mysql.jdbc.Driver";
		String user = "账号";
		String password = "密码";
		Connection conn = null;
		try {
			Class.forName(name);
			conn = DriverManager.getConnection(url, user, password);// 获取连接
			System.out.println("数据库连接成功");
			conn.setAutoCommit(false);// 关闭自动提交，不然conn.commit()运行到这句会报错
		} catch (ClassNotFoundException e1) {
			e1.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		// 开始时间
		Long begin = new Date().getTime();
		// sql前缀
		String prefix = "INSERT INTO test_teacher (name,password,sex,description,url,schoolname,remark) VAL