Example usage for org.hibernate SQLQuery list

Introduction

In this page you can find the example usage for org.hibernate SQLQuery list.

Prototype

List<R> list();

Source Link

Document

Return the query results as a List.

Usage

From source file:com.sistcontable.dao.EstadoDAO.java

public void searchEstadoByID(String id) {
    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    session.beginTransaction();//  w ww  . j  a v a2  s. c  o m
    List<Estado> lista = new ArrayList();
    try {
        String query = "select * from estado where ID_ESTADO=:idEstado";
        SQLQuery sqlQuery = session.createSQLQuery(query);
        sqlQuery.addEntity(Estado.class);
        sqlQuery.setParameter("idEstado", id);
        List result = sqlQuery.list();

        for (int i = 0; i < result.size(); i++) {
            System.out.println("id: ");
            Estado estado = (Estado) result.get(i);
            System.out.println("idEstado: " + estado.getIdEstado());
            System.out.println("nombreEstado: " + estado.getNombreEstado());
            System.out.println("disponibilidad: " + estado.getDisponibilidad());
        }
    } catch (Exception e) {
        System.out.println("ERROR " + e);
        lista = null;
    } finally {
        session.close();
    }
}

---

From source file:com.sistcontable.dao.EstadoDAO.java

public Estado obtenerEstadoByID(String id) {
    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    session.beginTransaction();/*from w ww  .  ja  va  2 s.c  om*/
    List<Estado> lista = new ArrayList();
    try {
        String query = "select * from estado where ID_ESTADO=:idEstado";
        SQLQuery sqlQuery = session.createSQLQuery(query);
        sqlQuery.addEntity(Estado.class);
        sqlQuery.setParameter("idEstado", id);
        List result = sqlQuery.list();

        for (int i = 0; i < result.size(); i++) {
            System.out.println("id: ");
            Estado estado = (Estado) result.get(i);
            System.out.println("idEstado: " + estado.getIdEstado());
            System.out.println("nombreEstado: " + estado.getNombreEstado());
            System.out.println("disponibilidad: " + estado.getDisponibilidad());
        }
        return (Estado) result.get(0);
    } catch (Exception e) {
        System.out.println("ERROR " + e);
        lista = null;
        return null;
    } finally {
        session.close();
    }
}

---

From source file:com.sistcontable.dao.EstadoDAO.java

public List<Estado> searchAllEstados() {
    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    session.beginTransaction();/*from w  w  w .  ja  va  2s.com*/
    List<Estado> lista = new ArrayList();
    try {
        String query = "select * from estado";
        SQLQuery sqlQuery = session.createSQLQuery(query);
        sqlQuery.addEntity(Estado.class);
        lista = sqlQuery.list();

        for (int i = 0; i < lista.size(); i++) {
            System.out.println("-------------------------------------------------");
            System.out.println("idEstado: " + lista.get(i).getIdEstado());
            System.out.println("nombreEstado: " + lista.get(i).getNombreEstado());
            System.out.println("disponibilidad: " + lista.get(i).getDisponibilidad());

        }

    } catch (Exception e) {
        System.out.println("ERROR " + e);
        lista = null;
    } finally {
        session.close();
    }
    return lista;
}

---

From source file:com.sistcontable.dao.PersonaDAO.java

public List<Persona> searchAllPersona(String opcion) {
    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    session.beginTransaction();/*from  w w  w .  ja  v a  2  s  .c o  m*/
    List<Persona> lista = new ArrayList();
    try {
        String query = "select * from persona where es_Historico= :opcion";
        SQLQuery sqlQuery = session.createSQLQuery(query);
        sqlQuery.addEntity(Persona.class).setString("opcion", opcion);

        lista = sqlQuery.list();

    } catch (Exception e) {
        System.out.println("ERROR " + e);
        lista = null;
    } finally {
        session.close();
    }
    return lista;
}

---

From source file:com.sistcontable.dao.PersonaDAO.java

public List<Municipio> searchAllMunicipio() {
    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    session.beginTransaction();//from  w ww  .j a  v  a  2s .com
    List<Municipio> lista = new ArrayList();
    try {
        String query = "select * from municipio";
        SQLQuery sqlQuery = session.createSQLQuery(query);
        sqlQuery.addEntity(Municipio.class);
        lista = sqlQuery.list();
    } catch (Exception e) {
        System.out.println("ERROR " + e);
        lista = null;
    } finally {
        session.close();
    }
    return lista;
}

---

From source file:com.sistcontable.dao.RubroDAO.java

public void searchRubroByID(String id) {
    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    session.beginTransaction();// ww  w.j  a  v a 2s.  c o m
    List<Rubro> lista = new ArrayList();
    try {
        String query = "select * from rubro where ID_RUBRO=:idRubro";
        SQLQuery sqlQuery = session.createSQLQuery(query);
        sqlQuery.addEntity(Rubro.class);
        sqlQuery.setParameter("idRubro", id);
        List result = sqlQuery.list();

        for (int i = 0; i < result.size(); i++) {
            System.out.println("id: ");
            Rubro rubro = (Rubro) result.get(i);

            System.out.println("idRubro: " + rubro.getIdRubro());
            System.out.println("nombreRubro: " + rubro.getNombreRubro());
            System.out.println("tipoRubro: " + rubro.getTipoRubro());

        }
    } catch (Exception e) {
        System.out.println("ERROR " + e);
        lista = null;
    } finally {
        session.close();
    }
}

---

From source file:com.sistcontable.dao.RubroDAO.java

public Rubro obtenerRubroByID(String id) {
    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    session.beginTransaction();/*ww  w .ja  v a2  s  .co  m*/
    List<Rubro> lista = new ArrayList();
    try {
        String query = "select * from rubro where ID_RUBRO=:idRubro";
        SQLQuery sqlQuery = session.createSQLQuery(query);
        sqlQuery.addEntity(Rubro.class);
        sqlQuery.setParameter("idRubro", id);
        List result = sqlQuery.list();

        for (int i = 0; i < result.size(); i++) {
            System.out.println("id: ");
            Rubro rubro = (Rubro) result.get(i);

            System.out.println("idRubro: " + rubro.getIdRubro());
            System.out.println("nombreRubro: " + rubro.getNombreRubro());
            System.out.println("tipoRubro: " + rubro.getTipoRubro());

        }

        return (Rubro) result.get(0);
    } catch (Exception e) {
        System.out.println("ERROR " + e);
        lista = null;
        return null;
    } finally {
        session.close();
    }
}

---

From source file:com.sistcontable.dao.RubroDAO.java

public List<Rubro> searchAllRubros() {
    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    session.beginTransaction();//from   www  .  ja va  2s  .co  m
    List<Rubro> lista = new ArrayList();
    try {
        String query = "select * from rubro";
        SQLQuery sqlQuery = session.createSQLQuery(query);
        sqlQuery.addEntity(Rubro.class);
        lista = sqlQuery.list();

        for (int i = 0; i < lista.size(); i++) {
            System.out.println("-------------------------------------------------");
            System.out.println("idRubro: " + lista.get(i).getIdRubro());
            System.out.println("nombreRubro: " + lista.get(i).getNombreRubro());
            System.out.println("tipoRubro: " + lista.get(i).getTipoRubro());

        }

    } catch (Exception e) {
        System.out.println("ERROR " + e);
        lista = null;
    } finally {
        session.close();
    }
    return lista;
}

---

From source file:com.sistcontable.dao.TelefonoDAO.java

public List<Telefono> searchAllTelefono() {
    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    session.beginTransaction();/*www.j av a 2 s . co m*/
    List<Telefono> lista = new ArrayList();
    try {
        String query = "select * from telefono";
        SQLQuery sqlQuery = session.createSQLQuery(query);
        sqlQuery.addEntity(Telefono.class);

        lista = sqlQuery.list();

    } catch (Exception e) {
        System.out.println("ERROR " + e);
        lista = null;
    } finally {
        session.close();
    }
    return lista;
}

---

From source file:com.sistcontable.dao.TransaccionDAO.java

public List<Cuenta> searchAllCuenta() {
    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    session.beginTransaction();/*from   www  . j  a  v  a 2 s. c o m*/
    List<Cuenta> lista = new ArrayList();
    try {
        String query = "select  *  from cuenta";
        SQLQuery sqlQuery = session.createSQLQuery(query);
        sqlQuery.addEntity(Cuenta.class);
        lista = sqlQuery.list();
    } catch (Exception e) {
        System.out.println("ERROR " + e);
        lista = null;
    } finally {
        session.close();
    }
    return lista;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »