DmpIncomeRepository.java

package common.repository;

import common.model.DmpIncome;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface DmpIncomeRepository extends JpaRepository<DmpIncome, Long> {

    @Query(value = "select * from dmp_income where contract_code = ?1 order by income_month", nativeQuery = true)
    List<DmpIncome> findByContractCode(String contractCode);

    @Query(value = "select * from dmp_income where income_month >= ?1 and income_month <=?2 order by income_month", nativeQuery = true)
    List<DmpIncome> findByContractDs(String start, String end);

    @Query(value = "select * from dmp_income where contract_code = ?1 and  income_month =?2 limit 1 ", nativeQuery = true)
    DmpIncome findByCodeMonth(String contractCode, String incomeMonth);
}