Changeset 61fed7c

Timestamp:

02/08/23 13:58:18 (22 months ago)

Author:

DenicaKj <dkorvezir@…>

Branches:

master

Children:

39a45e6, 90317ea

Parents:

86e187f

Message:

Procedure Returns Table Fix

Location:

src/main/java/com/example/moviezone

Files:

• repository/FilmRepository.java (modified) (1 diff)
• service/FilmService.java (modified) (1 diff)
• service/Impl/FilmServiceImpl.java (modified) (1 diff)
• web/HomeController.java (modified) (2 diffs)

src/main/java/com/example/moviezone/repository/FilmRepository.java

@@ -15 +15 @@
 @Transactional
 public interface FilmRepository extends JpaRepository<Film,Integer> {
-    @Procedure("project.getFilmsFromCinema")
-    List<FilmsReturnTable> getFilmsFromCinema(int id);
+    @Procedure("project.getFilmsFromCinema1")
+    List<Film> getFilmsFromCinema(int id);
 
 }

src/main/java/com/example/moviezone/service/FilmService.java

@@ -13 +13 @@
               String age_category, String url, String director, LocalDate start_date,LocalDate end_date);
     Optional<Film> getFilmById(Long id);
-    List<FilmsReturnTable> getFilmsFromCinema(int id);
+    List<Film> getFilmsFromCinema(int id);
 }

src/main/java/com/example/moviezone/service/Impl/FilmServiceImpl.java

@@ -36 +36 @@
 
     @Override
-    public List<FilmsReturnTable> getFilmsFromCinema(int id) {
+    public List<Film> getFilmsFromCinema(int id) {
         return filmRepository.getFilmsFromCinema(id);
     }

src/main/java/com/example/moviezone/web/HomeController.java

@@ -134 +134 @@
 
     }
-//    @GetMapping("/films")
-//    public String getFilmsPage(Model model){
-//        model.addAttribute("cinemas",cinemaService.findAllCinemas());
-//            List<FilmsReturnTable> pom=new LinkedList<>();
-//            model.addAttribute("films",pom);
-//            boolean h=pom.isEmpty();
-//            List<FilmsReturnTable> help=filmService.getFilmsFromCinema(2);
-//        model.addAttribute("bodyContent","films");
-//        return "master-template";
-//    }
-
-    //@GetMapping("/films")
-    @Transactional
-    public String getFilmsPage(Model model){
-        model.addAttribute("cinemas",cinemaService.findAllCinemas());
-            List<FilmsReturnTable> pom=new LinkedList<>();
-            model.addAttribute("films",pom);
-            boolean h=pom.isEmpty();
-            List<FilmsReturnTable> help=filmService.getFilmsFromCinema(2);
-        model.addAttribute("bodyContent","films");
-        return "master-template";
-    }
 
 
@@ -172 +150 @@
     }
 
-//    @PostMapping("/getFilmsFromCinema")
-//    public String getFilmsFromCinema(@RequestParam Integer cinema, Model model){
-//        return getFilmsPage1(model,cinema);
-//    }
     @GetMapping("/projections")
     public String getProjectionsPage(Model model)