hibernate批处理

最新推荐文章于 2024-08-25 21:18:14 发布

jiuxiao199132

最新推荐文章于 2024-08-25 21:18:14 发布

阅读量258

点赞数

分类专栏： hibernate 文章标签：批处理 hibernate

本文链接：https://blog.csdn.net/jiuxiao199132/article/details/70156573

版权

hibernate 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

hibernate3 中

Connection connetion = session.connection();

connection.setAutoCommit(false);
PreparedStatement ps = connection.prepareStatement("sql");
long start = System.currentTimeMillis();
for(Object bean : list){
       ps.setString(1, MD5.encryptionMD5(UUID.randomUUID().toString()));
       ps.setString(2, bean.getCarCode());
       ps.setString(3, bean.getCardCode());
       ps.setString(4, bean.getInAddress());
       ps.setString(5, bean.getOutAddress());
       ps.setTimestamp(6, new Timestamp(bean.getInDate().getTime()));
       ps.setTimestamp(7, new Timestamp(bean.getOutDate().getTime()));
       ps.addBatch();
 }
ps.executeBatch();
connection.commit();
long end = System.currentTimeMillis();
System.out.println("总共 " + list.size() + " 条数据，总耗时 : " + ((end-start)/1000) + " 秒");