public List<Sucursales> sucursalesporLocalidad(String loco) {
    Session session = null;
    List<Sucursales> suc = null;

    try {
      session = HibernateUtil.getSessionFactory().openSession();
      Query query = session.createQuery("from Sucursales where localidades.idLocalidad=" + loco);
      suc = (List<Sucursales>) query.list();
    } catch (HibernateException e) {
      System.out.println(e.getMessage());
    } finally {
      if (session != null) {
        session.close();
      }
    }
    return suc;
  }
  public Sucursales buscarSucursal(String id) {
    Session session = null;
    Sucursales suc = null;

    try {
      session = HibernateUtil.getSessionFactory().openSession();
      Query query = session.createQuery("from Sucursales where idSucursal=" + id);
      suc = (Sucursales) query.uniqueResult();
    } catch (HibernateException e) {
      System.out.println(e.getMessage());
    } finally {
      if (session != null) {
        session.close();
      }
    }
    return suc;
  }
Ejemplo n.º 3
0
 @Override
 public List<Color> filtarTipoDos() {
   Session session = null;
   List<Color> lista = null;
   try {
     session = HibernateUtil.getSessionFactory().openSession();
     Query query = session.createQuery("FROM Color");
     lista = (List<Color>) query.list();
   } catch (HibernateException e) {
     System.out.println(e.getMessage());
   } finally {
     if (session != null) {
       session.close();
     }
   }
   return lista;
 }
  @Override
  public List<Sucursales> mostraSucursales() {
    Session session = null;
    List<Sucursales> suc = null;

    try {
      session = HibernateUtil.getSessionFactory().openSession();
      Query query = session.createQuery("from Surcursales");
      suc = (List<Sucursales>) query.list();
    } catch (HibernateException e) {
      System.out.println(e.getMessage());
    } finally {
      if (session != null) {
        session.close();
      }
    }
    return suc;
  }
 @Override
 public void modificarTarjetaNaranja(TarjetaNaranja tarjetaNaranja) throws Exception {
   Session session = null;
   try {
     session = HibernateUtil.getSessionFactory().openSession();
     session.beginTransaction();
     session.update(tarjetaNaranja);
     session.getTransaction().commit();
   } catch (ConstraintViolationException e) {
     session.getTransaction().rollback();
     throw new Exception(e.getSQLException());
   } catch (HibernateException e) {
     session.getTransaction().rollback();
     throw new Exception(e);
   } finally {
     if (session != null) {
       session.close();
     }
   }
 }
 @Override
 public Long insertarFacturaA(GenFacturaA genFacturaA) throws Exception {
   Session session = null;
   Long id = null;
   try {
     session = HibernateUtil.getSessionFactory().openSession();
     session.beginTransaction();
     id = (Long) session.save(genFacturaA);
     session.getTransaction().commit();
   } catch (ConstraintViolationException e) {
     session.getTransaction().rollback();
     throw new Exception(e.getSQLException());
   } catch (HibernateException e) {
     session.getTransaction().rollback();
     throw new Exception(e);
   } finally {
     if (session != null) {
       session.close();
     }
   }
   return id;
 }