Assignment 2 of CMPT276 instructed by Bobby Chan in 2024.
Official Description: "You are commissioned to create an application to track a group of students. Your app will have the ability to add new students, change student attributes, and delete students."
Assignment guidelines can be found at: https://canvas.sfu.ca/courses/83043/assignments/952047
A small web app designed to track a group of students. Will be able to display students in rectangles. Can also add, edit, and delete students.
Deployed on Render.com.
At the bottom of the page, there are buttons useful for testing the app.
"Add Testing Data" button fills the student database with some testing data. Note that this won't clear the database. It will just add more students to it. And it won't check for duplicates either. So, if you run this method multiple times, you will get multiple copies of the same students in the database. Can be useful for testing displaying extreme amount of students.
"Delete All Students" button deletes all students in the database. Note that the Student table still exists. And the ID numbers won't reset.
The port when deploying this project to localhost
have been changed to 9090
. This is because 8080
is being used by a local LLM that have the port number be hardcoded in.
Environment variables are being used to store the database credentials.
As shown in src\main\resources\application.properties
, the environment variables are ${DB_ASN2_URL}
, ${DB_ASN2_USERNAME}
, and ${DB_ASN2_PASSWORD}
.
For my local development, I have set these environment variables using Windows Settings. You may need to replace these with actual environment variables. They should be provided with the txt file for assignment submission. If there are any issues, please contact me at kzcheng@sfu.ca.
Some commits may have more details in descriptions. They may be useful to provide more insight.
If you are interested in seeing more of my workflow, feel free to check out the GitHub Issue page and the GitHub Projects page of this assignment.
Work that are done will no longer be open, so remember to check not just the open Issues.
Throughout the commit history, you can see that all the work, including Bobby's tutorial on Spring Boot and Assignment 1 are all in the history of this Repo.
To find the beginning of Assignment 2, you can go to commit 840a809.