Hibernate 5

iteye_11486

于 2010-06-14 17:00:00 发布

阅读量64

点赞数

文章标签： java

本文介绍了使用Hibernate Query Language (HQL)进行批量插入和批量更新操作的方法。具体包括通过SessionFactory创建Session并开启事务，利用循环进行批量插入，以及滚动查询结合批量更新的方式提高内存管理和更新效率。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

HQL Batch Update, Insert

1.Batch Insert

Session session = sessionFactory.openSession(); Transaction tx = session.beginTransaction(); for ( int i=0; i<100000; i++ ) { Customer customer = new Customer(.....); session.save(customer); } tx.commit(); session.close();

2.Batch Update

Session session = sessionFactory.openSession(); Transaction tx = session.beginTransaction(); ScrollableResults customers = session.getNamedQuery("GetCustomers") .setCacheMode(CacheMode.IGNORE) .scroll(ScrollMode.FORWARD_ONLY); int count=0; while ( customers.next() ) { Customer customer = (Customer) customers.get(0); customer.updateStuff(...); if ( ++count % 20 == 0 ) { //flush a batch of updates and release memory: session.flush(); session.clear(); } } tx.commit(); session.close();