LocalDAOImpl.java

package persistencia;

import java.util.List;

import javax.ejb.Stateless;
import javax.persistence.TypedQuery;

@Stateless
public class LocalDAOImpl extends BaseDAO<Local> implements LocalDAO {

	private static final String getLocalesEmpresaQuery = 
		"SELECT l FROM Empresa e , Local l " +
		"WHERE e.id = :idEmpresa " +
		"	AND l MEMBER OF e.locales";
	
	private static final String todosLocalesQuery = "SELECT l FROM Local l";
	
	
	@Override
	public Local buscarPorId(int id) {
		Local ret = em.find(Local.class, id);
		return ret;
	}

	@Override
	public List<Local> getLocalesPorEmpresa(int idEmpresa) {
		TypedQuery<Local> query = em.createQuery(getLocalesEmpresaQuery, Local.class);
		query.setParameter("idEmpresa", idEmpresa);
		return query.getResultList();
	}

	@Override
	public List<Local> obtenerTodos() {
		TypedQuery<Local> query = em.createQuery(todosLocalesQuery, Local.class);
		return query.getResultList();
	}

}