批量插入

1. 传统循环插入
2. Mybatis foreach插入
3. jdbc批量插入

1、传统循环插入，代码如下

		long time = System.currentTimeMillis();for (int i = 0; i < 200000; i++) {studentMapper.batchInsert("ORDER_NO:" + i);}System.out.println("批量插入20万数据，耗费了" + (System.currentTimeMillis() - time) + "ms");

xml

<insert id="batchInsert">insert into t_order(id,order_no,create_time,status) values (null,#{item},'2020-1-19','0')
</insert>

结果如下：

换算成秒：5998976/1000=5998.976秒，约等于99.9829335分钟

2、Mybatis foreach插入，代码如下

3、jdbc批量插入，代码如下

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;public class BatchInsertTest {private static String url = "jdbc:mysql://localhost:3306/ml?rewriteBatchedStatements=true";private static String user = "root";private static String password = "123456";public static void main(String[] args) {Connection con = null;PreparedStatement ps=null;try {Class.forName("com.mysql.jdbc.Driver");con = DriverManager.getConnection(url, user, password);String sql = "insert into t_order(id,order_no,create_time,status) values (null,?,'2020-1-19','0')";ps = con.prepareStatement(sql);long time = System.currentTimeMillis();for(int i=0;i<200000;i++){ps.setString(1,"ORDER_NO:"+i);ps.addBatch();}ps.executeBatch();System.out.println("批量入20万数据，耗费了"+(System.currentTimeMillis()-time)+"ms");} catch (Exception e) {e.printStackTrace();}finally {if (ps!=null) {try {ps.close();} catch (SQLException e) {e.printStackTrace();}}if (con!=null) {try {con.close();} catch (SQLException e) {e.printStackTrace();}}}}
}

切记要修改连接配置

执行结果如下：

换算成秒：4988/1000=4.988秒