這篇文章主要介紹了Spring boot2.x中集成H2數(shù)據(jù)庫(kù)代碼實(shí)例,文中通過(guò)示例代碼介紹的非常詳細(xì)，對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值,需要的朋友可以參考下

在spring boot中集成

1.添加依賴

<dependency>  <groupId>org.springframework.boot</groupId>  <artifactId>spring-boot-starter-data-jpa</artifactId></dependency><dependency>  <groupId>com.h2database</groupId>  <artifactId>h2</artifactId>  <scope>runtime</scope></dependency><dependency>  <groupId>org.projectlombok</groupId>  <artifactId>lombok</artifactId></dependency>

2.添加H2相關(guān)配置，修改application.properties文件

spring.jpa.database=h2spring.jpa.show-sql=true#ddl執(zhí)行方式，update create 等spring.datasource.url=jdbc:h2:./data/test;AUTO_SERVER=TRUEspring.jpa.hibernate.ddl-auto=updatespring.datasource.username=saspring.datasource.password=123456spring.datasource.driverClassName=org.h2.Driverspring.h2.console.path=/h2-consolespring.h2.console.enabled=true

說(shuō)明：

spring.datasource.url

數(shù)據(jù)庫(kù)文件

(1)內(nèi)存數(shù)據(jù)庫(kù)

jdbc:h2:mem:DBName

內(nèi)存數(shù)據(jù)庫(kù)的數(shù)據(jù)存在內(nèi)存中，當(dāng)程序停止時(shí)，不會(huì)被保存會(huì)丟失

eg：

spring.datasource.url=jdbc:h2:mem:test

(2)文件數(shù)據(jù)庫(kù)

jdbc:h2:file:{FilePath} 也可以簡(jiǎn)化為 jdbc:h2:{FilePath}

FilePath的格式

(3)遠(yuǎn)程數(shù)據(jù)庫(kù)

jdbc:h2:tcp://<{IP|hostname}>[:{Port}]/[]<{dbName}>

附加參數(shù)：

3.代碼

domain層，即User類(entity)

package com.example.demo.domain;import lombok.AllArgsConstructor;import lombok.Data;import lombok.NoArgsConstructor;import javax.persistence.*;@Entity@Table(name = "user")@Datapublic class User {  @Id  @GeneratedValue(strategy= GenerationType.AUTO)  private int id;  private String name;  public int getId() {    return id;  }  public void setId(int id) {    this.id = id;  }  public String getName() {    return name;  }  public void setName(String name) {    this.name = name;  }}

dao層，即UserRepository 接口

package com.example.demo.dao;import com.example.demo.domain.User;import org.springframework.data.jpa.repository.JpaRepository;import org.springframework.stereotype.Repository;import java.util.List;@Repositorypublic interface UserRepository extends JpaRepository<User,Integer> {  List<User> getUsersByName(String Name);}

controller層，即Demo

package com.example.demo.controller;import com.example.demo.dao.UserRepository;import com.example.demo.domain.User;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RestController;import java.util.List;@RestControllerpublic class Demo {  @Autowired  private UserRepository repo;  @RequestMapping("find")  public List<User> find() {    return (List<User>) repo.findAll();  }}