RESTful Web Services, Java, Spring Boot, Spring MVC and JPA

Learn to download the MySQL community server for Mac, run the installer, and set a secure admin password to log in and start the MySQL server.

Start and manage a MySQL 8.0.11 server on macOS using the terminal, with commands to start, stop, restart, log in as root, and troubleshoot common issues.

Create a new MySQL database and a dedicated user, grant privileges, and leverage Hibernate and Spring Data JPA to auto-create tables from Java entity objects.

Learn how to download, install, and start MySQL Workbench, a graphical tool to manage MySQL databases, create tables, and run SQL queries efficiently.

Create a new MySQL Workbench connection named Photo App, test the connection with user Sergei and saved credentials. Update the user password encryption and restart the server to sign in.

Explore a brief overview of mysql workbench as a flexible gui tool for connecting to mysql databases, opening a workspace, and executing sql commands.

Install the Java development kit (JDK) on your Mac, verify the installation with java -version, and set the java_home environment variable to prepare for Java-based RESTful web services development.

Download and install Spring Tool Suite, an eclipse-based development environment customized for Spring applications, to develop, debug, run, and deploy restful web services with Spring and Spring Boot.

Create a new Spring Boot project in Spring Tool Suite, selecting workspace, configuring group and artifact, and adding the web dependency via Maven. Understand the pom.xml and project structure.

Create a new Spring Boot project quickly with Spring Initializr, selecting Maven, Java, and the Web dependency to enable RESTful web services, then import into your preferred IDE.

Create rest controller in a spring boot app to handle user operations via /users endpoints. Define methods with Rest controller and Request mapping to receive HTTP requests and send responses.

Define a basic restful web service with get, post, put, and delete mappings to manage user data, returning strings initially and planning json payloads for a mobile app.

Learn to run a Spring Boot web service, with embedded Tomcat, and test crud operations on /users using Postman, guided by Spring annotations.

Build a restful web service with a MySQL database using Spring Data JPA and the MySQL Connector, wired through pom.xml and Maven dependencies.

Configure spring data jpa by editing application.properties with the MySQL username and password, data source url (localhost:3306) and the database name Photo app, and set hibernate ddl auto to update.

Handle http post requests by reading the Json body with a request body annotation, letting the framework convert Json to a Java object, and persist the data.

Create a user details request model with fields first name, last name, email, and password, exposing getters and setters to map incoming JSON to a Java object.

Create a new java class as a response model in a dedicated package to return a json payload with public user ID, first name, last name, and email.

Create a shared user DTO for UI, database, and service layers; implement serializable with serialVersionUID and include fields like id, userId, firstName, lastName, email, password, and email verification status.

Map the request body to a user dto with BeanUtils, invoke the user service to create the user, and return a user rest containing the new id.

Create a user service interface and its implementation to handle creating a user via a user DTO. Wire the service into the controller and organize classes into a service package.

Create a serializable user entity class in data layer to persist user details to a MySQL table, with fields like id, userId, firstName, lastName, email, and emailVerificationStatus using JPA annotations.

Set a reliable default for email verification status by explicitly assigning false in the entity and the user DTO, avoiding non-portable column definitions across databases.

Create a user repository interface that extends CrudRepository for basic CRUD on the user entity. Annotate with Repository and optionally add a method to find by email address.

wire the user repository into the service, copy properties from a user dto to a user entity using BeanUtils, and save to the database, returning a user dto.

Post a json body to the users endpoint to create a new user; the payload maps to a user details model and saves to MySQL, returning a 200 status.

Enforce a unique constraint on the email field with @Column(unique=true) to prevent duplicate user records, and test with postman while preparing user-friendly error handling for Spring boot restful services.

Check for existing users by email, using a find by email method; if found, throw a runtime exception 'record already exists' and let Spring Boot format JSON or XML.

Generate a secure, random 30-character alphanumeric public user ID to identify records in the database and return it in JSON or XML responses to calling clients.

Add spring security to a spring boot project by including the spring boot security starter in pom.xml, enabling secured endpoints and login via generated password, and JSON web token support.

Implement a bcrypt password encoder bean from the Spring framework security crypto package, wire it into the user service, and encrypt the user password before storing it in the database.

Configure spring security to make the sign-up endpoint public while protecting all other endpoints, using a custom user service and bcrypt encoding with a web security config.

Migrate from the deprecated web security configure adapter by configuring http security with a bean, disable csrf for a stateless rest api, and permit http post /users.

Create a Java login request model to map sign-in json with email and password, generate getters and setters, and prepare authentication in the api.

Implement loadUserByUsername to fetch user details from the database, throw username not found when absent, and return a Spring Security user with an encrypted password and empty authorities.

Create a security constants class to hold JWT values like expiration time, token prefix, authorization header, signup path, and token secret, ready for use by the authentication filter.

Add Maven dependencies to the pom.xml, including JWT API, JWT implementation, and Jackson, to enable generating a JWT access token in the next lesson.

Build and wire an authentication filter for login requests by extending the username password authentication filter, reading username and password from a JSON payload, and delegating to the authentication manager.

Implement the successfulAuthentication method to generate a JWT access token using the authenticated user's username, sign it with a secret key, and return it in the HTTP response header.

Register the authentication filter with the HttpSecurity configuration, build a custom authentication manager, wire it into the security chain, and run the app to verify.

Explore how a Spring Boot application authenticates users and returns a jwt access token via the default /login endpoint, wiring the authentication filter, load user by username, and successful authentication.

Add user id to the http response header after login, enabling use of the authorization JWT access token and public user id in subsequent requests within a spring boot app.

Customize the login path by configuring a custom authentication filter in spring security, replacing the default /login with a new path such as /users/login and verifying a 200 response.

Implement a custom authorization filter that reads the json web token from the authorization header, validates it, and populates the security context for protected endpoints in a stateless setup.

Run a spring boot app and test user authorization with a JWT token, showing that post /users is public while protected endpoints require a valid authorization header.

Read the token secret from application properties using Spring's environment, replacing hardcoded values. Define the token secret in application.properties and access it via a getTokenSecret method in the authorization filter.

Read the user id from the url path parameter and return a user details object with id, first name, last name, and email.

Implement a service layer method to get a user by user ID, returning a user data transfer object from the repository. Handle null results and copy properties to the DTO.

Add a find by user id method to the user repository, using Spring Data JPA to auto-generate the SQL query and return a user entity.

Run and debug get user details by user ID flow, verify path variable, and fetch user via repository; then authenticate with JWT to call protected API.