方法一:使用java程序生成,一次insert。
注:user表的id为自动增长,所以insert可以不带id
public class MyThread extends Thread {
public void run() {
String url = "jdbc:mysql://localhost/test?useUnicode=true&characterEncoding=utf8";
String name = "com.mysql.jdbc.Driver";
String user = "root";
String password = "111";
Connection conn = null;
try {
Class.forName(name);
conn = DriverManager.getConnection(url, user, password);// 获取连接
conn.setAutoCommit(false);// 关闭自动提交,不然conn.commit()运行到这句会报错
} catch (ClassNotFoundException e1) {
e1.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
Long begin = new Date().getTime();
String prefix = "INSERT INTO user(name,age,sex) VALUES ";
try {
// 保存sql后缀
StringBuffer suffix = new StringBuffer();
// 设置事务为非自动提交
conn.setAutoCommit(false);
// 比起s