Red Hat Application Migration Toolkit
package mx.com.bcm.banamex.ae.persistencia.dao.impl; import java.util.ArrayList; 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.EtvIdnNombreDTODAOBeanLocal; import mx.com.bcm.banamex.ae.persistencia.dto.EtvIdnNombreDTO; @Stateless public class EtvIdnNombreDTODAOImplBeanLocal extends GlobalJpaDaoBean implements EtvIdnNombreDTODAOBeanLocal { @PersistenceContext private EntityManager em; public List consultaEtvIdnNombre() { StringBuilder queryString = new StringBuilder(); queryString.append("SELECT DISTINCT e.ETV_IDN AS ETV_IDN,e.ETV_NOMBRE_LARGO AS ETV_NOMBRE_LARGO FROM ETVS e "); Query query = this.em.createNativeQuery(queryString.toString()); ArrayList listEtvsDTO = new ArrayList(); List listaObject = query.getResultList(); for(int index = 0; index < listaObject.size(); ++index) { Object[] current = (Object[])listaObject.get(index); EtvIdnNombreDTO obj = new EtvIdnNombreDTO(); obj.setEtvIdn(Short.valueOf(Short.parseShort(current[0].toString()))); obj.setEtvNombreLargo(current[1].toString()); listEtvsDTO.add(obj); } return listEtvsDTO; } }