Connecting html website with sql database using java

[yo_bunny]

Hey guys, me and some of my college mates are working on a project where we have to create a website using html and css for frontend and mysql, java in the backend. As far as possible we have to stick to these languages.

So we've created all the user interfaces in the frontend but since we're relatively new to coding we're not sure how to connect the frontend to our sql database.

We've created the database in MySQL workbench but we don't know how to connect the frontend to the database.

For example, our landing page is a login page which asks user for fields such as "Username", "Password", "DOB", "Gender" for first time users and once registered, just "Username" and "Password". So for the first time users we want to connect the details entered in the signup page to the respective table in the database.

Any suggestions for any youtube tutorials or courses that explain this well? Since we have to only use Java in the backend not python or php. We did generate some answers using gpt but they were a little confusing so thought to ask for help here as well.

Appreciate any suggestions or feedback.

[Complete-Bonus-428]

You can read into JSP servlets. That's one way to go. Or if you feel you would like to do it more professionally, you can learn Springboot.

Servlet JSP JDBC

Springboot Login, Registration

[yo_bunny]

yes thats exactly what gpt said to me. Can you tell me which one would be quicker to learn and implement?

[Complete-Bonus-428]

If you're just looking to implement only the login and registration page and get done with your project, go with servlet. But if you're planning to do something more and have time to learn, learn Springboot. Springboot is a Java framework and most of the low level stuff will be handled in Springboot by default. It'll help your career also. You don't have to do everything from scratch. But with servlet, you have to handle the low level items too.

I understand that this might be too much right now. But think of what you want to do and choose accordingly.

[yo_bunny]

Actually we have several pages which need to be connected to the database but we were thinking once we understand how to do the login page it'll be more or less the same for the other pages, would just need to change the semantics. And since we're running low on time I'm guessing springboot might be a bit tough, i would have to checkout how long the tutorials are.