diff options
13 files changed, 24 insertions, 11 deletions
diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/AlmacenDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/AlmacenDaoImp.java index 06c3272..52d8486 100644 --- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/AlmacenDaoImp.java +++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/AlmacenDaoImp.java @@ -23,8 +23,9 @@ public class AlmacenDaoImp implements AlmacenDao { public List<Almacen> getAll() { List<Almacen> resultado = null; try{ - String hql = "SELECT * FROM almacen "; + String hql = "FROM Almacen order by id"; resultado = entityManager.createQuery(hql).getResultList(); + // String query = "SELECT * FROM almacen"; // resultado = entityManager.createQuery(query).getResultList(); } diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/AveriaDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/AveriaDaoImp.java index 745a0c2..b3090aa 100644 --- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/AveriaDaoImp.java +++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/AveriaDaoImp.java @@ -23,8 +23,9 @@ public class AveriaDaoImp implements AveriaDao{ public List<Averia> getAll() { List<Averia> resultado = null; try{ - String query = "SELECT * FROM averia"; + String query = "FROM Averia"; resultado = entityManager.createQuery(query).getResultList(); + } catch(Exception ex){ System.out.print(ex.getMessage()); diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/CamionDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/CamionDaoImp.java index 53fe7de..15e3510 100644 --- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/CamionDaoImp.java +++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/CamionDaoImp.java @@ -25,6 +25,7 @@ public class CamionDaoImp implements CamionDao { try{ String query = "FROM Camion order by id "; resultado = entityManager.createQuery(query).getResultList(); + } catch(Exception ex){ System.out.print(ex.getMessage()); diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/ClienteDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/ClienteDaoImp.java index 54b8d92..07831ae 100644 --- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/ClienteDaoImp.java +++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/ClienteDaoImp.java @@ -23,8 +23,9 @@ public class ClienteDaoImp implements ClienteDao { public List<Cliente> getAll() { List<Cliente> resultado = null; try{ - String query = "SELECT * FROM cliente"; + String query = "FROM Cliente"; resultado = entityManager.createQuery(query).getResultList(); + } catch(Exception ex){ System.out.print(ex.getMessage()); diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/PTGDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/PTGDaoImp.java index 37d18df..6614eb4 100644 --- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/PTGDaoImp.java +++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/PTGDaoImp.java @@ -23,8 +23,9 @@ public class PTGDaoImp implements PTGDao{ public List<PTG> getAll() { List<PTG> resultado = null; try{ - String query = "SELECT * FROM ptg"; + String query = "FROM PTG"; resultado = entityManager.createQuery(query).getResultList(); + // System.out.println(resultado); } catch(Exception ex){ System.out.print(ex.getMessage()); diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/PedidoDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/PedidoDaoImp.java index e429775..5fef368 100644 --- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/PedidoDaoImp.java +++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/PedidoDaoImp.java @@ -25,6 +25,7 @@ public class PedidoDaoImp implements PedidoDao { try{ String query = "FROM Pedido order by id "; resultado = entityManager.createQuery(query).getResultList(); + // System.out.println(resultado); } catch(Exception ex){ System.out.print(ex.getMessage()); diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/RegionDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/RegionDaoImp.java index f5ca8ef..d9e0d08 100644 --- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/RegionDaoImp.java +++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/RegionDaoImp.java @@ -23,8 +23,9 @@ public class RegionDaoImp implements RegionDao { public List<Region> getAll() { List<Region> resultado = null; try{ - String query = "SELECT * FROM region"; + String query = "FROM Region"; resultado = entityManager.createQuery(query).getResultList(); + // System.out.println(resultado); } catch(Exception ex){ System.out.print(ex.getMessage()); diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/RutaDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/RutaDaoImp.java index de8ed6c..96b7f3b 100644 --- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/RutaDaoImp.java +++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/RutaDaoImp.java @@ -23,8 +23,9 @@ public class RutaDaoImp implements RutaDao { public List<Ruta> getAll() { List<Ruta> resultado = null; try{ - String query = "SELECT * FROM ruta"; + String query = "FROM Ruta"; resultado = entityManager.createQuery(query).getResultList(); + // System.out.println(resultado); } catch(Exception ex){ System.out.print(ex.getMessage()); diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TipoAveriaDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TipoAveriaDaoImp.java index 0248800..6bab82f 100644 --- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TipoAveriaDaoImp.java +++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TipoAveriaDaoImp.java @@ -23,8 +23,9 @@ public class TipoAveriaDaoImp implements TipoAveriaDao{ public List<TipoAveria> getAll() { List<TipoAveria> resultado = null; try{ - String query = "SELECT * FROM tipoAveria"; + String query = "FROM TipoAveria"; resultado = entityManager.createQuery(query).getResultList(); + // System.out.println(resultado); } catch(Exception ex){ System.out.print(ex.getMessage()); diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TipoCamionDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TipoCamionDaoImp.java index 9758a3b..d352634 100644 --- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TipoCamionDaoImp.java +++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TipoCamionDaoImp.java @@ -23,8 +23,9 @@ public class TipoCamionDaoImp implements TipoCamionDao{ public List<TipoCamion> getAll() { List<TipoCamion> resultado = null; try{ - String query = "SELECT * FROM tipoCamion"; + String query = "FROM TipoCamion"; resultado = entityManager.createQuery(query).getResultList(); + } catch(Exception ex){ System.out.print(ex.getMessage()); diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TramoDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TramoDaoImp.java index abd275d..98aa05b 100644 --- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TramoDaoImp.java +++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TramoDaoImp.java @@ -23,8 +23,9 @@ public class TramoDaoImp implements TramoDao{ public List<Tramo> getAll() { List<Tramo> resultado = null; try{ - String query = "SELECT * FROM tramo"; + String query = "FROM Tramo"; resultado = entityManager.createQuery(query).getResultList(); + //System.out.println(resultado); } catch(Exception ex){ System.out.print(ex.getMessage()); diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TramoRutaDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TramoRutaDaoImp.java index 7f5f7dd..92fe337 100644 --- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TramoRutaDaoImp.java +++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TramoRutaDaoImp.java @@ -23,8 +23,9 @@ public class TramoRutaDaoImp implements TramoRutaDao { public List<TramoRuta> getAll() { List<TramoRuta> resultado = null; try{ - String query = "SELECT * FROM tramoRuta"; + String query = "FROM TramoRuta"; resultado = entityManager.createQuery(query).getResultList(); + // System.out.println(resultado); } catch(Exception ex){ System.out.print(ex.getMessage()); diff --git a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/UsuarioDaoImp.java b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/UsuarioDaoImp.java index 9ed2f86..af2408e 100644 --- a/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/UsuarioDaoImp.java +++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/UsuarioDaoImp.java @@ -23,8 +23,9 @@ public class UsuarioDaoImp implements UsuarioDao{ public List<Usuario> getAll() { List<Usuario> resultado = null; try{ - String query = "SELECT * FROM usuario"; + String query = "FROM Usuario"; resultado = entityManager.createQuery(query).getResultList(); + // System.out.println(resultado); } catch(Exception ex){ System.out.print(ex.getMessage()); |