Learning Journal Week 6 CST 363

This week I learned how to connect a Spring Boot web application to a MySQL database and make them work together. At first, it was a little hard to understand how the data moves between the webpage, the controller, and the database, but after practicing, it started to make more sense. I learned how to use forms to collect information from the user and then send it to the backend, where it is processed and shown back using templates.

In our group project, I worked on Step 8, which was about filling a prescription. This part was a little confusing at first because there were many things to check, like making sure the pharmacy, patient, and prescription all exist in the database. I also had to calculate the cost of the prescription and check the number of refills. It took me a while to understand how SQL joins and validation work, but after testing the program and fixing errors, I finally got it to run correctly.

I also learned about handling transactions and error messages so that the data stays correct even if something goes wrong. Seeing the form connect with the controller and update the database was exciting because I could see all the parts working together. Overall, this week was a bit challenging, but I learned a lot about backend and frontend connections, and I feel more confident using Spring Boot and MySQL now.