GitHub Repositories

viladoms2022books

1. myfirstprojectspring : first project created on Spring Boot to test and play with Spring Boot and API Rest

   1. Class Book

   2. Class Movie

   3. MVC: @Controller, @RestController, and fake @Service

   4. Web App: @Controller and ThyemLeaf engine Template: web.html

   5. POM

   6. Project Folder Tree

2. libraryRest : Project Spring Boot with only an HTTP connection to CRUD API Rest

   1. @RestController and

   2. fake @Service

   3. All CRUD Operations upon ArrayList.

   4. POM

   5. Project Folder Tree

3. libraryRest2 : Project Spring Boot with only an API Rest and new features to complete the project

   1. @RestController and

   2. fake @Service

   3. CommandLineRunner operating upon @Service

   4. All CRUD Operations upon ArrayList on CommandLineRunner

   5. ResponseEntity on @RestController response return

   6. Security-starter on

      1. POM dependency and

      2. Application.properties user and password configuration

   7. @Valid for validation Book Object

      1. on createBook parameters and

      2. and @NotBlank annotation

   8. POM

   9. Project Folder Tree

4. libraryWeb : Project Spring Boot with only a Web App

   1. Template Engine: Thymeleaf, web.html:

   2. Model/ModelAndView container-object on @Controller and

   3. fake @Service

   4. All CRUD Operations upon ArrayList

   5. Project Folder Tree

javaSpringBoot_Viladoms

1. libraryH2Command : first project with only H2 DB JDBC Java Dependency and JPA DATA

   1. H2 Java Database, SQL

      1. Be CAREFUL : you must use version 1.4.99 H2 DB windows installer or platform-independent

   2. JPA

   3. @Entity Book

   4. Interface CrudRepository <Book, String>

      1. @id of @Entity Book is Title, as string

   5. CommandLineRuner

      1. we use CommandLineRunner to test H2 DATABASE CRUD

      2. we use @Component

   6. fake @Service

   7. Application.properties

      1. H2 DATABASE configuration datasource (url, username, password, driver)

         1. spring.datasource.url=jdbc:h2:tcp://localhost/~/h2/library

         2. spring.datasource.username=albert

         3. spring.datasource.password=1234

         4. spring.datasource.driver-class-name=org.h2.Driver

      2. Choose dialect

         1. H2Dialect or MySQL5Dialect

      3. and Initialize a database using JPA DDL enum:

         1. docs.spring.io

         2. spring.getdocs.io

         3. DDL enum cases

   8. POM : dependencies

      1. JPA DATA: spring-boot-starter-data-jpa and

      2. H2 DATABASE: com.h2database

   9. Project Folder Tree

2. libraryH2Command2 : copy from the first project just to add an AUTO-GENERATED ID

   1. with only H2 DB JDBC Java Dependency and JPA DATA

   2. @Entity Book

   3. Interface CrudRepository <Book, Integer>

      1. @id of @Entity Book is Title, as Integer

3. customer : project with H2 DB JPA and all CRUD operations

   1. with H2 DB JDBC Java Dependency and JPA DATA

   2. @Entity Customer

   3. Interface CrudRepository <Customer, String>

      1. @id of @Entity Customer is id, as String

   4. Application.properties

   5. All CRUD Operations:

      1. get : findAll

      2. create : save

      3. delete : findAndDeleteById

      4. delete : deleteById

      5. update : update

      6. count : count

      7. existsById : existsById

      8. countByLastname : countByLastname (derived count query)

      9. deleteByLastname : deleteByLastname (derived delete query)

4. libraryH2Command3 JPA @ManyToOne Unidirectional owning-side Many between @Entity User (reverse or not-owning side) and @Entity Book (owning side)

   1. Core Concepts JPA and JPA mapping annotations

      1. @ManyToOne

      2. Unidirectional or bidirectional

      3. Be CAREFUL : compatibility matrix of versions JAVA, JPA and Hibernate ORM

   2. H2 Java Database, SQL: Be CAREFUL : you must use version 1.4.99 H2 DB windows installer or platform-independent

   3. Mapping entities JPA :

      1. User <1:n> Book

   4. @Entity Book and @BookService. User @Entity and @UserService (all CRUD operations)

      1. Interface UserRepository <User, String> and @id of @Entity User is id, as string

      2. Interface BookRepository <Book, String> and @id of @Entity Book is id, as string

   5. CommandLineRuner : we use @Component

   6. Application.properties

      1. H2 DATABASE configuration datasource (url, username, password, driver)

      2. Choose dialect: H2Dialect or MySQL5Dialect

      3. and Initialize a database using JPA DDL enum : DDL enum cases

   7. POM : dependencies

      1. JPA DATA: spring-boot-starter-data-jpa and

      2. H2 DATABASE: com.h2database

   8. Project Folder Tree

5. libraryH2Command4 JPA @ManyToOne and @OneToMany Bidirectional between @Entity User (not-owning side) and @Entity Book (owning side)

   1. Core Concepts JPA and JPA mapping annotations with JPA H2 DB Applications.properties

   2. Mapping entities JPA :

      1. User <1:n> Book

   3. Entities with all CRUD operations

      1. @Entity Book , BookService @Service and BookRepository.

      2. @Entity User , UserService @Service and UserRepostiory.

   4. CommandLineRuner : we use @Component

   5. Be CAREFUL : there is a tricky game here to make bidirectional solution useful in this particular case: user-book(physical one)

   6. Be CAREFUL : don't print books from user.toString() by a default toString() cause you will create a recursive nightmare! Better to leave a simple toString() but if you are a brave programmer, try it!

6. libraryH2Command5 JPA @ManyToMany by @JoinTable between @Entity Author (owning side) and @Entity Book (inverse not-owning side)

   1. Core Concepts JPA and JPA mapping annotations with JPA H2 DB Applications.properties

   2. Mapping entities JPA :

      1. User <1:n> Book <n:m> Author

   3. Entities with all CRUD operations

      1. @Entity Book , BookService @Service and BookRepository.

      2. @Entity User , UserService @Service and UserRepostiory.

      3. @Entity Author, AuthorService, @Service and AuthroRepostiory.

   4. CommandLineRuner : we use @Component

7. libraryH2Command6 JPA @ManyToMany by @Entity Borrows between @Entity User (owning side) and @Entity Book (inverse not-owning side)

   1. Core Concepts JPA and JPA mapping annotations with JPA H2 DB Applications.properties

      1. UML example

   2. Mapping entities JPA

      1. User <1:n> Borrow <n:1> Book <n:m> Author

      2. User <n:m> Book

   3. Entities with all CRUD operations :

      1. @Entity Book , BookService @Service and BookRepository.

      2. @Entity User , UserService @Service and UserRepository.

      3. @Entity Author, AuthorService, @Service and AuthorRepostiory.

      4. @Entity Borrow, BorrowService, @Service and BorrowRepostitory.

   4. CommandLineRuner : we use @Component

   5. New package order : Project Folder Tree

1. employee MongoDB NoSQL and Spring Boot JSON and BSON data to Mongo Atlas Cloud.

   1. Core Concepts and examples Spring Boot and MongoDB

   2. Connection to DB Cloud

      1. String Connection to DB: user, password, allowed IP

         1. mongodb+srv://<username>:<password>@clustertest.0h8fd.mongodb.net/myFirstDatabase?retryWrites=true&w=majority

         2. #Replace <password> with the password for the <username> user. Replace myFirstDatabase with the name of the database that connections will use by default. Ensure any option params are URL encoded.

      2. Application.properties

         1. spring.data.mongodb.uri=mongodb+srv://springbootviladoms:122344@clustertest.0h8fd.mongodb.net/employeeD

   3. POM dependencies

   4. Collection and document MongoDB:

      1. @Document : employee

      2. Repository : employeeRepository

      3. (in this example there is NO service)

   5. CommandLineRunner

      1. testing all CRUD operations with employeeRepository, this is a very bad practice because of :

         1. loose-tight coupling

         2. DDD (Domain-driven Design)

         3. microservices

      2. testing response-time cloud-latency for all CRUD operations : output

   6. Project Folder Tree

2. employee2 MongoDB NoSQL and Spring Boot CRUD operations JSON and BSON data to Mongo Atlas Cloud.

   1. Core Concepts and examples Spring Boot and MongoDB

   2. Connection to DB Cloud:

      1. Application.properties

         1. spring.data.mongodb.uri=mongodb+srv://springbootviladoms:1234@clustertest.0h8fd.mongodb.net/employeeDB

   3. POM dependencies

   4. Collection and document MongoDB:

      1. @Document : employee

      2. Repository : employeeRepository

      3. @Service : employeeService

   5. CommandLineRunner

   6. Project Folder Tree

3. employee3 MongoDB Image NoSQL and Spring Boot CRUD operations JSON and BSON data to Mongo Atlas Cloud.

   1. Core Concepts and examples Spring Boot and MongoDB

      1. Query methods

      2. Mongo repositories

   2. Connection to DB Cloud

      1. Application.properties

   3. POM dependencies

   4. Collection and document MongoDB:

      1. @Document : employee and employeeImages

      2. Repository : employeeRepository and employeeImagesRepository

      3. @Service : employeeService

   5. employeeImagesController API Rest @RestController

   6. CommandLineRunner

   7. Project Folder Tree

4. employee4 MongoDB NoSQL and Spring Boot CRUD operations JSON and BSON data to Mongo Atlas Cloud with JAVA FAKER and @Query derivades

   1. Core Concepts and examples Spring Boot and MongoDB

   2. Connection to DB Cloud: Application.properties

      2. 1. spring.data.mongodb.uri=mongodb+srv://springbootviladoms:1234@clustertest.0h8fd.mongodb.net/employeeDB

   3. JAVA Faker

   4. POM dependencies

      1. Java Faker Dependency

<dependency>

<groupId>com.github.javafaker</groupId> <artifactId>javafaker</artifactId>

<version>1.0.2</version>

</dependency>

4. 5. Collection and document MongoDB:

      1. @Document : employee

      2. Repository : employeeRepository

         1. Query MongoDB Data, Query in Atlas/Compass and @Query annotation in Spring Boot

@Query("{age: {$gt : ?0}}")

List<Employee> findItemByAge(int age);

4. 6. CommandLineRunner

   7. Project Folder Tree

   8. Output

5. employeeDynamoDB AWS DynamoDB NoSQL and Spring Boot CRUD operations. Tests are done by Junit 5

   1. Core Concepts and examples Spring Boot and DynamoDB

      1. Dates are formatted as a long number, epoch format.

   2. Connection to DB Cloud:

      1. Configuration: DynamoDBConfiguration

      2. Application.properties for local storage of pair-keys, Access keys (access key ID and secret access key) from AWS Amazon Security Credentials:

         1. amazon.aws.accesskey=AKIA56F5DT6J4PVJNNUT

         2. amazon.aws.secretkey=96TDFD4hqty7kuyQS33aCVDFKVTRy665FGffERATcp

(keys are FAKE)

5. 3. POM dependencies

<dependencyManagement>

<dependencies>

<dependency>

<groupId>org.springframework.data</groupId>

<artifactId>spring-data-releasetrain</artifactId>

<version>Lovelace-SR16</version>

<type>pom</type>

<scope>import</scope>

</dependency>

</dependencies>

</dependencyManagement>

<dependency>

<groupId>com.amazonaws</groupId>

<artifactId>aws-java-sdk-dynamodb</artifactId>

<version>1.11.64</version>

</dependency>

<dependency>

<groupId>com.github.derjust</groupId>

<artifactId>spring-data-dynamodb</artifactId>

<version>5.1.0</version>

</dependency>

5. 4. Objects DynamoDB:

      1. Bean @DynamoDBTable(tableName = "Employee") : employee

      2. @EnableScan Repository : employeeRepository

      3. @Service : employeeService

   5. EmployeeApplicationTests

   6. Project Folder Tree

1. demoLogin API WebSocket STOMP client Login and Spring Boot

   1. Client Websocket (/resources/static):

      1. JS

      2. HTML

      3. CSS

   2. Application.properties

   3. POM dependencies

   4. Model :

      1. Login

      2. LoginResponse

   5. Controller: LoginController

   6. Websocket configuration : WebsocketConfig

   7. Project Folder Tree

2. securityDemo2 Security-starter, Spring Web/Thymeleaf (HTML/JS/CSS templates) and H2 in memory (data.SQL, BCryptPasswordEncoder())

   1. Client Web (Thymeleaf injection web):

      1. hello.html

      2. home.html

      3. login.html

   2. Application.properties

   3. POM dependencies

   4. data.SQL

      1. password MUST be encrytped: https://bcrypt-generator.com/

   5. Model :

      1. Customer.java

      2. CustomerRepository.java

   6. Service : CustomerUserDetailService.java

   7. Configuration:

      1. WebSecurity : WebSecurityConfig

      2. MvcConfig : MvcConfig.java

   8. Project Folder Tree

3. customerThymeleaf Spring Web/Thymeleaf (HTML/JS/W3.css) and MongoDB with Employee document

   1. Client Web (Thymeleaf injection web):

      1. index.html

      2. qrweb.html

      3. home.html

      4. notFound.html

      5. employees.html

   2. POM dependencies

   3. Model :

      1. Empoyee.java

      2. EmpoyeeRepository.java

      3. EmpoyeeController.java

   4. Configuration QR:

      1. QRCodeController.java

      2. QRService.java

      3. QRServiceImpl.java

   5. Project Folder Tree

4. libraryRestH2Mongo MongoDB Image NoSQL and H2 SQL and Spring Boot CRUD operations JSON with API REST

   1. H2 Java Database, SQL

   2. Connection to H2 local

      1. Application.properties

   3. POM dependencies

   4. Model : author, book, borrow and user

   5. Controller: userRestController

   6. Repository : author, book, borrow and user

   7. Service : author, book, borrow and user

   8. Project Folder Tree

5. libraryRestH2Mongo2 MongoDB Image NoSQL and H2 SQL and Spring Boot CRUD operations JSON and BSON data to Mongo Atlas Cloud and H2 local storage with API REST

   1. Core Concepts and examples Spring Boot and MongoDB

   2. H2 Java Database, SQL

   3. Connection to DB Cloud and H2 local

      1. Application.properties

   4. POM dependencies

   5. Model : author, book, borrow, user and userImage

   6. Controller:

      1. userRestController

      2. UserImagesController.java

   7. Repository : author, book, borrow, user and userImages

   8. Service : author, book, borrow and user

   9. Project Folder Tree

6. libraryRestH2Mongo3 MongoDB Image NoSQL and H2 SQL and Spring Boot CRUD operations JSON and BSON data to Mongo Atlas Cloud and H2 local storage with API REST and WebSocket STOMP client.

   1. Core Concepts and examples Spring Boot and MongoDB

   2. H2 Java Database, SQL

   3. Client Websocket (/resources/static):

      1. JS

      2. HTML

      3. CSS

   4. Connection to DB Cloud and H2 local

      1. Application.properties

   5. Configuration WebSockekConfig class Stomp Websocket : enpoints and registry.

   6. POM dependencies

      1. WebJar Dependencies

      2. Websocket dependencies

   7. Model :

      1. author, book, borrow, user and userImage

      2. Websocket textMessage

   8. Controller:

      1. userRestController

      2. UserImagesController.java

      3. MessageController

   9. Repository : author, book, borrow, user and userImages

   10. Service : author, book, borrow and user

   11. Project Folder Tree