weiweichen1985

永久域名 http://weiweichen1985.javaeye.com

2007-10-26

批量删除

关键字: 批量删除

/**
	 * <p>
	 * 批量删除用户
	 * </p>
	 * 
	 * @param hql,如: delete Employee e where e.uid in (1,2,3) 
	 * @return 删除的数量
	 */
	public int delEmps(String hql) {
		Session ses = null;
		Transaction tran = null;
		int count = 0;
		try {
			ses = SessionFactory.getSession();
			tran = ses.beginTransaction();
			Query query = ses.createQuery(hql);
			count = query.executeUpdate();
			tran.commit();
		} catch (SessionFactoryException e) {

			e.printStackTrace();
			try {
				SessionFactory.rollBackTransaction(tran);
			} catch (SessionFactoryException e1) {
				e1.printStackTrace();

			}
		} finally {
			try {
				SessionFactory.closeSession(ses);
			} catch (SessionFactoryException e) {
				e.printStackTrace();

			}
		}
		return count;
	}

10:46
浏览 (166)
评论 (1)
分类: hibernate
相关推荐

boolean flag = false;
		Session session = null;
		Transaction tran = null;
		try {
			session = this.getSession();
			tran = session.beginTransaction();
			for (int i = 0; i < arr.length; i++) {
				MMessageList mm = (MMessageList) session.get(
						MMessageList.class, new Integer(arr[i]));
				session.delete(mm);
			}
			tran.commit();
			flag = true;
		} catch (Exception e) {
			e.printStackTrace();
			if (tran != null)
				tran.rollback();
			return flag;
		}
		return flag;