The best part? Spring Boot is popular in the real world, so learning it now will help you in your future career. Plus, it’s perfect for building websites that need to handle lots of users at once – exactly what we need for our movie reservation system!<\/p>\n
What We’ll Build Together:<\/h2>\n\n- A website where users can view movies and show times.<\/li>\n
- A way to select seats and make reservations for showtimes.<\/li>\n
- Allows admins to manage movies.<\/li>\n
- The system should prioritize availability for viewing movies and shows but should prioritize consistency for reservations.<\/li>\n<\/ul>\n
Ready to dive in? Let’s start building something awesome! <\/p>\n
Getting Started <\/h3>\n
To follow along, you’ll need:<\/p>\n
\n- Basic Java knowledge<\/li>\n
- A code editor (like IntelliJ or VS Code)<\/li>\n
- Java Development Kit (JDK) installed<\/li>\n<\/ul>\n
Create a Spring Boot Project<\/h3>\n
Navigate to start.spring.io<\/a>. This service pulls in all the dependencies you need for an application and does most of the setup. Click generate, it will generate the Spring Boot project and download it as a zip. Now unzip this project and import it into any IDE.<br><\/p>\nTo interact with GridDB, we need to add a GridDB Java Client to this project. Add the following dependency into maven pom.xml<\/code>.<\/p>\n\n<dependency>\n <groupId>com.github.griddb<\/groupId>\n <artifactId>gridstore<\/artifactId>\n <version>5.5.0<\/version>\n<\/dependency><\/code><\/pre>\n<\/div>\nDefining the Entities<\/h3>\n
Let’s start by looking at the big picture – kind of like sketching out the blueprint before building a house. Think of this like making a list of the main “things” our app needs to keep track of. In coding, we call these “entities” (but really, they’re just the important pieces of data we need to store).<\/p>\n
First, let’s list out the key items we need for our app to work properly. We’ll need the following entities:<\/p>\n
\n- \n
Movie: This entity stores essential information about a movie, for example, title and genre.<\/p>\n<\/li>\n
- \n
Show: contains information related to the schedule or actual time at which a movie begins.<\/p>\n<\/li>\n
- \n
Seat: represents the physical seat location.<\/p>\n<\/li>\n
- User: represents the individual interacting with the system.<\/li>\n
- Reservation: records the details of a user’s reservation. It typically includes the user ID, show ID, total price, reservation status, and seat number.<\/li>\n<\/ul>\n
Next, let’s create Java POJO classes.<\/p>\n
\n@Data\npublic class User {\n @RowKey\n String id;\n String email;\n String fullName;\n Date createdAt;\n}\n\n@Data\npublic class Movie {\n @RowKey\n private String id;\n private String title;\n private String genre;\n}\n\n@Data\npublic class Show {\n @RowKey\n private String id;\n private String movieId;\n private Date startTime;\n private Date endTime;\n private Double price;\n private Integer totalSeats;\n}\n\n@Data\npublic class Seat {\n @RowKey\n private String id;\n private String status;\n private String showId;\n private String seatNumber;\n}\n\n@Data\npublic class Reservation {\n @RowKey\n private String id;\n private String userId;\n private String showId;\n private Double totalPrice;\n private Integer numberOfSeats;\n private String[] seats;\n Date createdAt;\n}\n<\/code><\/pre>\n<\/div>\nNext, we create the GridDBConfig<\/code> class as a central configuration for database operation.
\nThe class will do the following:
\n* Read environment variables for connecting to the GridDB database
\n* Create a GridStore class for managing database connection to the GridDB instance
\n* Create GridDB Collection’s container (Table) to manage a set of rows. The container is a rough equivalent of the table in a relational database.
\n* On creating\/updating the Collection we specify the name and object corresponding to the column layout of the collection.
\n Also for each collection, we add an index for a column that is frequently searched and used in the condition of the WHERE section of TQL.
\n* Make the container available in the Spring container<\/p>\n\n@Configuration\npublic class GridDBConfig {\n\n @Value(\"${GRIDDB_NOTIFICATION_MEMBER}\")\n private String notificationMember;\n\n @Value(\"${GRIDDB_CLUSTER_NAME}\")\n private String clusterName;\n\n @Value(\"${GRIDDB_USER}\")\n private String user;\n\n @Value(\"${GRIDDB_PASSWORD}\")\n private String password;\n\n @Bean\n public GridStore gridStore() throws GSException {\n Properties properties = new Properties();\n properties.setProperty(\"notificationMember\", notificationMember);\n properties.setProperty(\"clusterName\", clusterName);\n properties.setProperty(\"user\", user);\n properties.setProperty(\"password\", password);\n GridStore store = GridStoreFactory.getInstance().getGridStore(properties);\n return store;\n }\n\n @Bean\n public Collection<String, User> userCollection(GridStore gridStore) throws GSException {\n Collection<String, User> collection =\n gridStore.putCollection(AppConstant.USERS_CONTAINER, User.class);\n collection.createIndex(\"email\");\n return collection;\n }\n\n @Bean\n public Collection<String, Movie> movieCollection(GridStore gridStore) throws GSException {\n Collection<String, Movie> movieCollection =\n gridStore.putCollection(AppConstant.MOVIE_CONTAINER, Movie.class);\n movieCollection.createIndex(\"title\");\n return movieCollection;\n }\n\n @Bean\n public Collection<String, Show> showCollection(GridStore gridStore) throws GSException {\n Collection<String, Show> showCollection =\n gridStore.putCollection(AppConstant.SHOW_CONTAINER, Show.class);\n showCollection.createIndex(\"movieId\");\n return showCollection;\n }\n\n @Bean\n public Collection<String, Seat> seatCollection(GridStore gridStore) throws GSException {\n Collection<String, Seat> seatCollection =\n gridStore.putCollection(AppConstant.SEAT_CONTAINER, Seat.class);\n seatCollection.createIndex(\"showId\");\n return seatCollection;\n }\n\n @Bean\n public Collection<String, Reservation> reservationCollection(GridStore gridStore)\n throws GSException {\n Collection<String, Reservation> reservationCollection =\n gridStore.putCollection(AppConstant.RESERVATION_CONTAINER, Reservation.class);\n reservationCollection.createIndex(\"userId\");\n reservationCollection.createIndex(\"showId\");\n return reservationCollection;\n }\n}<\/code><\/pre>\n<\/div>\nListing and creating movies<\/h3>\n
Now, we create the service class MovieService.java<\/code> in the service<\/code> package and implement all the business logic in this class. This service class will interact with the database and return the result after converting it to the DTO class.<\/p>\n\nprivate List<Movie> fetchAll() {\n List<Movie> movies = new ArrayList<>(0);\n try {\n String tql = \"SELECT * FROM \" + AppConstant.MOVIE_CONTAINER;\n Query<Movie> query = movieCollection.query(tql);\n RowSet<Movie> rowSet = query.fetch();\n while (rowSet.hasNext()) {\n Movie row = rowSet.next();\n movies.add(row);\n }\n } catch (GSException e) {\n log.error(\"Error fetch all movies\", e);\n }\n return movies;\n}\n\npublic List<MovieDTO> findAll() {\n final List<Movie> movies = fetchAll();\n return movies.stream().map(movie -> mapToDTO(movie, new MovieDTO())).toList();\n}\n\npublic MovieDTO get(final String id) {\n try (Query<Movie> query =\n movieCollection.query(\"SELECT * WHERE id='\" + id + \"'\", Movie.class)) {\n RowSet<Movie> rowSet = query.fetch();\n if (rowSet.hasNext()) {\n return mapToDTO(rowSet.next(), new MovieDTO());\n } else {\n throw new NotFoundException();\n }\n } catch (GSException e) {\n throw new AppErrorException();\n }\n}\n\npublic String create(final MovieDTO movieDTO) {\n if (titleExists(movieDTO.getTitle())) {\n return \"\";\n }\n final Movie movie = new Movie();\n mapToEntity(movieDTO, movie);\n movie.setId(KeyGenerator.next(\"mv_\"));\n try {\n movieCollection.put(movie);\n } catch (GSException e) {\n log.error(\"Failed put into Movie collection\", e);\n throw new AppErrorException();\n }\n return movie.getId();\n}<\/code><\/pre>\n<\/div>\nAfter creating the service class, we will create the controllers to handle the HTTP request based on the URL. MovieController.java<\/code> handles all the HTTP requests to \/movies<\/code>. This class will provide attributes to the HTML page.<\/p>\n\n@Controller\n@RequestMapping(\"\/movies\")\npublic class MovieController {\n\n private final MovieService movieService;\n\n public MovieController(final MovieService movieService) {\n this.movieService = movieService;\n }\n\n @GetMapping\n public String list(final Model model) {\n model.addAttribute(\"movies\", movieService.findAll());\n return \"movie\/list\";\n }\n\n @GetMapping(\"\/add\")\n public String add(@ModelAttribute(\"movie\") final MovieDTO movieDTO) {\n return \"movie\/add\";\n }\n\n @PostMapping(\"\/add\")\n public String add(@ModelAttribute(\"movie\") @Valid final MovieDTO movieDTO,\n final BindingResult bindingResult, final RedirectAttributes redirectAttributes) {\n if (bindingResult.hasErrors()) {\n return \"movie\/add\";\n }\n movieService.create(movieDTO);\n redirectAttributes.addFlashAttribute(WebUtils.MSG_SUCCESS,\n WebUtils.getMessage(\"movie.create.success\"));\n return \"redirect:\/movies\";\n }\n\n}<\/code><\/pre>\n<\/div>\nNext, we need the html pages for listing movies. We will use HTML elements to render tabular data comprised of rows and columns of cells. Inside the table body, we use Thymeleaf th:each<\/code> to iterate over collections of movies.<\/p>\n\n<table class=\"table table-striped table-hover align-middle\">\n <thead>\n <tr>\n <th scope=\"col\">[[#{movie.title.label}]]<\/th>\n <th scope=\"col\">[[#{movie.genre.label}]]<\/th>\n <th><!-- --><\/th>\n <\/tr>\n <\/thead>\n <tbody>\n <tr th_each=\"movie : ${movies}\">\n <td>[[${movie.title}]]<\/td>\n <td>[[${movie.genre}]]<\/td>\n <td>\n <div class=\"float-end text-nowrap\">\n <a th_href=\"@{\/shows\/movie\/{movieId}(movieId=${movie.id})}\" class=\"btn btn-sm btn-primary\">[[#{movie.list.show}]]<\/a>\n <\/div>\n <\/td>\n <\/tr>\n <\/tbody>\n<\/table><\/code><\/pre>\n<\/div>\n![\"\"](\"https:\/\/griddb.net\/wp-content\/uploads\/2025\/04\/movie-list.png\")
<\/a><\/p>\nNext, we create a page to create a new movie. We use the <form><\/code> tag for submitting user input.<\/p>\n\n<form th_action=\"${requestUri}\" method=\"post\">\n <div th_replace=\"~{fragments\/forms::inputRow(object='movie', field='title', required=true)}\" \/>\n <div th_replace=\"~{fragments\/forms::inputRow(object='movie', field='genre')}\" \/>\n <input type=\"submit\" th_value=\"#{movie.add.headline}\" class=\"btn btn-primary mt-4\" \/>\n<\/form><\/code><\/pre>\n<\/div>\nShowtimes<\/h3>\n
After completing the movies listing, we continue to create the showtimes. We will repeat the same process to create a listing page which will show the movie name, start time, end time, price and total seats. The final result will be like this:
\n![\"\"](\"https:\/\/griddb.net\/wp-content\/uploads\/2025\/04\/show-list.png\")
<\/a><\/p>\nTo make reservations, operator click Reserve<\/code> button from the shows listing.<\/p>\nReservation<\/h3>\n
We create the service class ReservationService.java<\/code> to handle the reservation process. This class will interact with reservations and seat tables.<\/p>\n\n@Service\npublic class ReservationService {\n\n private final Collection<String, Reservation> reservationCollection;\n private final Collection<String, Seat> seatCollection;\n\n public ReservationService(Collection<String, Reservation> reservationCollection,\n Collection<String, Seat> seatCollection) {\n this.reservationCollection = reservationCollection;\n this.seatCollection = seatCollection;\n }\n}<\/code><\/pre>\n<\/div>\nReservation Flow<\/h4>\n
![\"\"](\"https:\/\/griddb.net\/wp-content\/uploads\/2025\/04\/add-reservation.png\")
<\/a><\/p>\nHere’s a detailed breakdown of the seat selection functional requirements:<\/p>\n
\n- Display the showtime and base price<\/li>\n
- Display seats with color indicator: Not available (red), Selected seats (blue checkedbox)<\/li>\n
- Allow users to select multiple seats<\/li>\n<\/ul>\n
After users submit the new reservation, the create<\/code> method will handle the technical implementation:<\/p>\n\n- Re-calculate the total price<\/li>\n
- Generate reservation ID<\/li>\n
- Update the seat status from
available<\/code> to reserved<\/code><\/li>\n- If there are multiple seats, then we should make sure all the selected seats can be updated.<\/li>\n<\/ul>\n\n
public String create(final ReservationDTO reservationDTO) {\n reservationDTO.setTotalPrice(reservationDTO.getShow().getPrice()\n .multiply(new BigDecimal(reservationDTO.getSeats().size())));\n final Reservation reservation = new Reservation();\n mapToEntity(reservationDTO, reservation);\n reservation.setId(KeyGenerator.next(\"rsv\"));\n try {\n seatCollection.setAutoCommit(false);\n for (String seatId : reservationDTO.getSeats()) {\n String tql = \"SELECT * WHERE id='\" + seatId + \"'\";\n log.info(tql);\n Query<Seat> query = seatCollection.query(tql, Seat.class);\n RowSet<Seat> rs = query.fetch(true);\n if (rs.hasNext()) {\n Seat seat = rs.next();\n seat.setStatus(\"RESERVED\");\n rs.update(seat);\n }\n }\n seatCollection.commit();\n reservationCollection.put(reservation);\n } catch (GSException e) {\n log.error(\"Failed to create reservations\", e);\n throw new AppErrorException(\"Failed to save reservation\");\n }\n return reservation.getId();\n}<\/code><\/pre>\n<\/div>\nThe reservations list will look like this:
\n![\"\"](\"https:\/\/griddb.net\/wp-content\/uploads\/2025\/04\/reservations-list.png\")
<\/a><\/p>\nRunning the Project with Docker Compose<\/h3>\n
Ready to dive in? Let’s start building something awesome! <\/p>\n
Getting Started <\/h3>\n
To follow along, you’ll need:<\/p>\n
- \n
- Basic Java knowledge<\/li>\n
- A code editor (like IntelliJ or VS Code)<\/li>\n
- Java Development Kit (JDK) installed<\/li>\n<\/ul>\n
Create a Spring Boot Project<\/h3>\n
Navigate to start.spring.io<\/a>. This service pulls in all the dependencies you need for an application and does most of the setup. Click generate, it will generate the Spring Boot project and download it as a zip. Now unzip this project and import it into any IDE.<br><\/p>\n
To interact with GridDB, we need to add a GridDB Java Client to this project. Add the following dependency into maven
pom.xml<\/code>.<\/p>\n\n<dependency>\n <groupId>com.github.griddb<\/groupId>\n <artifactId>gridstore<\/artifactId>\n <version>5.5.0<\/version>\n<\/dependency><\/code><\/pre>\n<\/div>\nDefining the Entities<\/h3>\n
Let’s start by looking at the big picture – kind of like sketching out the blueprint before building a house. Think of this like making a list of the main “things” our app needs to keep track of. In coding, we call these “entities” (but really, they’re just the important pieces of data we need to store).<\/p>\n
First, let’s list out the key items we need for our app to work properly. We’ll need the following entities:<\/p>\n
- \n
- \n
Movie: This entity stores essential information about a movie, for example, title and genre.<\/p>\n<\/li>\n
- \n
Show: contains information related to the schedule or actual time at which a movie begins.<\/p>\n<\/li>\n
- \n
Seat: represents the physical seat location.<\/p>\n<\/li>\n
- User: represents the individual interacting with the system.<\/li>\n
- Reservation: records the details of a user’s reservation. It typically includes the user ID, show ID, total price, reservation status, and seat number.<\/li>\n<\/ul>\n
Next, let’s create Java POJO classes.<\/p>\n
\n@Data\npublic class User {\n @RowKey\n String id;\n String email;\n String fullName;\n Date createdAt;\n}\n\n@Data\npublic class Movie {\n @RowKey\n private String id;\n private String title;\n private String genre;\n}\n\n@Data\npublic class Show {\n @RowKey\n private String id;\n private String movieId;\n private Date startTime;\n private Date endTime;\n private Double price;\n private Integer totalSeats;\n}\n\n@Data\npublic class Seat {\n @RowKey\n private String id;\n private String status;\n private String showId;\n private String seatNumber;\n}\n\n@Data\npublic class Reservation {\n @RowKey\n private String id;\n private String userId;\n private String showId;\n private Double totalPrice;\n private Integer numberOfSeats;\n private String[] seats;\n Date createdAt;\n}\n<\/code><\/pre>\n<\/div>\nNext, we create the
GridDBConfig<\/code> class as a central configuration for database operation.
\nThe class will do the following:
\n* Read environment variables for connecting to the GridDB database
\n* Create a GridStore class for managing database connection to the GridDB instance
\n* Create GridDB Collection’s container (Table) to manage a set of rows. The container is a rough equivalent of the table in a relational database.
\n* On creating\/updating the Collection we specify the name and object corresponding to the column layout of the collection.
\n Also for each collection, we add an index for a column that is frequently searched and used in the condition of the WHERE section of TQL.
\n* Make the container available in the Spring container<\/p>\n\n@Configuration\npublic class GridDBConfig {\n\n @Value(\"${GRIDDB_NOTIFICATION_MEMBER}\")\n private String notificationMember;\n\n @Value(\"${GRIDDB_CLUSTER_NAME}\")\n private String clusterName;\n\n @Value(\"${GRIDDB_USER}\")\n private String user;\n\n @Value(\"${GRIDDB_PASSWORD}\")\n private String password;\n\n @Bean\n public GridStore gridStore() throws GSException {\n Properties properties = new Properties();\n properties.setProperty(\"notificationMember\", notificationMember);\n properties.setProperty(\"clusterName\", clusterName);\n properties.setProperty(\"user\", user);\n properties.setProperty(\"password\", password);\n GridStore store = GridStoreFactory.getInstance().getGridStore(properties);\n return store;\n }\n\n @Bean\n public Collection<String, User> userCollection(GridStore gridStore) throws GSException {\n Collection<String, User> collection =\n gridStore.putCollection(AppConstant.USERS_CONTAINER, User.class);\n collection.createIndex(\"email\");\n return collection;\n }\n\n @Bean\n public Collection<String, Movie> movieCollection(GridStore gridStore) throws GSException {\n Collection<String, Movie> movieCollection =\n gridStore.putCollection(AppConstant.MOVIE_CONTAINER, Movie.class);\n movieCollection.createIndex(\"title\");\n return movieCollection;\n }\n\n @Bean\n public Collection<String, Show> showCollection(GridStore gridStore) throws GSException {\n Collection<String, Show> showCollection =\n gridStore.putCollection(AppConstant.SHOW_CONTAINER, Show.class);\n showCollection.createIndex(\"movieId\");\n return showCollection;\n }\n\n @Bean\n public Collection<String, Seat> seatCollection(GridStore gridStore) throws GSException {\n Collection<String, Seat> seatCollection =\n gridStore.putCollection(AppConstant.SEAT_CONTAINER, Seat.class);\n seatCollection.createIndex(\"showId\");\n return seatCollection;\n }\n\n @Bean\n public Collection<String, Reservation> reservationCollection(GridStore gridStore)\n throws GSException {\n Collection<String, Reservation> reservationCollection =\n gridStore.putCollection(AppConstant.RESERVATION_CONTAINER, Reservation.class);\n reservationCollection.createIndex(\"userId\");\n reservationCollection.createIndex(\"showId\");\n return reservationCollection;\n }\n}<\/code><\/pre>\n<\/div>\nListing and creating movies<\/h3>\n
Now, we create the service class
MovieService.java<\/code> in theservice<\/code> package and implement all the business logic in this class. This service class will interact with the database and return the result after converting it to the DTO class.<\/p>\n\nprivate List<Movie> fetchAll() {\n List<Movie> movies = new ArrayList<>(0);\n try {\n String tql = \"SELECT * FROM \" + AppConstant.MOVIE_CONTAINER;\n Query<Movie> query = movieCollection.query(tql);\n RowSet<Movie> rowSet = query.fetch();\n while (rowSet.hasNext()) {\n Movie row = rowSet.next();\n movies.add(row);\n }\n } catch (GSException e) {\n log.error(\"Error fetch all movies\", e);\n }\n return movies;\n}\n\npublic List<MovieDTO> findAll() {\n final List<Movie> movies = fetchAll();\n return movies.stream().map(movie -> mapToDTO(movie, new MovieDTO())).toList();\n}\n\npublic MovieDTO get(final String id) {\n try (Query<Movie> query =\n movieCollection.query(\"SELECT * WHERE id='\" + id + \"'\", Movie.class)) {\n RowSet<Movie> rowSet = query.fetch();\n if (rowSet.hasNext()) {\n return mapToDTO(rowSet.next(), new MovieDTO());\n } else {\n throw new NotFoundException();\n }\n } catch (GSException e) {\n throw new AppErrorException();\n }\n}\n\npublic String create(final MovieDTO movieDTO) {\n if (titleExists(movieDTO.getTitle())) {\n return \"\";\n }\n final Movie movie = new Movie();\n mapToEntity(movieDTO, movie);\n movie.setId(KeyGenerator.next(\"mv_\"));\n try {\n movieCollection.put(movie);\n } catch (GSException e) {\n log.error(\"Failed put into Movie collection\", e);\n throw new AppErrorException();\n }\n return movie.getId();\n}<\/code><\/pre>\n<\/div>\nAfter creating the service class, we will create the controllers to handle the HTTP request based on the URL.
MovieController.java<\/code> handles all the HTTP requests to\/movies<\/code>. This class will provide attributes to the HTML page.<\/p>\n\n@Controller\n@RequestMapping(\"\/movies\")\npublic class MovieController {\n\n private final MovieService movieService;\n\n public MovieController(final MovieService movieService) {\n this.movieService = movieService;\n }\n\n @GetMapping\n public String list(final Model model) {\n model.addAttribute(\"movies\", movieService.findAll());\n return \"movie\/list\";\n }\n\n @GetMapping(\"\/add\")\n public String add(@ModelAttribute(\"movie\") final MovieDTO movieDTO) {\n return \"movie\/add\";\n }\n\n @PostMapping(\"\/add\")\n public String add(@ModelAttribute(\"movie\") @Valid final MovieDTO movieDTO,\n final BindingResult bindingResult, final RedirectAttributes redirectAttributes) {\n if (bindingResult.hasErrors()) {\n return \"movie\/add\";\n }\n movieService.create(movieDTO);\n redirectAttributes.addFlashAttribute(WebUtils.MSG_SUCCESS,\n WebUtils.getMessage(\"movie.create.success\"));\n return \"redirect:\/movies\";\n }\n\n}<\/code><\/pre>\n<\/div>\nNext, we need the html pages for listing movies. We will use HTML elements to render tabular data comprised of rows and columns of cells. Inside the table body, we use Thymeleaf
th:each<\/code> to iterate over collections of movies.<\/p>\n\n<table class=\"table table-striped table-hover align-middle\">\n <thead>\n <tr>\n <th scope=\"col\">[[#{movie.title.label}]]<\/th>\n <th scope=\"col\">[[#{movie.genre.label}]]<\/th>\n <th><!-- --><\/th>\n <\/tr>\n <\/thead>\n <tbody>\n <tr th_each=\"movie : ${movies}\">\n <td>[[${movie.title}]]<\/td>\n <td>[[${movie.genre}]]<\/td>\n <td>\n <div class=\"float-end text-nowrap\">\n <a th_href=\"@{\/shows\/movie\/{movieId}(movieId=${movie.id})}\" class=\"btn btn-sm btn-primary\">[[#{movie.list.show}]]<\/a>\n <\/div>\n <\/td>\n <\/tr>\n <\/tbody>\n<\/table><\/code><\/pre>\n<\/div>\n<\/a><\/p>\nNext, we create a page to create a new movie. We use the
<form><\/code> tag for submitting user input.<\/p>\n\n<form th_action=\"${requestUri}\" method=\"post\">\n <div th_replace=\"~{fragments\/forms::inputRow(object='movie', field='title', required=true)}\" \/>\n <div th_replace=\"~{fragments\/forms::inputRow(object='movie', field='genre')}\" \/>\n <input type=\"submit\" th_value=\"#{movie.add.headline}\" class=\"btn btn-primary mt-4\" \/>\n<\/form><\/code><\/pre>\n<\/div>\nShowtimes<\/h3>\n
After completing the movies listing, we continue to create the showtimes. We will repeat the same process to create a listing page which will show the movie name, start time, end time, price and total seats. The final result will be like this:
\n<\/a><\/p>\nTo make reservations, operator click
Reserve<\/code> button from the shows listing.<\/p>\nReservation<\/h3>\n
We create the service class
ReservationService.java<\/code> to handle the reservation process. This class will interact with reservations and seat tables.<\/p>\n\n@Service\npublic class ReservationService {\n\n private final Collection<String, Reservation> reservationCollection;\n private final Collection<String, Seat> seatCollection;\n\n public ReservationService(Collection<String, Reservation> reservationCollection,\n Collection<String, Seat> seatCollection) {\n this.reservationCollection = reservationCollection;\n this.seatCollection = seatCollection;\n }\n}<\/code><\/pre>\n<\/div>\nReservation Flow<\/h4>\n
<\/a><\/p>\nHere’s a detailed breakdown of the seat selection functional requirements:<\/p>\n
- \n
- Display the showtime and base price<\/li>\n
- Display seats with color indicator: Not available (red), Selected seats (blue checkedbox)<\/li>\n
- Allow users to select multiple seats<\/li>\n<\/ul>\n
After users submit the new reservation, the
create<\/code> method will handle the technical implementation:<\/p>\n- \n
- Re-calculate the total price<\/li>\n
- Generate reservation ID<\/li>\n
- Update the seat status from
available<\/code> toreserved<\/code><\/li>\n- If there are multiple seats, then we should make sure all the selected seats can be updated.<\/li>\n<\/ul>\n
\npublic String create(final ReservationDTO reservationDTO) {\n reservationDTO.setTotalPrice(reservationDTO.getShow().getPrice()\n .multiply(new BigDecimal(reservationDTO.getSeats().size())));\n final Reservation reservation = new Reservation();\n mapToEntity(reservationDTO, reservation);\n reservation.setId(KeyGenerator.next(\"rsv\"));\n try {\n seatCollection.setAutoCommit(false);\n for (String seatId : reservationDTO.getSeats()) {\n String tql = \"SELECT * WHERE id='\" + seatId + \"'\";\n log.info(tql);\n Query<Seat> query = seatCollection.query(tql, Seat.class);\n RowSet<Seat> rs = query.fetch(true);\n if (rs.hasNext()) {\n Seat seat = rs.next();\n seat.setStatus(\"RESERVED\");\n rs.update(seat);\n }\n }\n seatCollection.commit();\n reservationCollection.put(reservation);\n } catch (GSException e) {\n log.error(\"Failed to create reservations\", e);\n throw new AppErrorException(\"Failed to save reservation\");\n }\n return reservation.getId();\n}<\/code><\/pre>\n<\/div>\nThe reservations list will look like this:
\n<\/a><\/p>\nRunning the Project with Docker Compose<\/h3>\n
- If there are multiple seats, then we should make sure all the selected seats can be updated.<\/li>\n<\/ul>\n
- \n