Mybatis插入大量数据效率对比：foreach插入、SqlSession批量插入、sql插入

//                sqlSession.clearCache();

}

}

//        sqlSession.commit();

//        sqlSession.clearCache();

sqlSession.flushStatements();

System.out.println(“SqlSession 批量插入耗时：”+(System.currentTimeMillis()-start));

}

@Test

public void forEachInsert() {

System.out.println(“forEachInsert 插入开始========”);

long start = System.currentTimeMillis();

for (int i = 0; i < list.size(); i++) {

usersMapper.insert(list.get(i));

}

System.out.println(“foreach 插入耗时：”+(System.currentTimeMillis()-start));

}

@Test

public void sqlInsert() {

System.out.println(“sql 插入开始========”);

long start = System.currentTimeMillis();

usersMapper.sqlInsert(list);

System.out.println(“sql 插入耗时：”