Information

0
Story Points

Technologies

Decompiled Java File
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;
   }
}
Page generated: Oct 19, 2017 2:34:27 PM