有时候我们要实现一个批量删除记录的动作.
我想了很久,用下面的代码实现.如果那位有更好的方法请告诉我.:0)
我想了很久,用下面的代码实现.如果那位有更好的方法请告诉我.:0)
public
int
deleteBrands(Long[] delBrandId){
Session session = getSession();
Transaction tx = session.beginTransaction();
StringBuffer sql = new StringBuffer();
sql.append( " delete Brand where brandId in ( :brandId) " );
Query query = session.createQuery(sql.toString());
query.setParameterList( " brandId " ,delBrandId);
int dels = query.executeUpdate();
tx.commit();
return dels;
}
Session session = getSession();
Transaction tx = session.beginTransaction();
StringBuffer sql = new StringBuffer();
sql.append( " delete Brand where brandId in ( :brandId) " );
Query query = session.createQuery(sql.toString());
query.setParameterList( " brandId " ,delBrandId);
int dels = query.executeUpdate();
tx.commit();
return dels;
}