Changeset 3650316 for src/main/java/com/example/moviezone

Timestamp:

02/07/23 14:48:59 (23 months ago)

Author:

DenicaKj <dkorvezir@…>

Branches:

master

Children:

cb5debb

Parents:

3242ef4

Message:

Trying To Call A procedure from databasee

Location:

src/main/java/com/example/moviezone

Files:

• model/procedures/FilmsReturnTable.java (added)
• repository/FilmRepository.java (modified) (2 diffs)
• web/HomeController.java (modified) (2 diffs)

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

@@ -2 +2 @@
 
 import com.example.moviezone.model.Film;
+import com.example.moviezone.model.procedures.FilmsReturnTable;
 import org.springframework.data.jpa.repository.JpaRepository;
 import org.springframework.data.jpa.repository.query.Procedure;
@@ -9 +10 @@
 
 public interface FilmRepository extends JpaRepository<Film,Integer> {
-
+    @Procedure("project.getFilmsFromCinema")
+    List<FilmsReturnTable> getFilmsFromCinema(int id);
 }

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

@@ -31 +31 @@
 
     public HomeController(FilmService filmService, UserService userService, ProjectionService projectionService, EventService eventService, TicketService ticketService, WorkerService workerService, CustomerRatesFilmService customerRatesFilmService, CinemaService cinemaService, CinemaOrganizesEventService cinemaOrganizesEventService, CinemaPlaysFilmService cinemaPlaysFilmService) {
+        
         this.filmService = filmService;
         this.userService = userService;
@@ -124 +125 @@
     @GetMapping("/films")
     public String getFilmsPage(Model model){
+        model.addAttribute("cinemas",cinemaService.findAllCinemas());
         model.addAttribute("films",filmService.findAllFilms());
         model.addAttribute("bodyContent","films");