您好,登錄后才能下訂單哦!
這篇文章主要介紹了springboot整合JPA過程解析,文中通過示例代碼介紹的非常詳細,對大家的學習或者工作具有一定的參考學習價值,需要的朋友可以參考下
接下來具體看看是怎么弄的。
1、新建一個springboot項目,選擇web、data jdbc、data jpa、mysql driver。
2、建立以下目錄及結構:
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.2.4.RELEASE</version> <relativePath/> <!-- lookup parent from repository --> </parent> <groupId>com.gong</groupId> <artifactId>springbootjpa</artifactId> <version>0.0.1-SNAPSHOT</version> <name>springbootjpa</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-jdbc</artifactId> </dependency> <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>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.41</version> <scope>runtime</scope> </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>
3、在application.yml中配置連接數據庫和jpa相關配置
spring: datasource: url: jdbc:mysql://192.168.124.22:3306/jpa username: root password: 123456 driver-class-name: com.mysql.jdbc.Driver jpa: hibernate: #更新或者創建數據表結構 ddl-auto: update #控制臺顯示SQL show-sql: true
4、新建一個entity包,新建實體類User.java
package com.gong.springbootjpa.entity; import com.fasterxml.jackson.annotation.JsonIgnoreProperties; import javax.persistence.*; //使用JPA注解配置映射關系 @Entity //告訴JPA這是一個實體類(和數據表映射的類) @Table(name = "tbl_user") //@Table來指定和哪個數據表對應;如果省略默認表名就是user; @JsonIgnoreProperties(value = {"hibernateLazyInitializer","handler"}) public class User { @Id //這是一個主鍵 @GeneratedValue(strategy = GenerationType.IDENTITY)//自增主鍵 private Integer id; @Column(name = "last_name",length = 50) //這是和數據表對應的一個列 private String lastName; @Column //省略默認列名就是屬性名 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、新建一個repository包,新建一個UserRepository.java
package com.gong.springbootjpa.repository; import com.gong.springbootjpa.entity.User; import org.springframework.data.jpa.repository.JpaRepository; //繼承JpaRepository來完成對數據庫的操作,在JdbcRepository中指定實體類,數據庫中主鍵對應的java類型 public interface UserRepository extends JpaRepository<User,Integer> { }
6、新建一個controller包,新建一個UserController.java
經過上述配置之后,我們就可以直接利用UserRepository中的一些方法進行數據庫的操作啦,是不是很方便。
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; @RestController public 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、啟動服務器
插入一條數據:
查詢一條數據:
以上就是本文的全部內容,希望對大家的學習有所幫助,也希望大家多多支持億速云。
免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。