roleinfodao.java

本平台是以web2.0为基本的标准

package com.afuer.hib.dao.orgModel.Dao;

import java.io.Serializable;
import java.util.List;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.dao.DataAccessException;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.afuer.hib.dao.orgModel.Idao.IRoleInfoDao;
import com.afuer.hib.form.RoleInfo;

public class RoleInfoDao extends HibernateDaoSupport implements IRoleInfoDao {
	private static final Log log = LogFactory.getLog(RoleInfoDao.class);

	public Serializable saveRoleInfo(RoleInfo RoleInfo)
			throws DataAccessException {
		// TODO Auto-generated method stub
		return getHibernateTemplate().save(RoleInfo);
	}

	public List find(Integer id) throws DataAccessException {
		// TODO Auto-generated method stub
		return (List) this.getHibernateTemplate().execute(
				new HibernateCallback() {
					public Object doInHibernate(Session session) {
						Query query = session
								.createQuery("from RoleInfo order by id");
						return query.list();
					}
				});
	}

	public RoleInfo getRoleInfo(final Integer id) throws DataAccessException {
		// TODO Auto-generated method stub
		return (RoleInfo) this.getHibernateTemplate().execute(
				new HibernateCallback() {
					public Object doInHibernate(Session session) {
						Query query = session
								.createQuery("from RoleInfo where id='" + id
										+ "'");
						return (RoleInfo) query.uniqueResult();
					}
				});
	}

	public List getAllRoles() throws DataAccessException {
		// TODO Auto-generated method stub
		return (List) this.getHibernateTemplate().execute(
				new HibernateCallback() {
					public Object doInHibernate(Session session) {
						Query query = session
								.createQuery("from RoleInfo order by id ");
						return query.list();
					}
				});
	}

	public void updateRoleInfo(RoleInfo roleinfo) throws DataAccessException {
		// TODO Auto-generated method stub
		this.getHibernateTemplate().update(roleinfo);

	}

	public void DeleteRoleInfo(final Integer id) throws DataAccessException {
		// TODO Auto-generated method stub
		log.warn("Role delete.............................");
		this.getHibernateTemplate().execute(new HibernateCallback() {
			public Object doInHibernate(Session session) {
				Query query = session
						.createQuery("delete RoleInfo where id =:Rid");
				query.setInteger("Rid", id.intValue());
				query.executeUpdate();
				
				query = session.createQuery("delete from Roleorg where roleid="
						+ id);
				query.executeUpdate();
				
				query = session
						.createQuery("delete from Userrole where roleid=" + id);
				query.executeUpdate();
				
				query = session.createQuery("delete from UserAcl where roleid="
						+ id);
				query.executeUpdate();

				return null;
			}
		});

	}
}