From 6eecd93c185e5c3122da1a5c53a3784fc580d013 Mon Sep 17 00:00:00 2001
From: Hendrik Jungnitsch <hendrik.jungnitsch@gedoplan.de>
Date: Mi, 07 Sep 2022 15:10:10 +0200
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