Shulou(Shulou.com)06/03 Report--

In this issue, the editor will bring you about how to analyze the process of springboot integration of JPA. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

Let's take a look at how it is done.

1. Create a new springboot project and select web, data jdbc, data jpa, and mysql driver.

2. Establish the following directory and structure:

Pom.xml

4.0.0 org.springframework.boot spring-boot-starter-parent 2.2.4.RELEASE com.gong springbootjpa 0.0.1-SNAPSHOT springbootjpa Demo project for Spring Boot 1.8 org.springframework.boot spring-boot-starter-data-jdbc org.springframework.boot spring-boot-starter-data-jpa org.springframework.boot spring-boot-starter-web mysql mysql-connector-java 5.1.41 runtime org.springframework.boot spring-boot-starter-test test org.junit. Vintage junit-vintage-engine org.springframework.boot spring-boot-maven-plugin

3. Configure the connection database and jpa related configuration in application.yml

Spring: datasource: url: jdbc:mysql://192.168.124.22:3306/jpa username: root password: 123456 driver-class-name: com.mysql.jdbc.Driver jpa: hibernate: # Update or create a data table structure ddl-auto: update # console displays SQL show-sql: true

4. Create a new entity package and create a new entity class User.java

Package com.gong.springbootjpa.entity;import com.fasterxml.jackson.annotation.JsonIgnoreProperties;import javax.persistence.*;// uses the JPA annotation to configure the mapping relationship @ Entity / / to tell JPA that this is an entity class (and the class mapped by the datasheet) @ Table (name = "tbl_user") / / @ Table to specify which data table corresponds to; if the default table name is omitted, it is user. @ JsonIgnoreProperties (value = {"hibernateLazyInitializer", "handler"}) public class User {@ Id / / this is a primary key @ GeneratedValue (strategy = GenerationType.IDENTITY) / / private Integer id; @ Column (name = "last_name", length = 50) / / this is a column corresponding to the data table private String lastName; @ Column / / omitting the default column name is the attribute name private String email; public Integer getId () {return id;} public void setId (Integer id) {this.id = id. } public String getLastName () {return lastName;} public void setLastName (String lastName) {this.lastName = lastName;} public String getEmail () {return email;} public void setEmail (String email) {this.email = email;}}

5. Create a new repository package and a new UserRepository.java

Package com.gong.springbootjpa.repository;import com.gong.springbootjpa.entity.User;import org.springframework.data.jpa.repository.JpaRepository;// inherits JpaRepository to complete the operation on the database, specifying the entity class in JdbcRepository and the java type public interface UserRepository extends JpaRepository {} corresponding to the primary key in the database.

6. Create a new controller package and a new UserController.java

After the above configuration, we can directly use some methods in UserRepository to operate the database, which is not very convenient.

Package com.gong.springbootjpa.controller;import com.gong.springbootjpa.entity.User;import com.gong.springbootjpa.repository.UserRepository;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.web.bind.annotation.GetMapping;import org.springframework.web.bind.annotation.PathVariable;import org.springframework.web.bind.annotation.RestController;@RestControllerpublic class UserController {@ Autowired UserRepository userRepository; @ GetMapping ("/ user/ {id}") public User getUser (@ PathVariable ("id") Integer id) {User user = userRepository.getOne (id) Return user;} @ GetMapping ("/ user") public User insertUser (User user) {User save = userRepository.save (user); return save;}}

7. Start the server

Insert a piece of data

Query a piece of data

The above is the editor for you to share how to analyze springboot integration JPA process, if you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.