hibernate3.0以上处理批量删除批量修改

最新推荐文章于 2018-12-19 19:50:18 发布

Mike.Lee

最新推荐文章于 2018-12-19 19:50:18 发布

阅读量627

点赞数

文章标签： hibernate session delete string jdbc api

本文介绍如何使用Hibernate和JDBC API批量修改及删除数据库中的客户记录，包括更新客户名称和删除指定名称的客户。

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

批量修改：
Session session = sessionFactory.openSession();
Transaction tx = session.beginTransaction();
String hqlUpdate = "update Customer set name = :newName where name=ldName";
int updatedEntities = s.createQuery( hqlUpdate )
.setString( "newName", newName )
.setString( "oldName", oldName )
.executeUpdate();
tx.commit();
session.close();
批量删除:
Session session = sessionFactory.openSession();
Transaction tx = session.beginTransaction();
String hqlDelete = "delete Customer where name =ldName";
int deletedEntities = s.createQuery( hqlDelete )
.setString( "oldName", oldName )
.executeUpdate();
tx.commit();
session.close();

也可以使用JDBC API来操作：
Session session = sessionFactory.openSession();
Transaction tx = session.beginTransaction();
Connection con=session.connection();
PreparedStatement stmt=con.prepareStatement("update Customer set name = :newName where name=ldName");
stmt.executeUpdate();
tx.commit();
session.close();

Session session = sessionFactory.openSession();
Transaction tx = session.beginTransaction();
Connection con=session.connection();
PreparedStatement stmt=con.prepareStatement("delete Customer where name =ldName");
stmt.executeUpdate();
tx.commit();
session.close();