String hqlDelete = "delete users u where u.name = :name and u.user.id = :id"
int deletedEntities = s.createQuery( hqlDelete )
.setString( "name", name )
.setString( "id", id )
.executeUpdate();
Hibernate3.0对批量更新和批量删除提供了支持,能够直接执行批量更新或批量删除语句,无需把被更新或删除的对象先加载到内存中。以下是通过Hibernate3.0执行批量更新的程序代码:
代码
- 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();
以下是通过Hibernate3.0执行批量删除的程序代码:
代码
- 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();
Hibernate3.0取消了以往的session.delete(sql)的批量删除方法(原版被取消的方法可以在org.hibernate.classic包内找到原版的Session类)
那么,hibernate3.0实现批量方式的方法为:
public void cleanCMHistory(Date date) {
Session session = getSession();
Transaction tx = session.beginTransaction();
try {
String hqlDelete = "delete CMInfo where timeStamp < :cleanTime";
int deletedEntities = session.createQuery(hqlDelete).setTimestamp(
"cleanTime", date).executeUpdate();
//先查询出符合条件的结果集,再将其置空
//此事例删除where子句判定列为timestamp类型,故使用setTimestamp,其他
//类型应调用相应的set方法
tx.commit();
}
catch (Exception ex) {
log.info(ex);
tx.rollback();
}
session.close();
}
-------------------------------------------------------------
我使用的是hibernate3.1,使用上面的方法批量删除却不行
好像是不支持"delete Customer where name = :ldName"这种hql语句
而用下面这种酒可以的:
session.createQuery("delete ChargeRules c where c.functionName=?")
.setParameter(0, "开户业务").executeUpdate();
.setParameter(0, "开户业务").executeUpdate();