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.Query; import mx.com.bcm.banamex.ae.persistencia.common.GlobalJpaDaoBean; import mx.com.bcm.banamex.ae.persistencia.dao.TotalesRecepcionEfectivoDTOBeanLocal; import mx.com.bcm.banamex.ae.persistencia.dto.TotalesRecepcionEfectivoDTO; import mx.com.bcm.banamex.ae.persistencia.exception.EfectivoAplicacionDAOException; @Stateless public class TotalesRecepcionEfectivoDTODAOImplBeanLocal extends GlobalJpaDaoBean implements TotalesRecepcionEfectivoDTOBeanLocal { @PersistenceContext private EntityManager em; public TotalesRecepcionEfectivoDTO consultaTotales() throws EfectivoAplicacionDAOException { TotalesRecepcionEfectivoDTO obj = new TotalesRecepcionEfectivoDTO(); StringBuilder queryString = new StringBuilder(); queryString.append(" SELECT COUNT(COMPBTE_ID) FROM COMPROBANTES WHERE "); Query query = this.em.createNativeQuery(queryString.toString()); List listaObject = query.getResultList(); Object[] current = (Object[])listaObject.get(0); queryString.delete(-1, queryString.length()); obj.setNumerocomprobantes(((Integer)current[0]).intValue()); return obj; } }