Red Hat Application Migration Toolkit
package mx.com.bcm.banamex.ae.persistencia.dao.impl; import java.util.List; import javax.ejb.Stateless; import javax.persistence.EntityManager; import javax.persistence.PersistenceContext; import javax.persistence.TypedQuery; import mx.com.bcm.banamex.ae.persistencia.common.GlobalJpaDaoBean; import mx.com.bcm.banamex.ae.persistencia.dao.CatalogoAtmDAOBeanLocal; import mx.com.bcm.banamex.ae.persistencia.modelo.Atm; import mx.com.bcm.banamex.ae.persistencia.vo.CriterioAtmVO; @Stateless public class CatalogoAtmDAOImplBeanLocal extends GlobalJpaDaoBean implements CatalogoAtmDAOBeanLocal { @PersistenceContext private EntityManager em; public List findByIdnAtm(CriterioAtmVO criterioAtmVO) { StringBuilder query = new StringBuilder(); query.append("SELECT a FROM Atm a WHERE a.atmPK.atmIdn = :atmIdn AND a.atmBajaLogica = :atmBajaLogica"); TypedQuery criteria = this.em.createQuery(query.toString(), Atm.class); criteria.setParameter("atmIdn", criterioAtmVO.getAtmIdn()); criteria.setParameter("atmBajaLogica", criterioAtmVO.getBajaLogica()); List listaAtms = criteria.getResultList(); return listaAtms; } public List findByAllAtm() { StringBuilder query = new StringBuilder(); query.append("SELECT a FROM Atm a WHERE a.atmBajaLogica = :atmBajaLogica"); TypedQuery criteria = this.em.createQuery(query.toString(), Atm.class); criteria.setParameter("atmBajaLogica", "01"); List listaAtms = criteria.getResultList(); return listaAtms; } }