Interface BankerRepository

All Superinterfaces:
org.springframework.data.repository.CrudRepository<Banker,Integer>, org.springframework.data.repository.Repository<Banker,Integer>
public interface BankerRepository extends org.springframework.data.repository.CrudRepository<Banker,Integer>
Repository for banker entities and custom queries.

  • Method Summary

    Modifier and Type
    Method
    Description
    int
    countAllBankers()
    Returns the total number of bankers.
    int
    countBankersByName(String bankerNome, String bankerCognome)
    Returns the count of bankers matching a name and surname.
    int
    updateBanker(String bankerName, String bankerCognome, int bankerId)
    Updates banker data via native SQL.

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

    count, delete, deleteAll, deleteAll, deleteAllById, deleteById, existsById, findAll, findAllById, findById, save, saveAll

  • Method Details

    • countAllBankers

      @Query(value="SELECT COUNT(*) FROM bankers", nativeQuery=true) int countAllBankers()
      Returns the total number of bankers.

    • countBankersByName

      @Query(value="SELECT COUNT(*) FROM bankers b WHERE b.nome = :bankerNome AND b.cognome = :bankerCognome", nativeQuery=true) int countBankersByName(String bankerNome, String bankerCognome)
      Returns the count of bankers matching a name and surname.

    • updateBanker

      @Transactional @Modifying @Query(value="UPDATE bankers SET nome=:bankerName, cognome=:bankerCognome WHERE id=:bankerId", nativeQuery=true) int updateBanker(String bankerName, String bankerCognome, int bankerId)
      Updates banker data via native SQL.