DEV Community

loizenai
loizenai

Posted on

SpringBoot React Oracle CRUD Example

https://loizenai.com/springboot-react-oracle-crud-example/

SpringBoot React Oracle CRUD Example

Tutorial: SpringBoot + React + Oracle: Build CRUD Application with SpringBoot React.js Example

In the tutorial, I introduce how to build an “SpringBoot React.js CRUD Oracle Example” project with the help of SpringData JPA for POST/GET/PUT/DELETE requests with step by step coding examples:

– SpringBoot project produces CRUD RestAPIs with Oracle database using the supporting of Spring Data JPA.
– React.js project will consume the SpringBoot CRUD RestAPIs by Ajax then show up on Reactjs component’s views.

Related posts:


– I draw a fullstack overview Diagram Architecture from React.js Frontend to Oracle database through SpringBoot RestAPI backend.
– Develop SpringBoot CRUD RestAPIs with the supporting of SpringWeb Framework.
– Implement Reactjs CRUD application with Ajax fetching APIs to do CRUD request (Post/Get/Put/Delete) to SpringBoot Backend APIs.
– I create a testsuite with a number of integrative testcases with CRUD RestAPI requests from Reactjs to do CRUD requests to SpringBoot RestAPIs Server and save/retrieve data to Oracle database.

Overview Diagram Architecture - SpringBoot React Oracle (SpringBoot Reactjs CRUD Example)

Overall Architecture System: Reactjs + SpringBoot + Oracle

[caption id="attachment_3814" align="alignnone" width="653"]React.js SpringBoot Oracle Diagram Architecture React.js SpringBoot Oracle Diagram Architecture[/caption]

  • We build a backend: SpringBoot CRUD Application with Oracle that provides RestAPIs for POST/GET/PUT/DELETE data entities and store them in Oracle database.
  • We implement React.js CRUD Application that use Ajax to interact (call/receive requests) with SpringBoot CRUD application and display corresponding data in Reactjs Component.

SpringBoot Oracle CRUD Design Application

[caption id="attachment_3804" align="alignnone" width="614"]SpringBoot Oracle CRUD RestAPI Fullstack Diagram Architecture SpringBoot Oracle CRUD RestAPI Fullstack Diagram Architecture[/caption]

I build a SpringBoot project that handle all Post/Get/Put/Delete requests from RestClient and do CRUD operations to Oracle database to save/retrieve/update and delete entity from Oracle and returns back to Restclient the corresponding messages.

We build a SpringBoot project with 2 layers:
– SpringJPA Repository is used to interact with Oracle database by a set of CRUD operations.
– RestController layer is a web layer for SpringBoot project, it will directly handle all incomming requests and do the corressponding responses to the calling client.

Reactjs CRUD Application Design

[caption id="attachment_3805" align="alignnone" width="691"]Reactjs CRUD RestAPI Application Frontend Architecture Diagram Reactjs CRUD RestAPI Application Frontend Architecture Diagram[/caption]

– Reactjs CRUD Application is designed with 2 main layers:

  • React.js components let you split the UI into independent, reusable pieces, and think about each piece in isolation.
  • Ajax is used by Reactjs component to fetch (post/put/get/delete) data from remote restapi by http request

Reactjs CRUD Application defines 5 components:

  • Home.js is used serve as the landing page for your app.
  • AppNavbar.js is used to establish a common UI feature between components.
  • CustomerList.js is used to show all customers in the web-page
  • CustomerEdit.js is used to modify the existed customer
  • App.js uses React Router to navigate between components.

Integrative Project Goal

Reactjs Home page:

[caption id="attachment_3806" align="alignnone" width="481"]Project Goal - Home Page Project Goal - Home Page[/caption]

Reactjs add data:

[caption id="attachment_3807" align="alignnone" width="518"]Project Goal - Add a Customer Project Goal - Add a Customer[/caption]

Reactjs List all data:

[caption id="attachment_3808" align="alignnone" width="810"]Project Goal - Customer List Project Goal - Customer List[/caption]

Reactjs update data:

[caption id="attachment_3809" align="alignnone" width="524"]Project Goal - Update Customer Project Goal - Update Customer[/caption]

Reactjs delete data:

-> Delete a customer Adam with id=2, after successfully, check the customer list again:

[caption id="attachment_3810" align="alignnone" width="759"]Project Goal - List Customer after Delete successfully Project Goal - List Customer after Delete successfully[/caption]

Check Oracle Database after do CRUD operations:

[caption id="attachment_3811" align="alignnone" width="805"]Check Oracle records after do CRUD operation Check Oracle records after do CRUD operation[/caption]

How to Integrate Reactjs with SpringBoot?

For starting to integrate Reactjs with SpringBoot project, I recommend you a previous post with detail steps to pratice:

More at:

https://loizenai.com/springboot-react-oracle-crud-example/

SpringBoot React Oracle CRUD Example

Top comments (0)