CST 363 - Week 6

Lab 17 - 

In this lab, I learned how to connect a Java program to a MySQL database using JDBC. I handled user input, inserted data safely with checks for duplicates and valid departments, and used transactions with commit and rollback. I also tested everything from both Java and the MySQL terminal to make sure it worked as expected.

Lab 19 - Group Project

Our group built a prescription management system using Spring Boot and MySQL. I worked on the patient update controller, where I handled retrieving the patient's current info, displaying it in a form, validating the doctor’s name, and updating the patient's address and assigned doctor in the database. We also created tables for doctors, patients, drugs, pharmacies, prescriptions, and inventory. Then we wrote Java controllers to handle registering and updating doctors and patients, creating prescriptions, and validating input.

Comments

Post a Comment

Popular posts from this blog

Week 4 - Educational & Career Goals, ETS Readiness, and Learning Reflections

Part One: Educational Goals My goal in the CS program is to develop a good foundation in software development which specifically includes front-end and back-end technology. I also want to get a really good understanding of algorithms and develop problem solving skills. Programming languages are another important part of this plan. In fact, that is the essence of CS. I’ve done C++, Python, Java, Javascript and other languages, but want to revise them all again and this time create a nice portfolio utilizing some of the languages. The next goal is to hopefully land internships or full-time entry jobs to get real-world experience. All this is while attaining my bachelors. Part Two: Career Goals I want to start now in terms of career goals meaning that I want to start getting experience as soon as possible. This means I have to get into an entry level job and build from there. Something attainable can be taking courses on UI/UX design and get a career related to that. As I get used to that...
Read more

Week 2 - Learning Strategies | Time Management | Project Management | Previous Capstones | Week Summary

Image
Learning Strategies Top 3 Study Skills I'm Good At: Following the SQ3R method: Survey | Question | Read | Recite   |   Review I didn't even know I followed this until I examined myself with it.  Minimizing Distractions While Studying: I’m good at selecting quiet, distraction-free environments like my study room at the corner of my house so not many people walk by throughout the day allowing me to focus deeply on the material. Looking for main ideas in paragraphs and extracting key details. Top 3 Areas I Need to Improve On: Creating/Following a Schedule:  I am not good at creating a schedule and even worse at following it. I'll try it for a day but then things pop up and I get inconsistent. I feel like I can't keep a good schedule when studying formally like school. However, this class is training us like we are working a job. Therefore, it is getting easier to follow a schedule as if we are needing to meet deadlines so I am enjoying it.  Time...
Read more

Week 5 - Team Comments, Capstone Ideas, Weekly Journal, Industry Expert Interview

Image
  Part One: Team Comments  Comment for Jian:  Jian's Week 4 Journal Comment for Noah:  Noah's Week 4 Journal   Part Two: Capstone Ideas 1. User-friendly appointment booking system for small businesses - Many small businesses have a hard time with inefficient and difficult scheduling systems. This project would create a simple, mobile-friendly appointment booking system with features like automatic reminders and calendar, significantly improving customer experience and reducing no-shows.  2. Smart navigation system or app for public spaces - Many people struggle with navigating crowded places like malls, airports, or large events. This project would create a user-friendly mobile app that provides real-time navigation indoors, showing the least crowded paths based on foot traffic data. It could also include accessibility-friendly routes for users with disabilities, improving overall user experience and convenience. 3. AI-powered smart form auto...
Read more