From c4afbde59b708505803094724632774ffb35ee74 Mon Sep 17 00:00:00 2001
From: Dayana31 <70593166+Dayana31@users.noreply.github.com>
Date: Fri, 3 Jun 2022 17:19:36 -0500
Subject: =?UTF-8?q?Correcci=C3=B3n=20de=20query?=
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 .../src/main/java/pe/edu/pucp/odiparback/dao/imp/AlmacenDaoImp.java    | 3 ++-
 .../src/main/java/pe/edu/pucp/odiparback/dao/imp/AveriaDaoImp.java     | 3 ++-
 .../src/main/java/pe/edu/pucp/odiparback/dao/imp/CamionDaoImp.java     | 1 +
 .../src/main/java/pe/edu/pucp/odiparback/dao/imp/ClienteDaoImp.java    | 3 ++-
 .../src/main/java/pe/edu/pucp/odiparback/dao/imp/PTGDaoImp.java        | 3 ++-
 .../src/main/java/pe/edu/pucp/odiparback/dao/imp/PedidoDaoImp.java     | 1 +
 .../src/main/java/pe/edu/pucp/odiparback/dao/imp/RegionDaoImp.java     | 3 ++-
 .../src/main/java/pe/edu/pucp/odiparback/dao/imp/RutaDaoImp.java       | 3 ++-
 .../src/main/java/pe/edu/pucp/odiparback/dao/imp/TipoAveriaDaoImp.java | 3 ++-
 .../src/main/java/pe/edu/pucp/odiparback/dao/imp/TipoCamionDaoImp.java | 3 ++-
 .../src/main/java/pe/edu/pucp/odiparback/dao/imp/TramoDaoImp.java      | 3 ++-
 .../src/main/java/pe/edu/pucp/odiparback/dao/imp/TramoRutaDaoImp.java  | 3 ++-
 .../src/main/java/pe/edu/pucp/odiparback/dao/imp/UsuarioDaoImp.java    | 3 ++-
 13 files changed, 24 insertions(+), 11 deletions(-)

(limited to 'back')

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()); 
-- 
cgit v1.2.3