PE_HSF302_FA25_260925
FALL 2025
Subject: HSF302
Duration: 90 minutes
Zoom
INSTRUCTIONS
Please read the instructions carefully before answering the questions.
• You are NOT allowed to use any other materials. You are NOT allowed to use any device to share data
with others.
You must use an IDE such as IntelliJ IDEA 2023 or later, SQL Server 2019 or later for your
development tools.
IMPORTANT - Before you start doing your solution, you MUST do the following steps:
•
To develop your program, you must use Spring Boot + Thymeleaf + Spring Data JPA + SQL Server,
and apply N-Layer architecture. Ensure that each layer interacts through an interface using Dependency
Injection (DI)
Note: You are not allowed to connect directly to the database from the Service or UI layer; every database
connection must be used with Repository using Spring Data JPA. The database connection string must be
obtained from the application.properties file. If your program connects directly to the database from
Service/Pages or hardcodes the connection string; your score will be 0.
1. If there are syntax errors or compilation errors in your PE program, you will not pass the PE
requirements; your score will be 0.
SETUP PROJECT
2. Create a Spring Boot project named pe-hsf302-260925-studentcode, with the package name prefixed as
fa25.studentcode, and include at least four packages: entity, repository, service, and controller.
3. Create your MS SQL database named RiceStoreDB2025 using a code-first approach with Spring Data
JPA, and ensure that it includes the data provided in the PE_HSF302_FA25_260925_Note file.
4 Set the default user interface for your proiect to the Looin Page with the URL
http://localhost:8080/login
+ 100%
Close