userinfodao.java

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

package sunyang.user.dao;

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

import sunyang.persistence.EntityManagerHelper;
import sunyang.user.domain.Userinfo;

public class UserinfoDAO implements IUserinfoDAO {
	// 声明静态常量
	public static final String USERNAME = "username";
	public static final String PASSWORD = "password";

	// 得到实体管理器
	private EntityManager getEntityManager() {
		return EntityManagerHelper.getEntityManager();
	}

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

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

	// 修改数据
	public Userinfo update(Userinfo entity) {
		try {
			EntityManagerHelper.beginTransaction();
			Userinfo result = getEntityManager().merge(entity);
			EntityManagerHelper.commit();
			return result;
		} catch (RuntimeException re) {
			EntityManagerHelper.rollback();
			throw re;
		}
	}

	// 通过id查询数据
	public Userinfo findById(Integer id) {
		try {
			Userinfo instance = getEntityManager().find(Userinfo.class, id);
			return instance;
		} catch (RuntimeException re) {
			throw re;
		}
	}

	// 通过表中一个字段查询数据
	@SuppressWarnings("unchecked")
	public List<Userinfo> findByProperty(String propertyName, final Object value) {
		try {
			final String queryString = "select model from Userinfo 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;
		}
	}

	// 通过表中username字段查询数据
	public List<Userinfo> findByUsername(Object username) {
		return findByProperty(USERNAME, username);
	}

	// 查询所有数据
	@SuppressWarnings("unchecked")
	public List<Userinfo> findAll() {
		try {
			final String queryString = "select model from Userinfo model";
			Query query = getEntityManager().createQuery(queryString).setHint(
					"toplink.refresh", true);
			return query.getResultList();
		} catch (RuntimeException re) {
			throw re;
		}
	}
}