UserRoleDAO.java 文件源码

/**
 * retrieves the list of <code>UserRole</code>-objects by its email.
 * 
 * @param email
 *            the email
 * @return userRoles the roles
 * 
 */
public static List<UserRole> getUserRolesByEmail(String username) {
    EntityManagerFactory emf = Persistence.createEntityManagerFactory("userData");
    EntityManager em = emf.createEntityManager();
    CriteriaBuilder cb = em.getCriteriaBuilder();

    CriteriaQuery<UserRole> q = cb.createQuery(UserRole.class);
    Root<UserRole> c = q.from(UserRole.class);
    q.select(c).where(cb.equal(c.get("username"), username));
    TypedQuery<UserRole> query = em.createQuery(q);
    List<UserRole> roles = query.getResultList();
    em.close();
    return roles;
}