Week 6

 Week 6 (6/4-6/10)

Summary of this week's learning:

For lab 17, I learned to open a JDBC connection to course DB, turned off auto-commit, used a preparedStatement to insert the new student (with tot_cred = 0) and run executeUpdate() and print how many rows change, use another PreparedStatement to select id and name for that department and print each. And on success, call commit(); on error, call rollback() and close the connection.

For labs 18 and 19, I learned how to use Reverse Engineering and Forward Engineering to create a schema and an ER diagram. I learned how to use the model in MySQL and some other features to establish relationships between tables, and conducted an assessment or peer review with the other two classmates, where I was able to see different ER diagrams and designs and determine if they met the requirements. For Lab 19, I collaborated with my group to create a web application using Spring Boot, a Java-based framework, building upon the concepts introduced in Lab 18 (Prescription). I worked on ControllerPrescriptionCreate and filled out the forms with both existing ("lisinopril") and non-existent drugs ("funny pills").