BATH(批量操作)
<insert id="addMax" parameterType="ArrayList">
insert into tb_user(id,password,username) values
<foreach collection="list" item="item" separator=",">
(#{item.id},#{item.password},#{item.username})
</foreach>
</insert>
text04.java
public class text04 {
public static void main(String[] args) {
String resource="MybatisMainCof.xml";
InputStream is=Text01.class.getClassLoader().getResourceAsStream(resource);
SqlSessionFactory sessionFactory=new SqlSessionFactoryBuilder().build(is); //通过配置文件获取链接工厂
SqlSession sqlSession=sessionFactory.openSession(); //获取链接
UserDao userDao=sqlSession.getMapper(UserDao.class);
List<User> list=new ArrayList<>();
for(int i=0;i<100;i++) {
User user=new User(i+"","zhangsan","123");
list.add(user);
}
long start=Calendar.getInstance().getTimeInMillis();
userDao.addMax(list);
long end=Calendar.getInstance().getTimeInMillis();
System.out.println(end-start);
sqlSession.commit();
sqlSession.close();
SqlSession sqlSession2=sessionFactory.openSession(ExecutorType.BATCH);
UserDao userDao2=sqlSession2.getMapper(UserDao.class);
long start1=Calendar.getInstance().getTimeInMillis();
userDao2.addMax(list);
long end1=Calendar.getInstance().getTimeInMillis();
System.out.println(end1-start1);
}
}
以上输出:
356
17
- 我们可以从这个时间的输出,很明显的看出效率的不同,一个356s,一个17s,这个在实际应用中影响很大
- 我们批量处理,主要应用的是:
- SqlSession sqlSession2=sessionFactory.openSession(ExecutorType.BATCH);
- 其中ExecutorType.BATCH就是批处理的操作模式,然而默认是简单模式(Simple)