Example usage for org.apache.ibatis.session SqlSession selectList

Introduction

In this page you can find the example usage for org.apache.ibatis.session SqlSession selectList.

Prototype

<E> List<E> selectList(String statement, Object parameter);

Source Link

Document

Retrieve a list of mapped objects from the statement key and parameter.

Usage

From source file:gp.daoImpl.ListasGeneralesDaoImpl.java

@Override
public List<String> getDependencias(String codigo) {
    SqlSession session = sqlSessionFactory.openSession();
    List<String> list = null;
    try {//  www. j a  v a  2 s .  c o m
        list = session.selectList("ListasGenerales.getDependencias", codigo);
    } catch (Exception e) {
        System.out.println(e.getMessage());
        e.printStackTrace();
        System.out.println("ERROR EN EL IMPL");
    } finally {
        session.close();
    }
    return list;
}

From source file:gp.daoImpl.MontosDaoImpl.java

@Override
public List<Montos> getMontosModificados(String codigo) {
    List<Montos> list = null;
    SqlSession session = sqlSessionFactory.openSession();
    try {//from w w w  .  j a v a2  s  .  co  m
        list = session.selectList("MontosData.get_MontModif", codigo);
    } catch (Exception e) {
        System.out.println(e.getMessage());
        System.out.println("ERROR EN EL IMPL");
    } finally {
        session.close();
    }
    return list;
}

From source file:gp.daoImpl.MontosDaoImpl.java

@Override
public List<Montos> getMontoExpTecn(String codigo) {
    List<Montos> list = null;
    SqlSession session = sqlSessionFactory.openSession();
    try {//from w  ww  . jav  a2  s  .  c o m
        list = session.selectList("MontosData.get_Monto1", codigo);
    } catch (Exception e) {
        System.out.println(e.getMessage());
        System.out.println("ERROR EN EL IMPL");
    } finally {
        session.close();
    }
    return list;
}

From source file:gp.daoImpl.MontosDaoImpl.java

@Override
public List<Montos> getMontoInfraestructura(String codigo) {
    List<Montos> list = null;
    SqlSession session = sqlSessionFactory.openSession();
    try {/*from w ww.  j ava 2s. co  m*/
        list = session.selectList("MontosData.get_Monto2", codigo);
    } catch (Exception e) {
        System.out.println(e.getMessage());
        System.out.println("ERROR EN EL IMPL");
    } finally {
        session.close();
    }
    return list;
}

From source file:gp.daoImpl.MontosDaoImpl.java

@Override
public List<Montos> getMontoEquipMobili(String codigo) {
    List<Montos> list = null;
    SqlSession session = sqlSessionFactory.openSession();
    try {// w  w  w.  j a  v a 2 s.  c  o  m
        list = session.selectList("MontosData.get_Monto3", codigo);
    } catch (Exception e) {
        System.out.println(e.getMessage());
        System.out.println("ERROR EN EL IMPL");
    } finally {
        session.close();
    }
    return list;
}

From source file:gp.daoImpl.MontosDaoImpl.java

@Override
public List<Montos> getMontoSupervision(String codigo) {
    List<Montos> list = null;
    SqlSession session = sqlSessionFactory.openSession();
    try {//from   w ww .  ja  v  a2s.  co m
        list = session.selectList("MontosData.get_Monto4", codigo);
    } catch (Exception e) {
        System.out.println(e.getMessage());
        System.out.println("ERROR EN EL IMPL");
    } finally {
        session.close();
    }
    return list;
}

From source file:gp.daoImpl.MontosDaoImpl.java

@Override
public List<Montos> getMontoCapacitacion(String codigo) {
    List<Montos> list = null;
    SqlSession session = sqlSessionFactory.openSession();
    try {//from  w  w w  .  j a v a2  s . c o  m
        list = session.selectList("MontosData.get_Monto5", codigo);
    } catch (Exception e) {
        System.out.println(e.getMessage());
        System.out.println("ERROR EN EL IMPL");
    } finally {
        session.close();
    }
    return list;
}

From source file:gp.daoImpl.MontosDaoImpl.java

@Override
public List<Montos> getMontoOtros(String codigo) {
    List<Montos> list = null;
    SqlSession session = sqlSessionFactory.openSession();
    try {/*from ww  w .j  ava  2  s  . co m*/
        list = session.selectList("MontosData.get_Monto6", codigo);
    } catch (Exception e) {
        System.out.println(e.getMessage());
        System.out.println("ERROR EN EL IMPL");
    } finally {
        session.close();
    }
    return list;
}

From source file:gp.daoImpl.RegistroInversionDaoImpl.java

@Override
public List<EjecucionMostrado> getMontosEjecutados(String codigo, String mes, String anio, String etapa) {
    List<EjecucionMostrado> list = null;
    System.out.println("Codigo - ID " + codigo + " " + etapa + " " + mes + " " + anio);
    Map<String, String> map = new HashMap<String, String>();
    map.put("codigo", codigo);
    map.put("mes", mes);
    map.put("anio", anio);
    map.put("etapa", etapa);
    SqlSession session = sqlSessionFactory.openSession();
    try {//  w w w . ja  va 2  s.co  m
        list = session.selectList("RegistroInversion.getMontosEjecutados", map);
    } catch (Exception e) {
        System.out.println(e.getMessage());
        System.out.println("ERROR EN EL getMontosEjecutados");
    } finally {
        session.close();
    }
    return list;
}

From source file:gp.daoImpl.RegistroInversionDaoImpl.java

@Override
public List<String> getListaEtapas(String idproy) {
    List<String> list = null;
    System.out.println(idproy);/*from  w w  w .  j a va  2 s  . c o m*/
    SqlSession session = sqlSessionFactory.openSession();
    try {
        list = session.selectList("RegistroInversion.getListaEtapas", idproy);
    } catch (Exception e) {
        System.out.println(e.getMessage());
        System.out.println("ERROR EN EL IMPL");
    } finally {
        session.close();
    }
    return list;
}