userroledao.java

struts2 spring2.5 jpa hibernate 权限管理系统源代码

package sunyang.relationship.dao;

import java.util.List;
import javax.persistence.*;

import sunyang.persistence.EntityManagerHelper;
import sunyang.relationship.domain.UserRole;

public class UserRoleDAO implements IUserRoleDAO {
	// 得到实体管理器
	private EntityManager getEntityManager() {
		return EntityManagerHelper.getEntityManager();
	}

	// 新增数据
	public void save(UserRole entity) {
		try {
			EntityManagerHelper.beginTransaction();
			getEntityManager().persist(entity);
			EntityManagerHelper.commit();
		} catch (RuntimeException re) {
			EntityManagerHelper.rollback();
			throw re;
		}
	}

	// 删除数据
	public void delete(UserRole entity) {
		try {
			EntityManagerHelper.beginTransaction();
			entity = getEntityManager().getReference(UserRole.class,
					entity.getId());
			getEntityManager().remove(entity);
			EntityManagerHelper.commit();
		} catch (RuntimeException re) {
			EntityManagerHelper.rollback();
			throw re;
		}
	}

	// 通过表中一个字段进行查询
	@SuppressWarnings("unchecked")
	public List<UserRole> findByProperty(String propertyName, final Object value) {
		try {
			final String queryString = "select model from UserRole model where model."
					+ propertyName + "= :propertyValue";
			Query query = getEntityManager().createQuery(queryString).setHint(
					"toplink.refresh", true);
			query.setParameter("propertyValue", value);
			return query.getResultList();
		} catch (RuntimeException re) {
			throw re;
		}
	}

	// 通过两个字段进行查找
	@SuppressWarnings("unchecked")
	public List<UserRole> findBy2Properties(String propertyName1,
			final Object value1, String propertyName2, final Object value2) {
		try {
			final String queryString = "select model from UserRole model where model."
					+ propertyName1
					+ "= :propertyValue1 and model."
					+ propertyName2 + "= :propertyValue2";
			Query query = getEntityManager().createQuery(queryString).setHint(
					"toplink.refresh", true);
			query.setParameter("propertyValue1", value1).setParameter(
					"propertyValue2", value2);
			return query.getResultList();
		} catch (RuntimeException re) {
			throw re;
		}
	}

	// 通过用户id查找角色id
	@SuppressWarnings("unchecked")
	public List<Integer> findRoleIdByUid(Integer uid) {
		String queryString = "select distinct ur.role.id from UserRole ur where ur.userinfo.id=:uid";
		return getEntityManager().createQuery(queryString).setHint(
				"toplink.refresh", true).setParameter("uid", uid)
				.getResultList();
	}
}