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;
}
}