java 批量插入10万条数据

for (int i = 0; i < 100000; i++) {
                dbHelper.insert("INSERT aaa(name)  Values (‘1‘)");
            }

conn = getConn();
// JAVA默认为TRUE,我们自己处理需要设置为FALSE,并且修改为手动提交,才可以调用rollback()函数
conn.setAutoCommit(false);
st = conn.createStatement();
long start = System.currentTimeMillis();
for (int i = 0; i < 100000; i++) {
    st.execute("INSERT bbb(name)  Values (‘1‘)");
}
// 事务提交
conn.commit();
long end = System.currentTimeMillis();
System.out.println("运行时间==" + (end - start) + "ms");

conn = getConn();
// JAVA默认为TRUE,我们自己处理需要设置为FALSE,并且修改为手动提交,才可以调用rollback()函数
conn.setAutoCommit(false);
st = conn.createStatement();
long start = System.currentTimeMillis();
for (int i = 0; i < 100000; i++) {
    st.addBatch("INSERT ccc(name)  Values (‘1‘)");
}
st.executeBatch();
// 事务提交
conn.commit();

&rewriteBatchedStatements=true