Spring MVC CRUD + Spring Boot + Oracle + Thymeleaf

Hi All,

Greeting of the day!

Today we will be building Spring MVC CRUD application using spring boot and Thymeleaf, so let's start.

First, we will create a basic project structure using Spring initializr and will add the below dependency.

 

Additionally, we will add oracle dependency in pom.xml

<dependency>

<groupId>oracle</groupId>

<artifactId>ojdbc6</artifactId>

<version>11.2.0.3</version>

</dependency> 

So below will be complete pom.xml

<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>2.3.3.RELEASE</version> <relativePath/> <!-- lookup parent from repository --> </parent> <groupId>com.demo.book</groupId> <artifactId>BookMgt</artifactId> <version>0.0.1-SNAPSHOT</version> <name>BookMgt</name> <description>Demo project for Spring Boot</description> <properties> <java.version>1.8</java.version> </properties> <dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-data-jpa</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>oracle</groupId> <artifactId>ojdbc6</artifactId> <version>11.2.0.3</version> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-thymeleaf</artifactId> </dependency> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> <optional>true</optional> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> <exclusions> <exclusion> <groupId>org.junit.vintage</groupId> <artifactId>junit-vintage-engine</artifactId> </exclusion> </exclusions> </dependency> </dependencies> <build> <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> </plugin> </plugins> </build> </project>

In the end, we will have below project structure

Now add below database-related properties in the application.properties

spring.datasource.url=jdbc:oracle:thin:@localhost:1521:orcl

spring.datasource.username=username

spring.datasource.password=password

spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver

spring.jpa.hibernate.ddl-auto=update

Now we will create a model class Book for our application which will be mapped to a database table.

package com.demo.book.model; import lombok.*; import javax.persistence.*; import java.math.BigDecimal; @Entity @Setter @Getter @AllArgsConstructor @NoArgsConstructor @ToString @Table(name = "Books") public class Book { @Id @GeneratedValue(strategy = GenerationType.SEQUENCE,generator = "book_id_seq") @SequenceGenerator(name = "book_id_seq",sequenceName = "book_id_sequence") @Column(name = "Book_Id") private long bookId; @Column(name = "Book_Title") private String bookTitle; @Column(name = "Book_Author") private String bookAuthor; @Column(name = "Book_Price") private BigDecimal bookPrice; }

Now table will be created automatically as we have mentioned spring.jpa.hibernate.ddl-auto=update in the application.properties.

We need to create a sequence in oracle which we have mentioned in Book.java.And for that, we need to execute the below scripts 

Create sequence book_id_sequence;

Now we will create a repository layer for our application using JpaRepository.

package com.demo.book.repository; import com.demo.book.model.Book; import org.springframework.data.jpa.repository.JpaRepository; import org.springframework.stereotype.Repository; @Repository public interface BookRepository extends JpaRepository<Book,Long> { }

Now let's create a service layer, where you can add your business logic and code to manage transactions.

package com.demo.book.service; import com.demo.book.model.Book; import com.demo.book.repository.BookRepository; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.util.List; import java.util.Optional; @Service public class BookService { @Autowired private BookRepository bookRepository; public void storeBook(Book book){ bookRepository.save(book); } public List<Book> viewBooks(){ return bookRepository.findAll(); } public void deleteBook(Book book){ bookRepository.delete(book); } public Optional<Book> viewBook(long bookId){ return bookRepository.findById(bookId); } }

Now we will create Controller i.e BookController.java, here we will create methods to handle 

redirections, along with operations to create, edit, view, and update.

For display purposes, we are using Thymeleaf. So from the controller, we will return the name of the page which will be under resources/templates for the view layer.

After adding, updating & deleting the book we have called redirect for viewbook. 

For displaying data in view page using thymeleaf we will set data in model 

eg model.addAttribute("books",books);

package com.demo.book.controller; import com.demo.book.model.Book; import com.demo.book.service.BookService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import java.util.List; import java.util.Optional; @Controller @RequestMapping("/book") public class BookController { @Autowired private BookService bookService; @RequestMapping(value="/viewBook",method = RequestMethod.GET) public String viewBooks(Model model){ List<Book> books=bookService.viewBooks(); model.addAttribute("books",books); return "view_books"; } @RequestMapping(value = "/addBook",method = RequestMethod.GET) public String showAddBookForm(Book book){ return "add_book"; } @RequestMapping(value = "/addBook",method = RequestMethod.POST) public String storeBook(Book book){ bookService.storeBook(book); return "redirect:/book/viewBook"; } @RequestMapping(value = "/deleteBook/{id}",method = RequestMethod.GET) public String deleteBook(@PathVariable("id") long id){ Optional<Book> book=bookService.viewBook(id); if(book.isPresent()){ bookService.deleteBook(book.get()); } return "redirect:/book/viewBook"; } @RequestMapping(value = "/editBook/{id}",method = RequestMethod.GET) public String editBook(@PathVariable("id") long id,Model model){ Optional<Book> book=bookService.viewBook(id); if(book.isPresent()){ model.addAttribute("book",book); } return "add_book"; } @RequestMapping(value="/",method = RequestMethod.GET) public String viewAllBook(Model model){ return "redirect:/book/viewBook"; } }

Lastly, we will create an HTML page for adding and viewing books. We are using add_book.html for both adding and editing books.

So let's create add_book.html for adding and editing the book

<!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml" xmlns:th="http://www.thymeleaf.org"> <head> <meta charset="utf-8" /> <title>Create New Product</title> </head> <body> <form action="#" th:action="@{/book/addBook}" th:object="${book}" method="post"> Book Title : <input type="text" th:field="*{bookTitle}" id="bookTitle" placeholder="Book Title"> Book Author:<input type="text" th:field="*{bookAuthor}" id="bookAuthor" placeholder="Book Author"> Book Price:<input type="number" th:field="*{bookPrice}" id="bookPrice" placeholder="Book Price"> <input type="hidden" th:field="*{bookId}"> <input type="submit" value="Add/Update Book"> </form> </body> </html>

Now we will create view_books.html under templates folder for viewing books that we have added. As we have set list of books to books mode attribute in controller using model.addAttribute("books",books);

We will iterate over books variable using th:each as shown below to create new row for each book.

<!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml" xmlns:th="http://www.thymeleaf.org"> <head> <meta charset="utf-8" /> <title>Create New Product</title> </head> <a class="btn btn-info" href="/book/addBook">Add Book</a> <body> <div th:switch="${books}"> <div th:case="*"> <h2>Books</h2> <table border="1px solid black;"> <thead> <tr> <th>Name</th> <th>Email</th> <th>Price</th> <th>Edit</th> <th>Delete</th> </tr> </thead> <tbody> <tr th:each="book : ${books}"> <td th:text="${book.bookTitle}"></td> <td th:text="${book.bookAuthor}"></td> <td th:text="${book.bookPrice}"></td> <td><a th:href="@{/book/editBook/{id}(id=${book.bookId})}">Edit</a></td> <td><a th:href="@{/book/deleteBook/{id}(id=${book.bookId})}">Delete</a></td> </tr> </tbody> </table> </div> </div> </body> </html>

So congratulations you have completed the sample CRUD application using spring MVC and spring boot.

Below is output

Also, you can refer to CRUD examples

Spring Boot JDBC Template CRUD Operation

Spring Boot REST API Export To Excel Using Apache POI

Spring Boot CRUD+ PostgreSQL + Spring Data JPA

Spring Rest API + CRUD Example + Spring Boot + Oracle Database + Spring JPA

Hibernate CRUD Example Using JSP & Servlet + MySQL + Maven

Java JDBC CRUD Example + Using JSP & Servlet + MySQL

 

Thanks

Happy Learning!