From e5e480da9fceac96b1a178484c9b58f49a25f37c Mon Sep 17 00:00:00 2001
From: Hendrik Jungnitsch <hendrik.jungnitsch@gedoplan.de>
Date: Mo, 14 Nov 2022 12:14:04 +0100
Subject: [PATCH] exercis03
---
src/main/java/de/gedoplan/seminar/jpa/exercise/repository/HighwayRepository.java | 7 +++++++
1 files changed, 7 insertions(+), 0 deletions(-)
diff --git a/src/main/java/de/gedoplan/seminar/jpa/exercise/repository/HighwayRepository.java b/src/main/java/de/gedoplan/seminar/jpa/exercise/repository/HighwayRepository.java
index afdf070..d66679f 100644
--- a/src/main/java/de/gedoplan/seminar/jpa/exercise/repository/HighwayRepository.java
+++ b/src/main/java/de/gedoplan/seminar/jpa/exercise/repository/HighwayRepository.java
@@ -1,11 +1,18 @@
package de.gedoplan.seminar.jpa.exercise.repository;
+import java.util.List;
+
import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;
import de.gedoplan.seminar.jpa.exercise.domain.Highway;
@Repository
public interface HighwayRepository extends JpaRepository<Highway, Integer> {
+
+ public List<Highway> findByOrigin(String orgigin);
+ @Query("select count(distinct h.origin) from Highway h")
+ public Long countOrigins();
}
--
Gitblit v1.7.1