Angular 4 + Spring JPA + MySQL example | Angular 4 Http Client – Spring Boot RestApi Server

In this tutorial, JavaSampleApproach shows you Angular 4 Http Client & Spring Boot Server example that uses Spring JPA to interact with MySQL and Angular 4 as a front-end technology to make request and receive response.

Related Posts:
How to use Spring JPA MySQL | Spring Boot
Spring JPA + MySQL + AngularJS example | Spring Boot
How to use Angular Http Client to fetch Data from SpringBoot RestAPI – Angular 4
How to use Angular HttpClient to POST, PUT, DELETE data on SpringBoot Rest APIs – Angular 4

I. Technologies

– Java 1.8
– Maven 3.3.9
– Spring Tool Suite – Version 3.8.4.RELEASE
– Spring Boot: RELEASE
– Angular 4

II. Overview

angular-http-service-architecture

1. Spring Boot Server

angular-4-spring-jpa-mysql-spring-boot-architecture

For more details about Spring JPA – MySQL, please visit:
How to use Spring JPA MySQL | Spring Boot

2. Angular 4 Client

angular-4-spring-jpa-postgresql-angular-architecture

For more details:
– About Angular 4 Routing:
How to work with Angular Routing – Spring Boot + Angular 4
– About Angular Http Client to GET/POST/DELETE:
+ How to use Angular Http Client to fetch Data from SpringBoot RestAPI – Angular 4
+ How to use Angular HttpClient to POST, PUT, DELETE data on SpringBoot Rest APIs – Angular 4

III. Practice

1. Project Structure

1.1 Spring Boot Server

angular-4-spring-jpa-mysql-spring-boot-structure

– Class Customer corresponds to entity and table customer, it should be implemented Serializable.
CustomerRepository is an interface extends CrudRepository, will be autowired in CustomerController for implementing repository methods and custom finder methods.
CustomerController is a REST Controller which has request mapping methods for RESTful requests such as: getAll, postCustomer, delete, findByLastName.
– Configuration for Spring Datasource and Spring JPA properties in application.properties
Dependencies for Spring Boot and MySQL in pom.xml

1.2 Angular 4 Client

angular-4-spring-jpa-postgresql-angular-structure

In this example, we focus on:
– 4 components: customers, customer-details, create-customer, search-customer.
– 3 modules: FormsModule, HttpModule, AppRoutingModule.
customer.ts: class Customer (id, firstName, lastName)
data.service.ts: DataService for Http Client methods
proxy.conf.json for integrating Angular Client with Spring Boot Server.

2. How to do

2.1 Spring Boot Server
2.1.1 Dependency

2.1.2 Customer – Data Model

2.1.3 JPA Repository

2.1.4 REST Controller

2.1.5 Configuration for Spring Datasource & JPA properties

2.2 Angular 4 Client
2.2.0 Model

2.2.1 DataService

2.2.2 Components

– CustomersComponent:

– CustomerDetailsComponent:

– CreateCustomerComponent:

– SearchCustomersComponent:

2.2.3 AppRoutingModule

And AppComponent HTML for routing:

2.2.4 AppModule

2.2.5 Integrate Angular Client with Spring Boot Server

– Add proxy.conf.json to root folder of the project:

– Edit package.json file for “start” script:

3. Run & Check Result

Build and Run Spring Boot project with commandlines: mvn clean install and mvn spring-boot:run.
– Run the Angular App with command: npm start.

– Open browser for url http://localhost:4200/:
Add Customer:
angular-4-spring-jpa-postgresql-result-add-customer

Show Customers & click on any Customer:
angular-4-spring-jpa-mysql-result-show-customers

>> MySQL DB:
angular-4-spring-jpa-mysql-result-mysql-db

Search Customer:
angular-4-spring-jpa-mysql-result-search-customers

Go back to ShowCustomers, chose a Customer and click on Delete Customer:
angular-4-spring-jpa-mysql-result-delete-customer

>> MySQL DB after deleting:
angular-4-spring-jpa-mysql-result-mysql-db-after-delete

IV. Source Code

SpringJPAMySQLAngular4
Angular4Client

By grokonez | August 29, 2017.

Last updated on November 28, 2017.



Related Posts


8 thoughts on “Angular 4 + Spring JPA + MySQL example | Angular 4 Http Client – Spring Boot RestApi Server”

    1. Hi boudine,

      You can use the script below:

      More details at:
      How to use Spring JPA MySQL | Spring Boot

      Regards,
      JSA.

  1. Hi I had been build this app in my Intellij Idea and when I try isert data to database from page ask me on user name and password and I don’t know what kind of password and username he is asking. Can you give me advice ?

  2. Hi, i found this error and i don’t know how to correct it. Could you help me plz
    2018-03-23 15:36:42.038 ERROR 10580 — [nio-8080-exec-9] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Handler dispatch failed; nested exception is java.lang.NoClassDefFoundError: antlr/RecognitionException] with root cause

    java.lang.ClassNotFoundException: antlr.RecognitionException

  3. I am not able to run mvn clean install
    getting following error…

    Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 26.731 sec <<< FAILURE! – in com.javasampleapproach.jpamysqlangular4.SpringJpaMySqlAngular4ApplicationTests
    contextLoads(com.javasampleapproach.jpamysqlangular4.SpringJpaMySqlAngular4ApplicationTests) Time elapsed: 0.006 sec << [Help 1]
    [ERROR]
    [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
    [ERROR] Re-run Maven using the -X switch to enable full debug logging.
    [ERROR]
    [ERROR] For more information about the errors and possible solutions, please read the following articles:
    [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoFailureException

Got Something To Say:

Your email address will not be published. Required fields are marked *

*