long start = System.currentTimeMillis();
Users user;
for (int i = 1; i <=50000 ; i++) {
user = new Users();
user.setId(i);
user.setName(“java”);
user.setAge(200);
user.setManagerId(222);
list.add(user);
}
System.out.println(“拼装数据 耗时:”+(System.currentTimeMillis()-start));
System.out.println(list.size());
}
@Test
public void batchInsert() {
SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH,false);
UsersMapper mapper = sqlSession.getMapper(UsersMapper.class);
System.out.println(“batchInsert 插入开始========”);
long start = System.currentTimeMillis();
for (int i = 0; i < list.size(); i++) {
mapper.insert(list.get(i));
if (i%5000==4999) {
sqlSession.flushStatements();
// sqlSession.commit();
// 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 插入耗时:”+(System.currentTimeMillis()-start));
}
//xml批量插入
@Test
public void xmlInsert() {
System.out.println(“xmlInsert 批量插入开始========”);
long start = System.currentTimeMillis();
usersMapper.xmlBatchInsert(list);
System.out.println(“xmlInsert 批量插入耗时:”+(System.currentTimeMillis()-start));
}
}
//sql插入相关类
@Repository
public interface UsersMapper extends BaseMapper {
@InsertProvider(type = UsersProvider.class, method = “insertListSql”)
public void sqlInsert(List list);
public void xmlBatchInsert(@Param(“list”) List list);
}
public class UsersProvider {
public String insertListSql(List list) {
StringBuffer sqlList = new StringBuffer();
sqlList.append(" INSERT INTO users(id,name,age,manager_id) VALUES ");
for (int i = 0; i < list.size() ; i++) {
Users user = list.get(i);
sqlList.append(" (“).append(user.getId()).append(”,“).append(”‘“).append(user.getName()).append(”’,").append(user.getAge())
.append(“,”).append(user.getManagerId()).append(“)”);
if (i < list.size()-1) {
sqlList.append(“,”);
}
}
return sqlList.toString();
}
}
xml 插入mapper文件
<?xml version="1.0" encoding="UTF-8"?>INSERT INTO users(id,name,age,manager_id) VALUES
(#{item.id},
#{item.name},
#{item.age},
#{item.managerId})
总结
总结
面试建议是,一定要自信,敢于表达,面试的时候我们对知识的掌握有时候很难面面俱到,把自己的思路说出来,而不是直接告诉面试官自己不懂,这也是可以加分的。
以上就是蚂蚁技术四面和HR面试题目,以下最新总结的最全,范围包含最全MySQL、Spring、Redis、JVM等最全面试题和答案,仅用于参考
总结
总结
面试建议是,一定要自信,敢于表达,面试的时候我们对知识的掌握有时候很难面面俱到,把自己的思路说出来,而不是直接告诉面试官自己不懂,这也是可以加分的。
以上就是蚂蚁技术四面和HR面试题目,以下最新总结的最全,范围包含最全MySQL、Spring、Redis、JVM等最全面试题和答案,仅用于参考
[外链图片转存中…(img-h6AK10GZ-1718772585322)]