hus.censoCamas.repo

Interface PacienteRepo

All Superinterfaces:

org.springframework.data.repository.CrudRepository<Paciente,java.lang.Integer>, org.springframework.data.jpa.repository.JpaRepository<Paciente,java.lang.Integer>, org.springframework.data.repository.PagingAndSortingRepository<Paciente,java.lang.Integer>, org.springframework.data.repository.query.QueryByExampleExecutor<Paciente>, org.springframework.data.repository.Repository<Paciente,java.lang.Integer>

public interface PacienteRepo
extends org.springframework.data.jpa.repository.JpaRepository<Paciente,java.lang.Integer>

Method Summary

Modifier and Type	Method and Description
java.util.Optional<Paciente>	findByDocumento(java.lang.String documento)
java.util.Optional<java.util.List<Paciente>>	findByDocumentoStartsWith(java.lang.String documento)
java.util.Optional<Paciente>	findPacienteById(java.lang.Integer id)
java.util.List<Paciente>	findPacienteByNombreContaining(java.lang.String nombre)

Methods inherited from interface org.springframework.data.jpa.repository.JpaRepository

deleteAllInBatch, deleteInBatch, findAll, findAll, findAll, findAll, findAllById, flush, getOne, saveAll, saveAndFlush

Methods inherited from interface org.springframework.data.repository.PagingAndSortingRepository

findAll

Methods inherited from interface org.springframework.data.repository.CrudRepository

count, delete, deleteAll, deleteAll, deleteById, existsById, findById, save

Methods inherited from interface org.springframework.data.repository.query.QueryByExampleExecutor

count, exists, findAll, findOne

Method Detail

findPacienteById

java.util.Optional<Paciente> findPacienteById(java.lang.Integer id)

findPacienteByNombreContaining

@Query(value="select * \nFROM [GENPACIEN]\nwhere replace(ISNULL(PACPRINOM,\'\')+\' \'+ISNULL(PACSEGNOM,\'\')+\' \'+ISNULL(PACPRIAPE,\'\')+\' \'+ISNULL(PACSEGAPE,\'\'), \'   \',\' \') LIKE %?1% \n",
       nativeQuery=true)
java.util.List<Paciente> findPacienteByNombreContaining(java.lang.String nombre)

findByDocumentoStartsWith

@Query(value="select * \nFROM [GENPACIEN]\nwhere PACNUMDOC like ?1% \n",
       nativeQuery=true)
java.util.Optional<java.util.List<Paciente>> findByDocumentoStartsWith(java.lang.String documento)

findByDocumento

java.util.Optional<Paciente> findByDocumento(java.lang.String documento)