hus.censoCamas.repo

Interface TipocamaRepo

All Superinterfaces:

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

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

Method Summary

Modifier and Type	Method and Description
java.util.List<Tipocama>	findAll()
java.util.List<java.lang.String>	findByGrupoSubgrupo(java.lang.String grupo, java.lang.String subgrupo)
Tipocama	findByNombre(java.lang.String nombre)

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

deleteAllInBatch, deleteInBatch, 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

findAll

java.util.List<Tipocama> findAll()

Specified by:

findAll in interface org.springframework.data.repository.CrudRepository<Tipocama,java.lang.Integer>

Specified by:

findAll in interface org.springframework.data.jpa.repository.JpaRepository<Tipocama,java.lang.Integer>

findByNombre

Tipocama findByNombre(java.lang.String nombre)

findByGrupoSubgrupo

@Query(value="select distinct t.HTINOMBRE\nfrom HPNDEFCAM as c\njoin HPNTIPOCA as t\non c.HPNTIPOCA = t.oid \njoin HPNSUBGRU as s\non c.HPNSUBGRU = s.oid\nJOIN HPNGRUPOS as g\non c.HPNGRUPOS = g.oid\nwhere g.HGRNOMBRE like ?1\nand s.hsunombre like ?2\n",
       nativeQuery=true)
java.util.List<java.lang.String> findByGrupoSubgrupo(java.lang.String grupo,
                                                                                                                                                                                                                                                                                                                                               java.lang.String subgrupo)