diff options
13 files changed, 1114 insertions, 0 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 new file mode 100644 index 0000000..575d38a --- /dev/null +++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/AlmacenDaoImp.java @@ -0,0 +1,87 @@ +package pe.edu.pucp.odiparback.dao.imp; +import java.util.List; + +import javax.persistence.EntityManager; +import javax.persistence.PersistenceContext; + +import pe.edu.pucp.odiparback.models.Almacen; +import pe.edu.pucp.odiparback.dao.AlmacenDao; + +import org.springframework.stereotype.Repository; +import org.springframework.transaction.annotation.Transactional; + + +@Transactional +@Repository +@SuppressWarnings("unchecked") +public class AlmacenDaoImp implements AlmacenDao { + @PersistenceContext + EntityManager entityManager; + + @Transactional + @Override + public List<Almacen> getAll() { + List<Almacen> resultado = null; + try{ + String query = "SELECT * FROM ODP_Almacen"; + resultado = entityManager.createQuery(query).getResultList(); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + + return resultado; + } + + @Transactional + @Override + public Almacen get(int id) { + Almacen resultado = null; + try { + resultado = entityManager.find(Almacen.class, id); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + + return resultado; + } + + @Transactional + @Override + public void register(Almacen almacen) { + try { + entityManager.merge(almacen); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + + } + + @Transactional + @Override + public Almacen update(Almacen almacen) { + try { + entityManager.merge(almacen); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + return almacen; + } + + @Transactional + @Override + public void delete(int id) { + Almacen resultado = get(id); + try { + entityManager.remove(resultado); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + + } + +} 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 new file mode 100644 index 0000000..1bf1882 --- /dev/null +++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/AveriaDaoImp.java @@ -0,0 +1,87 @@ +package pe.edu.pucp.odiparback.dao.imp; +import java.util.List; + +import javax.persistence.EntityManager; +import javax.persistence.PersistenceContext; + +import pe.edu.pucp.odiparback.models.Averia; +import pe.edu.pucp.odiparback.dao.AveriaDao; + +import org.springframework.stereotype.Repository; +import org.springframework.transaction.annotation.Transactional; + + +@Transactional +@Repository +@SuppressWarnings("unchecked") +public class AveriaDaoImp implements AveriaDao{ + @PersistenceContext + EntityManager entityManager; + + @Transactional + @Override + public List<Averia> getAll() { + List<Averia> resultado = null; + try{ + String query = "SELECT * FROM ODP_Averia"; + resultado = entityManager.createQuery(query).getResultList(); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + + return resultado; + } + + @Transactional + @Override + public Averia get(int id) { + Averia resultado = null; + try { + resultado = entityManager.find(Averia.class, id); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + + return resultado; + } + + @Transactional + @Override + public void register(Averia averia) { + try { + entityManager.merge(averia); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + + } + + @Transactional + @Override + public Averia update(Averia averia) { + try { + entityManager.merge(averia); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + return averia; + } + + @Transactional + @Override + public void delete(int id) { + Averia resultado = get(id); + try { + entityManager.remove(resultado); + } + 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 new file mode 100644 index 0000000..4c97808 --- /dev/null +++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/CamionDaoImp.java @@ -0,0 +1,87 @@ +package pe.edu.pucp.odiparback.dao.imp; +import java.util.List; + +import javax.persistence.EntityManager; +import javax.persistence.PersistenceContext; + +import pe.edu.pucp.odiparback.models.Camion; +import pe.edu.pucp.odiparback.dao.CamionDao; + +import org.springframework.stereotype.Repository; +import org.springframework.transaction.annotation.Transactional; + + +@Transactional +@Repository +@SuppressWarnings("unchecked") +public class CamionDaoImp implements CamionDao { + @PersistenceContext + EntityManager entityManager; + + @Transactional + @Override + public List<Camion> getAll() { + List<Camion> resultado = null; + try{ + String query = "SELECT * FROM ODP_Camion"; + resultado = entityManager.createQuery(query).getResultList(); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + + return resultado; + } + + @Transactional + @Override + public Camion get(int id) { + Camion resultado = null; + try { + resultado = entityManager.find(Camion.class, id); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + + return resultado; + } + + @Transactional + @Override + public void register(Camion camion) { + try { + entityManager.merge(camion); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + + } + + @Transactional + @Override + public Camion update(Camion camion) { + try { + entityManager.merge(camion); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + return camion; + } + + @Transactional + @Override + public void delete(int id) { + Camion resultado = get(id); + try { + entityManager.remove(resultado); + } + 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 new file mode 100644 index 0000000..2a9ae44 --- /dev/null +++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/ClienteDaoImp.java @@ -0,0 +1,86 @@ +package pe.edu.pucp.odiparback.dao.imp; +import java.util.List; + +import javax.persistence.EntityManager; +import javax.persistence.PersistenceContext; + +import pe.edu.pucp.odiparback.models.Cliente; +import pe.edu.pucp.odiparback.dao.ClienteDao; + +import org.springframework.stereotype.Repository; +import org.springframework.transaction.annotation.Transactional; + + +@Transactional +@Repository +@SuppressWarnings("unchecked") +public class ClienteDaoImp implements ClienteDao { + @PersistenceContext + EntityManager entityManager; + + @Transactional + @Override + public List<Cliente> getAll() { + List<Cliente> resultado = null; + try{ + String query = "SELECT * FROM ODP_Cliente"; + resultado = entityManager.createQuery(query).getResultList(); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + + return resultado; + } + + @Transactional + @Override + public Cliente get(int id) { + Cliente resultado = null; + try { + resultado = entityManager.find(Cliente.class, id); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + + return resultado; + } + + @Transactional + @Override + public void register(Cliente cliente) { + try { + entityManager.merge(cliente); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + + } + + @Transactional + @Override + public Cliente update(Cliente cliente) { + try { + entityManager.merge(cliente); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + return cliente; + } + + @Transactional + @Override + public void delete(int id) { + Cliente resultado = get(id); + try { + entityManager.remove(resultado); + } + 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 new file mode 100644 index 0000000..ac076cf --- /dev/null +++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/PTGDaoImp.java @@ -0,0 +1,86 @@ +package pe.edu.pucp.odiparback.dao.imp; +import java.util.List; + +import javax.persistence.EntityManager; +import javax.persistence.PersistenceContext; + +import pe.edu.pucp.odiparback.models.PTG; +import pe.edu.pucp.odiparback.dao.PTGDao; + +import org.springframework.stereotype.Repository; +import org.springframework.transaction.annotation.Transactional; + + +@Transactional +@Repository +@SuppressWarnings("unchecked") +public class PTGDaoImp implements PTGDao{ + @PersistenceContext + EntityManager entityManager; + + @Transactional + @Override + public List<PTG> getAll() { + List<PTG> resultado = null; + try{ + String query = "SELECT * FROM ODP_PTG"; + resultado = entityManager.createQuery(query).getResultList(); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + + return resultado; + } + + @Transactional + @Override + public PTG get(int id) { + PTG resultado = null; + try { + resultado = entityManager.find(PTG.class, id); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + + return resultado; + } + + @Transactional + @Override + public void register(PTG planTransporte) { + try { + entityManager.merge(planTransporte); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + + } + + @Transactional + @Override + public PTG update(PTG planTransporte) { + try { + entityManager.merge(planTransporte); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + return planTransporte; + } + + @Transactional + @Override + public void delete(int id) { + PTG resultado = get(id); + try { + entityManager.remove(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 new file mode 100644 index 0000000..3ebc387 --- /dev/null +++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/PedidoDaoImp.java @@ -0,0 +1,85 @@ +package pe.edu.pucp.odiparback.dao.imp; +import java.util.List; + +import javax.persistence.EntityManager; +import javax.persistence.PersistenceContext; + +import pe.edu.pucp.odiparback.models.Pedido; +import pe.edu.pucp.odiparback.dao.PedidoDao; + +import org.springframework.stereotype.Repository; +import org.springframework.transaction.annotation.Transactional; + + +@Transactional +@Repository +@SuppressWarnings("unchecked") +public class PedidoDaoImp implements PedidoDao { + @PersistenceContext + EntityManager entityManager; + + @Transactional + @Override + public List<Pedido> getAll() { + List<Pedido> resultado = null; + try{ + String query = "SELECT * FROM ODP_Pedido"; + resultado = entityManager.createQuery(query).getResultList(); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + + return resultado; + } + + @Transactional + @Override + public Pedido get(int id) { + Pedido resultado = null; + try { + resultado = entityManager.find(Pedido.class, id); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + + return resultado; + } + + @Transactional + @Override + public void register(Pedido pedido) { + try { + entityManager.merge(pedido); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + } + + @Transactional + @Override + public Pedido update(Pedido pedido) { + try { + entityManager.merge(pedido); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + return pedido; + } + + @Transactional + @Override + public void delete(int id) { + Pedido resultado = get(id); + try { + entityManager.remove(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 new file mode 100644 index 0000000..15788d4 --- /dev/null +++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/RegionDaoImp.java @@ -0,0 +1,85 @@ +package pe.edu.pucp.odiparback.dao.imp; +import java.util.List; + +import javax.persistence.EntityManager; +import javax.persistence.PersistenceContext; + +import pe.edu.pucp.odiparback.models.Region; +import pe.edu.pucp.odiparback.dao.RegionDao; + +import org.springframework.stereotype.Repository; +import org.springframework.transaction.annotation.Transactional; + + +@Transactional +@Repository +@SuppressWarnings("unchecked") +public class RegionDaoImp implements RegionDao { + @PersistenceContext + EntityManager entityManager; + + @Transactional + @Override + public List<Region> getAll() { + List<Region> resultado = null; + try{ + String query = "SELECT * FROM ODP_Region"; + resultado = entityManager.createQuery(query).getResultList(); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + + return resultado; + } + + @Transactional + @Override + public Region get(int id) { + Region resultado = null; + try { + resultado = entityManager.find(Region.class, id); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + + return resultado; + } + + @Transactional + @Override + public void register(Region region) { + try { + entityManager.merge(region); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + } + + @Transactional + @Override + public Region update(Region region) { + try { + entityManager.merge(region); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + return region; + } + + @Transactional + @Override + public void delete(int id) { + Region resultado = get(id); + try { + entityManager.remove(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 new file mode 100644 index 0000000..0e491b7 --- /dev/null +++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/RutaDaoImp.java @@ -0,0 +1,85 @@ +package pe.edu.pucp.odiparback.dao.imp; +import java.util.List; + +import javax.persistence.EntityManager; +import javax.persistence.PersistenceContext; + +import pe.edu.pucp.odiparback.models.Ruta; +import pe.edu.pucp.odiparback.dao.RutaDao; + +import org.springframework.stereotype.Repository; +import org.springframework.transaction.annotation.Transactional; + + +@Transactional +@Repository +@SuppressWarnings("unchecked") +public class RutaDaoImp implements RutaDao { + @PersistenceContext + EntityManager entityManager; + + @Transactional + @Override + public List<Ruta> getAll() { + List<Ruta> resultado = null; + try{ + String query = "SELECT * FROM ODP_Ruta"; + resultado = entityManager.createQuery(query).getResultList(); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + + return resultado; + } + + @Transactional + @Override + public Ruta get(int id) { + Ruta resultado = null; + try { + resultado = entityManager.find(Ruta.class, id); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + + return resultado; + } + + @Transactional + @Override + public void register(Ruta ruta) { + try { + entityManager.merge(ruta); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + } + + @Transactional + @Override + public Ruta update(Ruta ruta) { + try { + entityManager.merge(ruta); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + return ruta; + } + + @Transactional + @Override + public void delete(int id) { + Ruta resultado = get(id); + try { + entityManager.remove(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 new file mode 100644 index 0000000..f2980cf --- /dev/null +++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TipoAveriaDaoImp.java @@ -0,0 +1,85 @@ +package pe.edu.pucp.odiparback.dao.imp; +import java.util.List; + +import javax.persistence.EntityManager; +import javax.persistence.PersistenceContext; + +import pe.edu.pucp.odiparback.models.TipoAveria; +import pe.edu.pucp.odiparback.dao.TipoAveriaDao; + +import org.springframework.stereotype.Repository; +import org.springframework.transaction.annotation.Transactional; + + +@Transactional +@Repository +@SuppressWarnings("unchecked") +public class TipoAveriaDaoImp implements TipoAveriaDao{ + @PersistenceContext + EntityManager entityManager; + + @Transactional + @Override + public List<TipoAveria> getAll() { + List<TipoAveria> resultado = null; + try{ + String query = "SELECT * FROM ODP_TipoAveria"; + resultado = entityManager.createQuery(query).getResultList(); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + + return resultado; + } + + @Transactional + @Override + public TipoAveria get(int id) { + TipoAveria resultado = null; + try { + resultado = entityManager.find(TipoAveria.class, id); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + + return resultado; + } + + @Transactional + @Override + public void register(TipoAveria tipoAveria) { + try { + entityManager.merge(tipoAveria); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + } + + @Transactional + @Override + public TipoAveria update(TipoAveria tipoAveria) { + try { + entityManager.merge(tipoAveria); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + return tipoAveria; + } + + @Transactional + @Override + public void delete(int id) { + TipoAveria resultado = get(id); + try { + entityManager.remove(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 new file mode 100644 index 0000000..0889570 --- /dev/null +++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TipoCamionDaoImp.java @@ -0,0 +1,85 @@ +package pe.edu.pucp.odiparback.dao.imp; +import java.util.List; + +import javax.persistence.EntityManager; +import javax.persistence.PersistenceContext; + +import pe.edu.pucp.odiparback.models.TipoCamion; +import pe.edu.pucp.odiparback.dao.TipoCamionDao; + +import org.springframework.stereotype.Repository; +import org.springframework.transaction.annotation.Transactional; + + +@Transactional +@Repository +@SuppressWarnings("unchecked") +public class TipoCamionDaoImp implements TipoCamionDao{ + @PersistenceContext + EntityManager entityManager; + + @Transactional + @Override + public List<TipoCamion> getAll() { + List<TipoCamion> resultado = null; + try{ + String query = "SELECT * FROM ODP_TipoCamion"; + resultado = entityManager.createQuery(query).getResultList(); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + + return resultado; + } + + @Transactional + @Override + public TipoCamion get(int id) { + TipoCamion resultado = null; + try { + resultado = entityManager.find(TipoCamion.class, id); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + + return resultado; + } + + @Transactional + @Override + public void register(TipoCamion tipoCamion) { + try { + entityManager.merge(tipoCamion); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + } + + @Transactional + @Override + public TipoCamion update(TipoCamion tipoCamion) { + try { + entityManager.merge(tipoCamion); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + return tipoCamion; + } + + @Transactional + @Override + public void delete(int id) { + TipoCamion resultado = get(id); + try { + entityManager.remove(resultado); + } + 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 new file mode 100644 index 0000000..717dcf2 --- /dev/null +++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TramoDaoImp.java @@ -0,0 +1,85 @@ +package pe.edu.pucp.odiparback.dao.imp; +import java.util.List; + +import javax.persistence.EntityManager; +import javax.persistence.PersistenceContext; + +import pe.edu.pucp.odiparback.models.Tramo; +import pe.edu.pucp.odiparback.dao.TramoDao; + +import org.springframework.stereotype.Repository; +import org.springframework.transaction.annotation.Transactional; + + +@Transactional +@Repository +@SuppressWarnings("unchecked") +public class TramoDaoImp implements TramoDao{ + @PersistenceContext + EntityManager entityManager; + + @Transactional + @Override + public List<Tramo> getAll() { + List<Tramo> resultado = null; + try{ + String query = "SELECT * FROM ODP_Tramo"; + resultado = entityManager.createQuery(query).getResultList(); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + + return resultado; + } + + @Transactional + @Override + public Tramo get(int id) { + Tramo resultado = null; + try { + resultado = entityManager.find(Tramo.class, id); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + + return resultado; + } + + @Transactional + @Override + public void register(Tramo tramo) { + try { + entityManager.merge(tramo); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + } + + @Transactional + @Override + public Tramo update(Tramo tramo) { + try { + entityManager.merge(tramo); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + return tramo; + } + + @Transactional + @Override + public void delete(int id) { + Tramo resultado = get(id); + try { + entityManager.remove(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 new file mode 100644 index 0000000..1808c61 --- /dev/null +++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/TramoRutaDaoImp.java @@ -0,0 +1,86 @@ +package pe.edu.pucp.odiparback.dao.imp; +import java.util.List; + +import javax.persistence.EntityManager; +import javax.persistence.PersistenceContext; + +import pe.edu.pucp.odiparback.models.TramoRuta; +import pe.edu.pucp.odiparback.dao.TramoRutaDao; + +import org.springframework.stereotype.Repository; +import org.springframework.transaction.annotation.Transactional; + + +@Transactional +@Repository +@SuppressWarnings("unchecked") +public class TramoRutaDaoImp implements TramoRutaDao { + @PersistenceContext + EntityManager entityManager; + + @Transactional + @Override + public List<TramoRuta> getAll() { + List<TramoRuta> resultado = null; + try{ + String query = "SELECT * FROM ODP_TramoRuta"; + resultado = entityManager.createQuery(query).getResultList(); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + + return resultado; + } + + @Transactional + @Override + public TramoRuta get(int id) { + TramoRuta resultado = null; + try { + resultado = entityManager.find(TramoRuta.class, id); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + + return resultado; + } + + @Transactional + @Override + public void register(TramoRuta tramoRuta) { + try { + entityManager.merge(tramoRuta); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + + } + + @Transactional + @Override + public TramoRuta update(TramoRuta tramoRuta) { + try { + entityManager.merge(tramoRuta); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + return tramoRuta; + } + + @Transactional + @Override + public void delete(int id) { + TramoRuta resultado = get(id); + try { + entityManager.remove(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 new file mode 100644 index 0000000..c0e6ef1 --- /dev/null +++ b/back/odiparback/src/main/java/pe/edu/pucp/odiparback/dao/imp/UsuarioDaoImp.java @@ -0,0 +1,85 @@ +package pe.edu.pucp.odiparback.dao.imp; +import java.util.List; + +import javax.persistence.EntityManager; +import javax.persistence.PersistenceContext; + +import pe.edu.pucp.odiparback.models.Usuario; +import pe.edu.pucp.odiparback.dao.UsuarioDao; + +import org.springframework.stereotype.Repository; +import org.springframework.transaction.annotation.Transactional; + + +@Transactional +@Repository +@SuppressWarnings("unchecked") +public class UsuarioDaoImp implements UsuarioDao{ + @PersistenceContext + EntityManager entityManager; + + @Transactional + @Override + public List<Usuario> getAll() { + List<Usuario> resultado = null; + try{ + String query = "SELECT * FROM ODP_Usuario"; + resultado = entityManager.createQuery(query).getResultList(); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + + return resultado; + } + + @Transactional + @Override + public Usuario get(int id) { + Usuario resultado = null; + try { + resultado = entityManager.find(Usuario.class, id); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + + return resultado; + } + + @Transactional + @Override + public void register(Usuario usuario) { + try { + entityManager.merge(usuario); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + } + + @Transactional + @Override + public Usuario update(Usuario usuario) { + try { + entityManager.merge(usuario); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + return usuario; + } + + @Transactional + @Override + public void delete(int id) { + Usuario resultado = get(id); + try { + entityManager.remove(resultado); + } + catch(Exception ex){ + System.out.print(ex.getMessage()); + } + } + +} |