Question

Exercises

Summary
Create a secure system which uses a database to store users with salted passwords. Use your database users for authentication.
Note: once again, I hope you’ll play with this code and build it up on your own, rather than simply looking at mine! As such, no lecture code is provided today. See the lecture and ask if you’re stuck!
Exercises
Copy your exercises from last time and rename the project ex91_securityWithDatabase. I dont have that exercise
Following the lecture in class, modify your code to use H2 for user storage – instead of our hard-coded examples from last time.
This is honestly about as tricky as it gets, so spend your time wisely and try it! It’s pretty amazing to watch it fly! Make it go!
When you get it done, take a screenshot of your H2 Console with the users in your Users table showing! Take a second screenshot of your secure page after you log in! Please submit the screenshots to SLATE here.

Answer 1

To create a secure system with user authentication using a database, integrate H2 database drivers, create a Users table, hash passwords with salts, and verify user credentials during login. Configure your web application to safely store and authenticate user data.

Step-by-step explanation:

To create a secure system that uses a database to store users with salted passwords and authenticates using these details, start by setting up an H2 database. Implement user authentication by modifying your existing project code as follows:

• Integrate the H2 database drivers with your project.
• Create the Users table in the H2 database to store user details such as username, salted password, and the salt itself.
• Use a cryptographic library to generate salts and hash passwords before storing them in the database.
• When a user attempts to log in, retrieve the corresponding salt and hashed password from the database and verify the credentials.

Ensure that your project is configured correctly by verifying that the users are stored in the database with their hashed passwords and salts. Once implemented, your web application should allow users to securely log in with their credentials backed by your new H2 database implementation.

When you have successfully completed the adaptation, take screenshots of your H2 console showing the Users table and of your secure page after logging in. Submit these screenshots as proof of your work.