hibernate 批量删除

/**
	 * delete roleMenu by roleId
	 */
	public int deleteRoleMenu(final long roleId) throws DAOException{
		int deleteState = 1;
		List<RoleMenu> li= this.getMyHibernateTemplate().executeFind(new HibernateCallback()
		{
			public Object doInHibernate(Session session) throws HibernateException, SQLException {
				String hql="from RoleMenu r where r.roleId=:roleId";
				Query query = session.createQuery(hql);
				query.setLong("roleId", roleId);
				return query.list();
			}
		});
        if(li!=null)
        {
        	for(RoleMenu r: li)
        	{
        		this.delete(r);
        	}
        }
		return deleteState;
	}

	如果不是删除一个集合 只删除一个对象 
	this.delete(c, id) -- id 是 主键

==================================刚写的一个DEMO================================

DAO 实现层
----------------------------------
@SuppressWarnings("unchecked")
	public void doDeleteMavin(final String mavinIdArray) throws DAOException
	{
		//mavinIdArray （1,2,3,4,5）类似参数
		List<TbExpert> mavinList = this.getMyHibernateTemplate().executeFind(new HibernateCallback()
		{
			public Object doInHibernate(Session session)
					throws HibernateException, SQLException {
				String hql = "from TbExpert t where t.expertId in ("+mavinIdArray+")";
				System.out.println("HQL = "+hql);
				Query q = session.createQuery(hql);
				return q.list();
			}
		});
		System.out.println("逻辑删除数目： "+mavinList.size());
		if(mavinList.size()>0)
		{
			for(TbExpert mavin:mavinList)
			{
				mavin.setDeleteState("0");
				this.update(mavin);
			}
		}	}

评论

1 楼 snowday88 2011-07-09  

这个是批量删除？怎么感觉还是一个一个删除啊？