代码实现部分:
//批量插入数据
String sql = "insert into person values(?,?,?)";
// String sql = "delete from person";
//?rewriteBatchedStatements=ture;
String url = "jdbc:mysql://localhost:3306/huanlesong?rewriteBatchedStatements=true";
String classname = "com.mysql.jdbc.Driver";
String user = "root";
String password = "root";
try {
Class.forName(classname);
//PreparedStatement ps = DBHelper.getConnection().prepareStatement(sql);
PreparedStatement ps = DriverManager.getConnection(url, user, password).prepareStatement(sql);
for(int i=0;i<20000;i++){
ps.setString(1, UUID.randomUUID().toString());
ps.setString(2, UUID.randomUUID().toString());
ps.setString(3, UUID.randomUUID().toString());
ps.addBatch();
}
ps.executeBatch();
// ps.executeUpdate();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
mysql快速批量插入url
String url = "jdbc:mysql://localhost:3306/huanlesong?rewriteBatchedStatements=true";