Spring Boot + Vue.js example | Spring Data JPA + REST + MySQL CRUD

vue-spring-boot-mysql-feature-image

In this tutorial, we show you Vue.js Http Client & Spring Boot Server example that uses Spring JPA to do CRUD with MySQL and Vue.js as a front-end technology to make request and receive response.

Related Posts:
How to use Spring JPA MySQL | Spring Boot
Vue Router example – with Nav Bar, Dynamic Route & Nested Routes

Technologies

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

– Vue 2.5.17
– Vue Router 3
– Axios 0.18.0

Overview

This is full-stack Architecture:

spring-boot-vue-example-spring-data-jpa-rest-api-mysql-architecture

Demo

1. Spring Boot Server

spring-boot-vue-example-spring-data-jpa-rest-api-mysql-architecture-server

2. Vue.js Client

spring-boot-vue-example-spring-data-jpa-rest-api-mysql-client

Practice

1. Spring Boot Server

spring-boot-vue-example-spring-data-jpa-rest-api-mysql-project-structure-server

Customer class corresponds to entity and table customer.
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: getAllCustomers, postCustomer, deleteCustomer, findByAge, updateCustomer.
– Configuration for Spring Datasource and Spring JPA properties in application.properties
Dependencies for Spring Boot and MySQL in pom.xml

1.1 Dependency

1.2 Data Model

model/Customer.java

1.3 JPA Repository

repo/CustomerRepository.java

1.4 REST Controller

controller/CustomerController.java

1.5 Configuration for Spring Datasource & JPA properties

application.properties

2. Vue.js Client

spring-boot-vue-example-spring-data-jpa-rest-api-mysql-project-structure-client

package.json with 3 main modules: vue, vue-router, axios.
– 4 components: CustomersList, Customer, AddCustomer, SearchCustomer.
router.js defines routes, each route has a path and maps to a component.
http-common.js initializes HTTP Client with baseUrl and headers for axios HTTP methods.
vue.config.js configures port for Vue App.

For more details about how to use Vue Router in this example, please visit:
Vue Router example – with Nav Bar, Dynamic Route & Nested Routes

2.0 Setup Vue Project & Router
Init Project

Point cmd to the folder you want to save Project folder, run command:
vue create vue-springboot

You will see 2 options, choose default:

vue-create-project-config

Add Vue Router to Project

– Run command: npm install vue-router.
– Import router to src/main.js:

Define Routes

src/router.js:

App template with Navbar and router-view

src/App.vue:

2.1 Initialize HTTP Client

Install axios with command: npm install axios.
Then create http-common.js file:

2.2 Components
List of Items

components/CustomersList.vue

Item Details

components/Customer.vue

Add Item

components/AddCustomer.vue

Search Items

components/SearchCustomers.vue

2.3 Configure Port for Vue App

vue.config.js

Run

– Spring Boot Server: mvn clean install and mvn spring-boot:run.
– Vue.js Client: npm run serve.

Open Browser with Url: http://localhost:4200/.

Source Code

SpringBootRestMySQL
vue-springboot

By grokonez | September 16, 2018.



Related Posts


2 thoughts on “Spring Boot + Vue.js example | Spring Data JPA + REST + MySQL CRUD”

  1. This tutorial doesn’t contain the css configuration like “class = button is-small btn-danger”, class=”btn btn-primary”.
    Could you tell me how to make them, cause I can’t show the button and click them to delete…

    1. Hi xuanning meng,

      You can add Bootstrap to public/index.html with one line of code:

      Regards,
      grokonez.

Got Something To Say:

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

*