public void deleteById(Integer consumableId) { log.debug("deleting Consumable instance with id: " + consumableId); try { hibernateTemplate.bulkUpdate( "delete Consumable where consumableId=?", new Object[] {consumableId}); } catch (RuntimeException re) { log.error("get failed", re); throw re; } }
@Override @Transactional(readOnly = false, rollbackFor = Exception.class) public void delete(String levelForUserId) throws UserExistInLevelException { // 如果有用户处于当前等级,则不能删除 String hql = "select count(user) from User user where user.level.id = ?"; long n = (Long) ht.find(hql, levelForUserId).get(0); if (n > 0) { throw new UserExistInLevelException(); } ht.bulkUpdate("delete from LevelForUser lfu where lfu.id = ?", levelForUserId); }
// 出入库更新 public void updateQuantity(Integer quantity, Integer consumableId) throws Exception { // TODO Auto-generated method stub try { hibernateTemplate.bulkUpdate( "update Consumable set quantity=? where consumableId=?", new Object[] {quantity, consumableId}); hibernateTemplate.flush(); } catch (RuntimeException re) { // TODO: handle exception throw re; } finally { hibernateTemplate.clear(); } }
/** 更新对象 */ public int bulkUpdate(String queryString) { return hibernateTemplate.bulkUpdate(queryString); }